Basically I have a lot of historical data, consisting of IPs, Contacts, and various other fields. Originally we kept all this data in an Excel spreadsheet. I recently created an Access Database with this historical data. Now I am wondering if there is any way to use VBA or something else to autofill fields in the Excel spreadsheet using data from the Access database. Example, I put in an IP Address and a search is done for matches in the database and the Contacts field is filled out automatically. If anyone has an idea on this please let me know.
EDIT: What I'm trying to do is have the field auto-populate with the information from the Access database when I fill in the cell in the Source IP column in the spreadsheet. I import these IPs in a csv file and paste them into the spreadsheet. We have to add anywhere from 10-100 IPs and I'm not wanting to run a Query on each individual one. I'm wanting to automate the process we have right now, so basically I cut and paste, a macro or something runs and the remaining fields auto-populate with the data that's in Access. Edit/Delete Message