Indirect function

[Baldev Kumar]

Dear Expert,

Please help me to use the "indirect function" in excel 2007
i want the result in sheet "sheetname", i try the function, but there is something missing in the formula

[Pete_UK]

Put this formula in B2 of your Sheetnames sheet:

Please Login or Register  to view this content.

As your sheet names contain spaces, you have to include the apostophes within the address string. Note that if you copy this down beyond row 6 you will get #REF! errors, as those sheets don't exist in your file.

Hope this helps.

Pete

[Baldev Kumar]

Thank you, this is really helpful.

[Pete_UK]

Glad to hear it - thanks for feeding back. Perhaps you can mark the thread as Solved.

Pete