zzzjoshzzz
New member
- Local time
- Yesterday, 20:51
- Joined
- Nov 5, 2015
- Messages
- 2
Hi everyone, I don't yet have experience creating an automatic Excel sheet from an Excel template for a user that uses data from the database.
Essentially, I'm looking for a way to fill out the fields in the attached Excel sheet (and have the graph automatically change) and for the Excel sheet to pop up as a new file for the user (IE the template would stay untouched). You'll see in the Excel sheet that there are a number of cells that need to be filled from Access. I have a query in Access PER CELL that needs to be filled.
So, essentially I have 14 queries and I need the results of those queries to appear in the cells of a local version of an Excel template.
Thanks so much for your advice!
Essentially, I'm looking for a way to fill out the fields in the attached Excel sheet (and have the graph automatically change) and for the Excel sheet to pop up as a new file for the user (IE the template would stay untouched). You'll see in the Excel sheet that there are a number of cells that need to be filled from Access. I have a query in Access PER CELL that needs to be filled.
So, essentially I have 14 queries and I need the results of those queries to appear in the cells of a local version of an Excel template.
Thanks so much for your advice!