Hello, all - I've been given a folder with 1000+ identical Excel forms and I am looking for the easiest way to consolidate the data to eventually enter into an Access database. Also to note there are multiple ActiveX comboboxes and checkboxes in each form, and I'm having trouble finding a way to automate the data consolidation.
If someone could give me a hand with this, I would very much appreciate it!
If someone could give me a hand with this, I would very much appreciate it!
