I have a workbook with 6 different worksheets. In worksheet 1,2,4,5,&6 I have brought back cells to reference worksheet 3. When sending this workbook off to my Customers I must delete all but worksheet 1 thus deleting the information that is being generated by worksheet 3. I don't want to enter this information on worksheet 1 as this will make the rest of my process harder. Is there a way to hold that information that is being generated from worksheet 3 in the other worksheets after it is deleted?
Bookmarks