Numbers - how do I retain data in a cell

Hi everyone.

Any help appreciated. I would like to record data into a spreadsheet daily and refer back to it at a later date. I am using two sheets , Input and Data, see photos. The input screen date changes daily and I enter the data. This is then logged in the data sheet at the matching date. Unfortunately when the input date changes and I enter new data. The previous data stored in the data sheet is lost or replaced with the new value even though its a different date. How do I keep the data from previous dates (inputs) in the data sheet?

I hope this makes sense and thanks for taking the time to reading my post.



iMac 27″, macOS 11.7

Posted on Oct 25, 2023 1:19 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Numbers - how do I retain data in a cell

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.