copying data by way of a formula

[Sandy]

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?

 

[Frank Kabel]

Hi
try
=INDIRECT("'sheet1'!A8")

 

[Frank Kabel]

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

But how do I get it so that it does the column down to say row

75 without having to change the formula manually each time?