Hello clever Excellers..
I have attached a file that has two pages one being the main table and the other being some data I want to use to populate the main table.
I had created a valid list on the main sheet that used the months from the other data table to then fill in two cells one showing last years figure and in the other this years figure. My valid list wont now work:-( although I created it in 2010 and am using 2003 at home...
So I would like the outcome to be that when you select any month on the drop down list in the main sheet, it will look up the values on the other data sheet and fill them into a series of cells changing depending on the month you select.
I hope this makes sense - and thanks in advance!
I have attached a file that has two pages one being the main table and the other being some data I want to use to populate the main table.
I had created a valid list on the main sheet that used the months from the other data table to then fill in two cells one showing last years figure and in the other this years figure. My valid list wont now work:-( although I created it in 2010 and am using 2003 at home...
So I would like the outcome to be that when you select any month on the drop down list in the main sheet, it will look up the values on the other data sheet and fill them into a series of cells changing depending on the month you select.
I hope this makes sense - and thanks in advance!