Hi
I'm trying to create a speadsheet for work with a formula I don't know how to work.
My staff enter data every day in to a particular sheet - in this example the sheet is called Historic Daily Data. I want the second sheet, called 'Daily Snapshot', to populate with data from the Historic Daily Data sheet, depending on what date is selected in the drop down list in the Daily Snapshot sheet.
I've attached an example as I may not have explained it well. Hopefully it makes sense. Obviously the example is the very basics, but the formula required will be the same.
oh, this test is on my home pc which is excel 2010 but at work we use 2003 so any formulas will need to work on that.
thanks in advance.
test.xlsx
Bookmarks