Populating data from one sheet to another – new formulas user
Hi
I have a Summary sheet, and I have a Daily counts sheet.
When entering the data into the summary sheet i want it to populate to the daily counts sheet that equals the same day.
Ie If the date (Summary Sheet D3) is the same as the date (Daily Counts D19:D200) the the data entered into the Qty column will populate into the respective columns in the daily counts sheet.
Hopefully this makes sense. My summary gets overwritten each day, but I want the daily to keep track.
Thanks in advance. 🙂
Hi I have a Summary sheet, and I have a Daily counts sheet. When entering the data into the summary sheet i want it to populate to the daily counts sheet that equals the same day. Ie If the date (Summary Sheet D3) is the same as the date (Daily Counts D19:D200) the the data entered into the Qty column will populate into the respective columns in the daily counts sheet. Hopefully this makes sense. My summary gets overwritten each day, but I want the daily to keep track. Thanks in advance. 🙂 Read More