Forum Discussion
Update Tab References when Dragging Formulas to Adjacent Cells
I have a workbook that I take month performance data using a separate sheet (tab) for each month with a summary tab to sum the data and use for graphs. The problem is that I think or something to ad...
The sheet references won’t change when you drag a formula, however you can use find / replace to update with another sheet name once formulae are duplicated (but you will need to do this for each column of formulae:
Highlight the column to update, hit CTRL+H, enter the sheet name in the duplicated formula, e.g. January, into the ’find’ field; enter the sheet name that it should be linked to, e.g. February, into the ‘replace’ field; then click the replace all button.
Highlight the column to update, hit CTRL+H, enter the sheet name in the duplicated formula, e.g. January, into the ’find’ field; enter the sheet name that it should be linked to, e.g. February, into the ‘replace’ field; then click the replace all button.
