So let's say I made a form in Excel, complete with drop down menus, for my customers to fill in. Just like normal forms, they're in the columnar format (i.e. questions in Column A, answers in column B). I have thousands of such files, 1 for each customer, and they all have the same format, just of course different answers for every customer.
My question is, is there any way to automatically aggregate all the results from the forms into one single Excel (or Access?) database? What I'm thinking of is something like in an online survey website where you can create forms for people to fill in, and at the end of the day you can see the list of answers in a single database.
Sorry if my explanation confuses you. I'm not quite good at Excel (or Access, or VBA), but I'm excellent at following instructions, so if anyone knows any way no matter how complicated, fire away. I'm willing to bet it's better than manually entering data from each form into a single worksheet.
Thanks!
Bookmarks