Results 1 to 1 of 1

Thread: How to freeze a data in a worksheet

  1. #1

    Post How to freeze a data in a worksheet



    Register for a FREE account, and/
    or Log in to avoid these ads!

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

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •