I have two spreadsheets. One that has the information I need and one that I need to allow others to update monthly.
When they update the information - they import data from a text file and then sort it by highest sales and delete out any accounts that are employees, returns or store transfers. Leaving just the top legit customer data.
On my sheet I need exact references to what winds up being on their final list. For example 'Sales'!$A$1 needs to be what is in A1 on the Sales tab.
My issue is that as they delete rows, the references in my sheet change to "#REF!".
Is there any way to make excel stop doing that and just leave the absolute reference as it is?
When they update the information - they import data from a text file and then sort it by highest sales and delete out any accounts that are employees, returns or store transfers. Leaving just the top legit customer data.
On my sheet I need exact references to what winds up being on their final list. For example 'Sales'!$A$1 needs to be what is in A1 on the Sales tab.
My issue is that as they delete rows, the references in my sheet change to "#REF!".
Is there any way to make excel stop doing that and just leave the absolute reference as it is?
