select date which updates sheet

[lprenrut]

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

[JBeaucaire]

1) Yes, but this would require VBA formatting.
2) If VBA is ok, then you'll need to post a sample workbook clearly demonstrating all the formatting requirements and how they change based on your selection(s).

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.