Hi, gurus

I have a question about quotation reference issue:

An Excel workbook has a set of source worksheets,say,sheet1-sheet10.
They have the SAME style but different values.
Now on sheet11 in the same workbook, I want to quote values from one
source sheet. Currently I have to update all of the reference links
manually (just source sheet name, Row/Column position the same) if I
switch from one source sheet to another.

Can I somehow define a "source sheet" cell on sheet 11 so that all of
referenced values can be automatically updated as "source
sheet!R[n]C[n]" together with cell input?

Thanks for your help!

One way:

R1C1: Sheet2
R1C2: =INDIRECT(R1C1 & "!R[n]C[m]",FALSE)


In article <(E-Mail Removed)>,
"Ming" <(E-Mail Removed)> wrote:

> An Excel workbook has a set of source worksheets,say,sheet1-sheet10.
> They have the SAME style but different values.
> Now on sheet11 in the same workbook, I want to quote values from one
> source sheet. Currently I have to update all of the reference links
> manually (just source sheet name, Row/Column position the same) if I
> switch from one source sheet to another.
>
> Can I somehow define a "source sheet" cell on sheet 11 so that all of
> referenced values can be automatically updated as "source
> sheet!R[n]C[n]" together with cell input?

Got it! Thanks!