Using a string(stored in a cell) to specify the name a sheet to import data from

[AndyMcNeil]

Hi All,

Is it possible to do the following without code preferabley:

I want to create a cover sheet for a presentation of some figures. Depending on the option selected at the top probabley a drop down list box will determine the population of the cover sheet.

For example

Sheet1 is my cover sheet

Sheet2, Sheet3, Sheet4, Sheet5 are my data sheets

On Sheet1 you would choose from a drop down list box (A3) which data sheet to import from.

In selected cells i would use a formula similar to the following

='A3'! H4

Where A3 is actually the name of one of the data sheets.

Many thanks for all your help in advance

[solnajeff]

Hi

You need to use the INDIRECT function so that it evaluates correctly.

Please Login or Register  to view this content.

regards

Jeff

[broro183]

hi Andy,

Check out Indirect function in the Excel Help files. Be aware that if you use Indirect in a lot of cells, it may slow your spreadsheet down because it is a volatile function.

edit: Ooopps! I was too slow

hth
Rob

[AndyMcNeil]

Works Perfectly,

Huge thanks guys.

Have a Great Christmas

[broro183]

Thanks for the feedback - I'm pleased we could help

Can you please mark the thread as solved (see the FAQ section for instructions)?

Thanks
Have a good Christmas
Rob