I have two tabs in my workbook. One named SPECS and the other is named COST. most of the data on the "SPEC" tab is filled automatically from my "COST" sheet. Is there a way when i move either the SPEC or COST tabs to a seperate workbook(for printing or to save individual files) that this data can be saved as text values while keeping the formatting?
I am using both SPEC and COST tabs as templates and would like to export them regularly without keeping the linked cells but maintain the respective cell values. Is this possible?
Thanks Again!