Update order sheet when another date worksheet is selected

lprenrut

New member
Joined
Dec 3, 2011
Messages
1
Reaction score
0
Points
0
Hi Everyone
Not sure if i'm in the right place but here goes

I've got 5 worksheets named, Order - 01DEC - 02DEC - 03DEC - 04DEC

On the Order sheet is all the calculations taken from 02DEC also in cell M2 is a dropdown list of dates

What I want if it is possible is to select a date from the dropdown list 03DEC for example and for the Order sheet to be updated with data from 03DEC worksheet automatically

What I am doing at the moment is changing the date in the formula bar manually eg 02DEC to 03DEC

Thanks in advance
 

Attachments

  • Order.zip
    1.1 MB · Views: 30
Back
Top