Forum Discussion

PhilipS_2023's avatar
PhilipS_2023
Copper Contributor
Mar 18, 2023

MS Excel 2016 linked references

Hi Everyone !

 

We use MS Excel 2016..

Say we have 1 spreadsheet with 2 tabs: "A" & "B".

Values in tab "B" are pulled from "A" via typical linked references..

 

If values in tab A change, it will cause the linked cells in B to update.

A. How can we have linked cells in B remain the same even if their references in A change.

B. How can we have new cells in B be created each time the values of the linked cells in A update ?

 

Thank you so much !

Resources