I'm trying to do a VBA that will input a TIME STAMP when ROW1's (someone said "accross the columns") input cells is all filled with data.
I refer to ROW because I need to verify at what time was each day's cleaning complete--RmA:RmD were completed at what time..
I made a simple excel to illustrate.
ONE row is just a Date and rooms A through E
Below these are values: Date is filled, and whether each room was clean.
If all of the cells are filled in, I would like a times stamp to see what time it was complete.
Date Clean RmA Clean RmB Clean RmC Clean RmD Clean RmE Time Completed
22-May Yes Yes N/A Yes Yes TIME STAMP!
23-May Yes Yes Yes (NO TIME STAMP)
Thanks,
Bookmarks