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
Bookmarks