I referenced a group of data from one sheet to another in the same workbook. I plan on deleting some of the information I referenced as it becomes out of date, but it will screw up my formatting in the new sheet if it updates with the referenced cells. Is there a way I can make the information in the new sheets keep the values it has now and make it unreference the sheet I plan to edit?
~~~~~~~~~~~~~~edit~~~~~~~~~~~~~~~
If not, I will just hide the information instead of deleting it, but I'd rather do it this way.
