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?

"KePaHa" wrote:

On Sheet 2, cell B12, type =Sheet1!G23 to display the contents of that cell

"Peter J Watson" wrote:

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?

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?

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?

~~~~~~~~~~~~~~~~~~

"Peter J Watson" wrote:



"KePaHa" wrote:

On Sheet 2, cell B12, type =Sheet1!G23 to display the contents of that cell

"Peter J Watson" wrote:

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?

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?