Brilliant Richard. You've taken me to the point where I can pretty much attempt the task I initially wanted to do when I set out on your courses. I plan to continue to learn more from you  but I'm missing one thing and I was hoping you  could point me to one of your courses with the answer. I need to pull the data from Access to an excel template. This will have filter criteria declared in the excel spreadsheet. So let say starting in cell C10 of a spreadsheet I would like to import data from a table/query in Access, filtered by values declared in other cells within the excel spreadsheet. If you have a video that covers this I'd love to jump straight to it to complete by immediate goal. Cheers

---

Reply from Alex Hedley:

I don't think these cover exactly what you need but they'd be a good starting point

You can link an Access Table in Excel and create a PivotTable which you could add your Filters too

Expert Level 19

Excel Upgrage to 2007
18. Get External Data (9:49)
From Access Database