How to: Extract specific data from an Access Database

You have several options available to you.
1. Create a query with the criteria you wish and then use VBA (employing DoCmd.TransferSpreadsheet) to export or manually export the query to Excel. This is a fairly straightforward and easy solution.
2. Create a query in Access and link to it via Excel. Data, Get External Data, Access. For this you will have to have the same criteria for the query to work and export properly
3. Look at this link to set the criteria in Excel and then query Access from Excel. http://datapigtechnologies.com/blog/...ry-from-excel/

Post back with specific questions once you have decided which direction you wish to go.

This is waaaay over my head. I had figured that I could just run the coding in an excel macro and not have to touch anything in Access.

I really don't want to touch Access because the Analysts don't want me to. If I make one wrong move, I will perhaps get in big trouble.

Suggest you have the Access Gurus at your location do this for you. It will take no more than 30 minutes for them to implement any one of the concepts I have outlined. Or try to do this one step yourself.

Open Excel, click on Data, Get External data. Find your Access db. Click to open it. Select the table you want from the listing provided. Import it. Do your filtering in Excel using the Filtering built into Excel.