Every day I get (via email) a workbook with a list of incidents (each row being an incident) and consistent column headings. Is there any way to create a master workbook spreadsheet that I can, for lack of better words, click an "import" button and upload each workbook into my master spreadsheet and only picking and choosing certain columns to import and add to the master spreadsheet each import? I have some programming experience, but am not very familiar with excel.
If this is possible, could someone explain the process to me? I can familiarize myself with the exact step-by-step button clicks and formatting if that can't be provided, but need to know if this is possible and what types of Excel functions would be utilized to accomplish this. Macros? VLOOKUP?
I have Excel 2010. All daily email reports come in excel format.
Bookmarks