This is my first post, so please be patient. I would like to know the best way to compile some data. I send a single worksheet to approximately 120 offices in a company to complete and send back. I would like these answers to be compiled on a master sheet. There would probably only be 10-12 either text or numerical answers required for each "survey," so it is not a very large amount of data. I would like to know where to begin. Presently I am opening each email as it comes back and manually entering in a master spreadsheet. I know the basics of macros, but need to know how to save and compile the spreadsheets coming back in. Thanks for your help
Bookmarks