Sheet wise details

[jayesh]

I have 20 different sheets in one file. All sheet has Income Expense statement of 20 different centers. Is there a way that in master sheet if I write name of the sheet or header of that sheet, then I get the Income Expense Statement for that perticular center/sheet.
All sheet has same format.

 

[Jonmo1]

Sure, try this..

Put your SheetName in say A1
And the value you want to retrieve is in say E10 on each sheet.

=INDIRECT("'" & A1 & "'!E10")


Hope that helps.

 

[jayesh]

Can I get all the rows and columns. I have whole Income Expenses Statement in that sheet. Can I get the whole.

 

[Jonmo1]

How much data are you talking about (how many columns/how many rows) ?
Post the Actual full range you want to retrieve.

INDIRECT is a volatile function that recalculates everytime anything changes.
And if it's used ALOT, it will hinder the performance of the book.