Forum Discussion

chantalcattermoul's avatar
chantalcattermoul
Copper Contributor
Oct 31, 2024

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

 

Formulas and Functions

5 Replies

  • Harun24HR's avatar
    Harun24HR
    Bronze Contributor
    Oct 31, 2024
    Please share a sample file (attach to the post or share via OneDrive or GoogleDrive). SUMIFS() may help.
    • chantalcattermoul's avatar
      chantalcattermoul
      Copper Contributor
      Oct 31, 2024

      Harun24HR 

      https://fbu-my.sharepoint.com/:x:/r/personal/chantal_cattermoul_gib_co_nz/Documents/SAMPLE%20FILE%20ONLY.xlsx?d=w3f6dc8a569714b76b08a001f77eb088a&csf=1&web=1&e=rBaJ17

Resources