Hello - I need to automate a weekly sales report. Attached is the weekly raw data of all the sales between Jan 1 and Mar 13, this updates weekly. I have also updated a copy of the report we use today.
The current version seems to crash all the time and is a larger file than I would have expected. I would also like to link the data to google map so we can show where the sales are coming from.
The most important tabs in the attached spreadsheet are:
- Doctor Level (sales by doctor)
- New Doctors (a list of doctors that have used the product for the first time that month. )
The data will update every week and I need a way for the report to easily update when new data is added.