Pulling Data from a certain Cell Block

FireOracle

New Member
Joined
Oct 3, 2006
Messages
1
I was trying to pull data from a Data Input sheet and place it on several other sheets. When I try to use the ='Input Data'!A1 , when i move the data on the input page it pulls from the new loctions. Is there anyway I can pull data from a specific cell block and no matter wether it is deleted or moved it will always pull info from that cell block? I have tried the $A$1 , it only works if you are moving the cell you typed it in, not the cell you are pulling data from. Thanks! Please respond.
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

pgc01

MrExcel MVP
Joined
Apr 25, 2006
Messages
19,870
Hi FireOracle
Welcome to the board

Please try

=INDIRECT("'Input Data'!A1")

Hope this helps
PGC
 

Watch MrExcel Video

Forum statistics

Threads
1,114,061
Messages
5,545,763
Members
410,704
Latest member
Cobber2008
Top