Displaying cell contents on one sheet

P

Peter J Watson

I want to input a cell reference into a cell and then display the contents of
the same cell references from other sheets within the same workbook. How do
I do this?
 
K

KePaHa

I want to input a cell reference into a cell and then display the contents of
the same cell references from other sheets within the same workbook. How do
I do this?
Click to expand...
 
P

Peter J Watson

Not quite what I am looking to do. I have information on 7 sheets (2 to 8),
each one represents a courier servive - on each sheet the columns (A, B, C
etc) represent area codes and the rows (1,2,3 etc) represent weights. I want
to type into cell A1 <AC100> on sheet 1, where the area code is AC and the
weight to be used eg 100. I would like to display in C1:C6 the values from
sheet2!AC100, sheet3!AC100 etc

Any ideas?
 
K

KePaHa

So - to be clear - user will type in a cell address (like D55) rather than a
zip code?

If so, how about this formula =INDIRECT("Sheet2!" & A1) in cell B1 to
take what is in A1, concatenate it with the proepr Sheet tab name, and then
retieve its contents?

~~~~~~~~~~~~~~~~~~
 
Top