Hi
This is my very first post so here goes
I have a worksheet called Order & other worksheets called 01DEC 02DEC 03DEC etc...
On the Order worksheet in cell M2 I have a dropdown list of days covering the whole year
On the Order sheet I've done all the formatting that corresponds to sheet 01DEC, but I dont want to do that everytime I select a different worksheet
I was wondering if I select a date from cell M2 on the Order sheet could it look at the corresponding worksheet say 02DEC and update all the formatting instead of me manually changing the formatting
many thanks
Larry
Bookmarks