Search:

Type: Posts; User: pipsmultan

Page 1 of 2 1 2

Search: Search took 0.02 seconds.

  1. Re: Need help to fix ''remove/add new added value next to its previous value''

    Hi west,

    Thank you fro your reply.
    Can you please design a sample for us, let us give it a shot how much that pop up a little userform is helpful.

    Thank you again

    Best,
  2. Need help to fix ''remove/add new added value next to its previous value''

    I have code below which help me to achieve is in the Column M we have a value, When ever user enter Value in 'M14:M1048576'. Previous value enter not remove instead of that add new value next to its...
  3. Replies
    0
    Views
    528

    Exam Sitting plan got confusing :(

    Respectable Greetings to all

    i m working on a Exam setting plan for students in excel sheet. We have 10 class Room and every class room have 3 section. What i m trying to achive is a students...
  4. Replies
    2
    Views
    950

    Re: Make Automated timetable :confused:

    Thanks for you reply and help :)

    what i trying to accomplish through an automated time table is when i enter the following details in the cells and on click of a button excel make an automated...
  5. Replies
    2
    Views
    950

    Make Automated timetable :confused:

    Respectable Greetings to every one :)

    I am running into big problem and challenge :confused: :(

    I have two sheets called “Timetable” sheet & “Teachers Details” sheet. what i am trying to...
  6. stuck in VB Form of Daily School Periods Time: confused

    Respectable Greeting to all

    i am stuck in VB Form of Daily School Periods Time
    I want to make a Form as shown in image/Excel sheet to calculate every period from 1st to 8th (so on) Automatically...
  7. Re: Macro Button to Print required Pages of Excel

    i hav tested again but my test is not working correctly with your Post # 15 code

    but

    when i run the following code, it Print ok but with same issue of Post #1



    Best Regards
  8. Re: Macro Button to Print required Pages of Excel

    thanks for your reply

    :( Now printer only print the 1st Row and leaving the entire page blank :(

    High Regards
  9. Re: Macro Button to Print required Pages of Excel

    :) thanks your code is working good printer is printing the first page to the top row now :)

    but the only problem is "if i test the first day to be weekend, printer print the first page" :(

    any...
  10. Re: Macro Button to Print required Pages of Excel

    the Code is Ok but When i run the MAcro code it cut the Top 2-3 rows while printing :(

    Regards
  11. Re: Macro Button to Print required Pages of Excel

    sorry for the late response

    the formula is working great but there is some printing problem, it does not print from the top ROW & Columns

    i hav reattach my Original Soft Excel copy plz check...
  12. Re: Macro Button to Print required Pages of Excel

    code not working :(

    regards
  13. Re: Macro Button to Print required Pages of Excel

    Kind Thanks for your quick reply

    plz find the .zip attach file
    119949

    best regards
  14. Macro Button to Print required Pages of Excel

    Greeting to all :)

    I want a "Macro Print Button" which can Print all Pages top to Down
    Except "Saturday & Sundays" pages
    Can anyone provide a solution?

    plz find the attachment...
  15. Re: Auto pick "specific Date" and "specific cells"

    Yes :) but if you like to calculate it through VB, than its ok..

    Best Regards
  16. Re: Auto pick "specific Date" and "specific cells"

    Yes, But Only the ROW "106" code doesn't need to calculate the totals through VB. i will calculate it through Excel Formula

    Kind Regards
  17. Re: When Control Tranfer from One Cell to another Cell :confused:

    :) :) :) That is amazing...that formula is beyond brilliant. Thanks so much for your help, it is very much appreciated ! :) :) :)


    Sorry right now i m getting this message "spread some...
  18. [RESOLVED] When Control Tranfer from One Cell to another Cell :confused:

    My very Respectable Greeting to All.

    i am facing issue in my Formula of Leave Balance & Half Day Leaves. "Which i think it can be solve by VB Code"

    Plz See the Attachment Excel file or Image
    ...
  19. Re: Auto pick "specific Date" and "specific cells"

    Any Solution So Far

    Regards
  20. Re: Auto pick "specific Date" and "specific cells"

    i am so Sorry i forgot to upload the NEW Updated Sheet of excel

    plz check the below

    http://1drv.ms/1zRdHjR




    When you open the newly Attach file you will clear with point# 4 & 5
  21. Re: Auto pick "specific Date" and "specific cells"

    Sorry for late reply, hope you are doing good :)

    i have attach New updated Final Sheet of excel plz check

    #1 The first date in the vertical list but it is From "23-12-2013 to 22-1-2014
    #2 ...
  22. Re: Auto pick "specific Date" and "specific cells"

    :) :) That is amazing...that formula is beyond brilliant. Thanks so much for your help, it is very much appreciated ! :) :)

    i hav attach my original file plz pl check it

    http://1drv.ms/1vlgNyB...
  23. Re: Auto pick "specific Date" and "specific cells"

    what i am trying to do is i want an Excel to AUTO pick dates and "M/L, H/L, C/L" dates wise in "A70" cell down & across, to show how many "M/L, H/L, C/L" have been taken and on which dates so that i...
  24. Re: Auto pick "specific Date" and "specific cells"

    first of all i am very please to see u both "vbfbryce" & "terry002" on my thread :) :)

    i think array formula can do this job

    i have attach same file again with array formula but there is issues...
  25. Re: Auto pick "specific Date" and "specific cells"

    Bump No Solution from anyone :(
  26. Re: Auto pick "specific Date" and "specific cells"

    Yeah Sure, i hav 2 month & year from ("AE2" to "AI2") & ("AE7" to "AI7")

    in fornt of month Jan with Year 2014 (B3 & B4) i have Dyas from "D3 to AH3" and Dates "D4 to AH4" and from "D5 to AH5" it...
  27. Auto pick "specific Date" and "specific cells"

    Greetings to everyone

    i m stuck into some issue, i want to pick specific date and "Medical Leaves" & Casual Leaves" to make only specific record of "Medical Leaves" & Casual Leaves" etc from...
  28. Replies
    0
    Views
    426

    Any Bets alternate of "=" function

    Respectable Greeting to All :)

    i have number of Month Files "Jan", "Feb" soon in a folder & all "Jan", "Feb" files are link with single file called "Leaves Records".

    problem which i am facing...
  29. Replies
    7
    Views
    1,204

    Re: [RESOLVED] "Add" formula got confused :(

    my Pleasure

    thanks-a lot

    regards
  30. Replies
    7
    Views
    1,204

    Re: "Add" formula got confused :(

    Thanks so much for your help, it is very much appreciated ! :) :thumb:

    When i try to give Reputation to You it says "You must spread some Reputation around before giving it to "terry002" again."
    ...
  31. Replies
    7
    Views
    1,204

    Re: "Add" formula got confused :(

    the Cell "AK7" is not giving the correct answer when i apply your formula

    Just want to clear you again

    1x H/L = +1 Working Day
    2x H/L = -1 Working Day
    3x H/L = +1 & -1 Working day = add (1)...
  32. Replies
    7
    Views
    1,204

    [RESOLVED] "Add" formula got confused :(

    Greeting to all

    i am facing some problem in adding Number of Half Days (H/L) in my worksheet, i have a formula in "AN7" which is working fine but the formula in "AK7" is not working exactly as i...
  33. Re: Add & Deduct Formula :confused:

    When i try to give Reputation to You it says "You must spread some Reputation around before giving it to vbfbryce again."

    i will remember that "I owe you one" :)
  34. Re: Add & Deduct Formula :confused:

    :thumb: That is amazing...that formula is beyond brilliant. Thanks so much for your help, it is very much appreciated ! :thumb:

    Best Regards
  35. Re: Add & Deduct Formula :confused:

    i have updated the excel attached file bcz i hav uploaded wrong file... sorry for that
  36. [RESOLVED] Add & Deduct Formula :confused:

    Greeting to all,

    i m stuck into a simple formula which i cant figure it out :confused:

    i have an attendance sheet with - Present (P), Half Day (H/L), Casual Leave (C/L) and Absent (A)

    i want...
  37. Re: Display month formula in certain cell :confused:

    Thank you very much for telling me how much you have liked my work. I'm so pleased to know that it brightens your knowledge. :)

    Thank again for your kind comments. :) :)
  38. Re: Display month formula in certain cell :confused:

    Reputation has been added & thread has marked as ReSolved
  39. Re: Display month formula in certain cell :confused:

    :) :) Superb, Excellent, Brilliant............. yes this want i want trying to achieve :) :)

    i was working on it from last 2 weeks and you solve it like a piece of Cake

    Thank you from the...
  40. Re: Display month formula in certain cell :confused:

    when you click on the above link it will open online in Excel than what you need to do is
    click on File> Save As> Download a Copy

    Regards
Results 1 to 40 of 55
Page 1 of 2 1 2



Click Here to Expand Forum to Full Width