using data from spreadsheets depending on a value in another cell

[chubbster31]

Hi

I have used data validation to restrict the choice of values in a cell to say 5 different values which alters all the data in that sheet. What I want to do is depending on what value I choose in that data validated cell, I want to use information from a certain sheet. So for example, in my case, if i choose the value (date) 20/02/1997 in the data validated cell, I want all my formulas to be using data from another sheet entitled 20 Feb 97 for example.

I hope I've explained this well enough,

Thanks

[Pete_UK]

You could use something like this:

=INDIRECT("'" & TEXT(D1,"dd mmm yy") & "'!S1")

where D1 contains the date (i.e. your validated cell) and S1 is the source cell in that sheet where you want to bring the data from.

Hope this helps.

Pete

[djm198]

Let us know if Pete_UK's answer works, or if not, if you find an answer to this, I would be interested in using this if you find a solution.

However, just to be super negative with no reason at all, other than it is Wednesday, I bet I would create a template with the only requirement for the new user is to name the sheet correctly and dump the data into it, and they would still mess it up.