I need to create the following setup.
- Two Shared excel workbooks, each with 6 tabs. different users should be able to use the workbook simultaneously.
- A macro on each of these tabs that sends the data on the spreadsheets to an access database. Whenever the data is sent from Excel to Access, the data is purged from excel.
-The access database appends any new data, notes the timestamp, as well as which one of the two spreadsheets the data comes from
-The third excel spreadsheet is linked to the database and pulls up the cumulative dataset. I should be able to refresh the page to pull new data. One tab from the third excel spreadsheet also has a pie chart that dynamically updates as the data is refreshed.