Indirect Function Summary Tab Template - Need Help!

adbcrazy

New Member
Joined
Mar 8, 2010
Messages
3
Dear users,
I am looking to create a summary worksheet using the indirect function to collect "Prices" from several tabs in the same worksheet.

As I have about 40 workbooks to do this for, I want to create a Summary Template I can copy and paste into the other workbooks:
As seen in MrExcel # 681
http://www.youtube.com/watch?v=lgwc81fRSP4

The only problem is I cant get it to work>? Its probably something very simple but i've missed it.
Can anyone help me?

=INDIRECT($A$4&"!Cell(""address",C55)

Where:
A4 - is the name of the tab I want the price data from (no spaces)
c55 - is the cell(with the price in it) I want to bring to the summary sheet

Thanks in advance,
Andy B
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,342
Untested but try

=INDIRECT("$A$4!"&Cell("address",C55))
 
Last edited:

Jonmo1

MrExcel MVP
Joined
Oct 12, 2006
Messages
44,061
Welcome to the board...

try

=INDIRECT($A$4&"!"&CELL("address",C55))
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
2 options...
=INDIRECT($A$4&"!C55") or =INDIRECT(ADDRESS(55,3,,,$A$4))
 

Watch MrExcel Video

Forum statistics

Threads
1,102,287
Messages
5,485,906
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top