excel

  • Thread starter Thread starter Jim Weibert
  • Start date Start date
J

Jim Weibert

I have several worksheets that are linked to another
worksheet containing the raw data. I want to continue
adding data each month in the raw data worksheet using
another column. ie: Jan 03 is in column A and Feb 03 is
in column B, etc. How can I get the linked worksheet to
recognise that I made a change? I can go into each link
and edit the cell from A to B. But, what I would rather
do is reference in each cell formula another cell on that
worksheet that I can change the column letter. ie: =sheet!
(cell containing a letter)1, this way I change the cell
letter and all the formulas change to that letter
representing the new column of data in the other
worksheet. So far I have not been able to figure this one
out.
 
Jim

Assuming raw data worksheet is Sheet1

=INDIRECT("Sheet1!"&$G$1&ROW())

Enter in sheet2 and drag/copy down.

Enter a letter A or B in G1 on sheet2 to reference column A or B on Sheet1

Gord Dibben Excel MVP XL2002
 
what is the meaning of MS Excel for windows?
are the parts of MsExcel?
what is the meaning of worksheet?
" " " " " workbook?
cell?
range?
chart?
sorting?
 
Back
Top