I have a multiple page file that has numerous cells that are linked to a page.They are linked by cell like:
cell A1 of summary page = cell B5 of dept page
cell A2 of summary page = cell B6 of dept page
and so on.
I will be getting new versions of the file when management makes little changes to them. But the formats will be identical, meaning the cells I will need to link will be teh same that I already linked. So my quesiton: Is there a way to automatically fill in those linked cells? Like tell it to do the same links on the new file? But I can't do every cell because of all the calculations/formulas. Just the cells I linked.
Thank you.
cell A1 of summary page = cell B5 of dept page
cell A2 of summary page = cell B6 of dept page
and so on.
I will be getting new versions of the file when management makes little changes to them. But the formats will be identical, meaning the cells I will need to link will be teh same that I already linked. So my quesiton: Is there a way to automatically fill in those linked cells? Like tell it to do the same links on the new file? But I can't do every cell because of all the calculations/formulas. Just the cells I linked.
Thank you.