How to freeze a data in a worksheet

nanrem

New member
Joined
Sep 22, 2014
Messages
6
Reaction score
0
Points
0
Hi all:

I'm working with a chemical inventory and i have a reference sheet, where contains some formulas for conversions, total of product on stock, the SUM of product dispatched, on the other sheet (named with the date), where the input will be the dispatched product on the day. I want to create a copy of this sheet daily. The thing is that i want to retain the info of each day, when i copy a worksheet and enter some values on the second worksheet, the first worksheet it's affected, because it's using the reference sheet. Is there a way to freeze the info entered each day?? Any help will be appreciated. Ill attach file.
 

Attachments

  • INVENTARIO DE QUIMICOS con hoja despacho2.xlsx
    42.3 KB · Views: 9
Back
Top