copying data by way of a formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook (Excel 2002) that has a parent sheet(Sheet1) that feeds to 12 (one for each month) other sheets. The only thing that I wnat to be the same on all the sheets is the first column. Right now I have a formula on the calendar sheets (=Sheet1!$A8) and its works, but not if someone goes in and either deletes or inserts a row. Is there a way to do this with a formula or a command so that I can create it and leave it alone?
 
Hi
if you start this formula in row 8 try
=INDIRECT("'sheet1'!A" & ROW())

Adapt ROW() to your needs (subtract or add a constant value depending
on your starting row for this formula)

--
Regards
Frank Kabel
Frankfurt, Germany

sandy said:
But how do I get it so that it does the column down to say row
Click to expand...
75 without having to change the formula manually each time?
 
Back
Top