Reference cell

  • Thread starter Thread starter Ming
  • Start date Start date
M

Ming

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!
 
Back
Top