I've got two spreadsheets that I have to merge (copying sheets from one into the other) but run into a problem with named cells in each spreadsheet having the same name.
Is there a "fast" way to rename a named cell in a spreadsheet so the cell will have a new name and all the cells that reference it will be updated? If I just create a new name for the cell I have to select all the cells in the spreadsheet and do a find/replace to get all the formulas working again.
Is there a "fast" way to rename a named cell in a spreadsheet so the cell will have a new name and all the cells that reference it will be updated? If I just create a new name for the cell I have to select all the cells in the spreadsheet and do a find/replace to get all the formulas working again.