If you are inserting lines on all sheets, then the formula may be adjusting
automatically to reflect the new location of the cell it is refering to.

In otherwords, if I put in the formula

=Receipt!B6 in sheet1
then go to Receipt and insert a new row #2 (or any row prior to 6), then the
formula in Sheet1 will adjust to

=Receipt!B7

since you might be working with the last row in each sheet, this is a
distinct possibility.

--
Regards,
Tom Ogilvy



"Carroll" wrote in message
oups.com...
Thanks you all for looking at this. While I have gotten it to work
just fine (in isolation), my "live" spreadsheet does not behave so
well. I have looked at this so many ways and have tried many minor
variations. In fact, I have a macro that inserts a line on every sheet
of my live spreadsheet, and some sheets in the spreadsheet have no
problem at all, while others fail to copy it down properly. I have yet
to isolate the problem.

Carroll