J
Jay
I had a workbook with many worksheets (e.g. WA, WB, WC). Then, in one of the
worksheet, i had formulas that reference to these worksheet (e.g. 'WA'!A1).
I would get updates of the worksheets from my colleagues whom i would latter
update it to the workbook. What i do is
1. Copy all the updated worksheets to the workbook (which it will named as
WA(2), WB(2), WC(2) ).
2. Then, i delete off the original worksheets (except the one with the
formula) and rename WA(2) to WA, WB(2) to WB and etc.
However, the worksheets with the referencing formula doesn't automatically
update itself to the updated worksheet (even though the worksheet name is now
the same of the previous worksheet). How do i ensure that the formula is
automatically updated to the 'new' worksheet name?
Is there any way we could do this?
Thanks.
worksheet, i had formulas that reference to these worksheet (e.g. 'WA'!A1).
I would get updates of the worksheets from my colleagues whom i would latter
update it to the workbook. What i do is
1. Copy all the updated worksheets to the workbook (which it will named as
WA(2), WB(2), WC(2) ).
2. Then, i delete off the original worksheets (except the one with the
formula) and rename WA(2) to WA, WB(2) to WB and etc.
However, the worksheets with the referencing formula doesn't automatically
update itself to the updated worksheet (even though the worksheet name is now
the same of the previous worksheet). How do i ensure that the formula is
automatically updated to the 'new' worksheet name?
Is there any way we could do this?
Thanks.