Hi
Hoping someone can help me with this problem.
I get a data feed every day and wanted to create a summary of this to track trends over time.
Referring to attached spreadsheet.
- I have created a spredsheet which I plan to copy and data into every day. The worksheet which I have named “data” is where I plan to copy the data values.
- On the summary worksheet I want to divide 2 cells based on the day and month and display the results in the summary sheet based on the 3 products.
I have attached a spreadsheet which has an example of the data and the calculation on the summary sheet. Basically the goal is once I copy the data in every day it automatically calculates the corresponding result in the summary sheet.
Hope someone can help.
Thanks
H
Bookmarks