MS Access macro that generates an Excel file from a template (1 Viewer)

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!

SO what is unclear in the posts you searched and found about how to get data from Access to Excel?

I guess mostly that I have fourteen queries instead of one table

You may find this thread useful:- http://www.access-programmers.co.uk/forums/showthread.php?t=127596