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
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