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.
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.