Results 1 to 18 of 18

Add 2 different times into 2 cells based on if a cell is blank or not.

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-02-2011
    Location
    Rugby, England
    MS-Off Ver
    Office 365
    Posts
    879

    Add 2 different times into 2 cells based on if a cell is blank or not.

    Morning happy campers!

    Attached is a sample showing desired result.

    5 Tabs - mon-Thu + Final Result (collation of whole week) (current sheet is same layout as tab - Result Final, only 1 tab in workbook.

    My current code will place the data in columns B, E, H, K, N, Q, S, W (based on what day it is run) (courtesy of Arlu!)

    I would like a message box with yes or no option (this alone i can do)
    -BUT-
    What i am unsure on is getting the response from the yes/no option to either run a 2nd macro or not.
    This also needs to be tied into the days date.

    So, i run my code as normal on Mon, data appears in Columns B & E (as on Mon tab), then, i would like the message box to appear (text can be anything as i will change) and if yes is selected then the following will happen: (in cell C6) =If(E6 is blank, show me nothing, if not, show me "06:00") -ALSO- (in cell D6) =if(E6 is blank, show me nothing, if not, show me "14:30")
    If no is selected then macro finishes without starting the 2nd one.

    Then the same on Tue, only this time the reference cell will be H6, with 06:00 & 14:30 being entered into F6 & G6.
    Then the same on Wed, only this time the reference cell will be K6, with 06:00 & 14:30 being entered into I6 & J6.
    Then the same on Thu, only this time the reference cell will be N6, with 06:00 & 14:30 being entered into L6 & M6.
    Then the same on Fri, only this time the reference cell will be Q6, with 06:00 & 14:30 being entered into O6 & P6.
    Then the same on Sat, only this time the reference cell will be T6, with 06:00 & 14:30 being entered into R6 & S6. (not always ran over weekend)
    Then the same on Sun, only this time the reference cell will be W6, with 06:00 & 14:30 being entered into U6 & V6. (not always ran over weekend)

    Kind Regards

    Galvinpaddy
    Attached Files Attached Files
    Last edited by galvinpaddy; 02-01-2013 at 08:31 AM.

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