Need to find product codes and sum them as I add new reports.

Hi there,

So I am entering a set of data into a new sheet daily on a workbook. Each day, information regarding different codes (each process has a code) is entered.

I have a main sheet, where I would like to find a way to find all instances of that code in my workbook (for example: 004), then sum them on the main sheet.

This will help me identify how much of that code has been entered each month.

Thanks for the help.

EDIT: Example file - TestSheet.xlsx

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Here is a simplified version. Obviously my actual sheet is more complex but the ideas are the same.TestSheet.xlsx

So just to reiterate, I will be adding a new day (report) everyday and would like the summary to automatically lookup the data on the new sheet and add it to the summary, if possible.

This is easy enough with the totals because they are located in the same cells for each sheet.