J
Jennifer
I have a workbook that will have 100+ sheets in it. I
want to use a beginning number in a cell on the first
sheet and then on the following sheets in the same cell
have a formula that adds 1 to the number in the same cell
on the previous sheet. For example, the first sheet has
497 in cell B2. In each successive sheet, I would have a
formula in cell B2 that would be '=sheet1!B2+1' to give me
498, then 499, then 500, etc. I want to copy the formula
to each successive sheet and have it automatically adjust
the sheet it is referencing to be the previous sheet.
However, when I copy the formula, it does not change the
sheet reference from the original sheet. I do not want to
have to manually change 100+ formulas. This used to work
in Lotus. Is there any easy way to do this?
Also, is there any way to automatically change the sheet
tab name for the same reason? When inserting sheets in
Lotus, it used to insert the names based on the previous
sheet. That way I had a sheet name of 497 and the same in
cell B2.
I have this problem at the beginning of every year.
Thank you for any help,
Jennifer
want to use a beginning number in a cell on the first
sheet and then on the following sheets in the same cell
have a formula that adds 1 to the number in the same cell
on the previous sheet. For example, the first sheet has
497 in cell B2. In each successive sheet, I would have a
formula in cell B2 that would be '=sheet1!B2+1' to give me
498, then 499, then 500, etc. I want to copy the formula
to each successive sheet and have it automatically adjust
the sheet it is referencing to be the previous sheet.
However, when I copy the formula, it does not change the
sheet reference from the original sheet. I do not want to
have to manually change 100+ formulas. This used to work
in Lotus. Is there any easy way to do this?
Also, is there any way to automatically change the sheet
tab name for the same reason? When inserting sheets in
Lotus, it used to insert the names based on the previous
sheet. That way I had a sheet name of 497 and the same in
cell B2.
I have this problem at the beginning of every year.
Thank you for any help,
Jennifer