I have a MASTER data sheet and a SECONDARY data sheet in another document.
I am linking values from the master sheet into the secondary sheet. After creating the link, I want to sort the MASTER sheet based on another criteria.
However, when I do this, the linked values in the SECONDARY sheet change.
How can I sort the MASTER sheet without changing the values in the SECONDARY sheet?Sorting without changing linked values in Excel?paste special value for the secondary sheet instead of the linkSorting without changing linked values in Excel?http://rpm.softwarera.com
http://www.softwarera.com
