+ Reply to Thread
Results 1 to 2 of 2

Custom formula run in blanks for varying range sizes

  1. #1
    Registered User
    Join Date
    07-28-2009
    Location
    California
    MS-Off Ver
    Excel 2007
    Posts
    1

    Unhappy Custom formula run in blanks for varying range sizes

    Okay. I need to be able to calculate the difference between the last day and first day of a job so that the first day is included in the calculation. I have been entering the same formula manually by hand for each range.

    The tricky part (for me at least) is that I need a macro that will find the blank spaces and automatically apply the above formula to the correct range of data until it reaches the end of the sheet for both columns.

    Each sheet I am working with has about 30 different ranges there are approximately 30 sheets to do this for. I think I would be bald if I tried to do this all manually.

    Any direction at all will be GREATLY appreciated.

    Days Days Plus Breaks

    36 60
    37 61
    38 62
    39 63
    40 64
    41 67
    42 68
    43 69
    44 70
    45 71
    46 74
    47 75
    48 76
    49 77
    Blank Blank <-----this is where i would want the 77-60+1 to calculate
    4 41
    5 42
    6 43
    7 44
    8 45
    9 48
    10 49
    11 50
    12 51
    Blank Blank <-----this is where i would want the 51-41+1 to calculate
    1 1
    2 4
    3 5
    4 6
    5 7
    Blank Blank
    1 1
    Blank Blank
    3 73
    4 74
    5 77
    6 78
    7 79
    8 80
    9 81
    Blank Blank
    1 1
    2 2
    3 3

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: Custom formula run in blanks for varying range sizes

    Welcome to the Board.

    Perhaps something like the below, note I have assumed values in cols A & B are constants & formulae to go into blank cells in B.

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1