Automating Excel with Access

[SHAWTY721]

I am trying to automate a process in order to make a monthly routine less time consuming. I have an Excel spreadsheet and an Access database. The spreadsheet contains formulas that calculate values for different fields based on values that are in other fields. The calculation all starts with the field that I am trying to automate to pull the information right from the Access database. Currently the users have to enter the information manually which is the majority of the process. I have thought about using the 'Import External Data' feature that is in Microsoft Excel, but I was wondering is there another way to accomplish this goal. I also need to be able to filter the information based on which company, department, location number, and account the information belongs to.