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
Bookmarks