(See attachment 1)
I am trying to write a Macro to automatically create and save a new unique workbook for each person on my spreadsheet.
For example, in MacroQuestion.xls, I would want to:
1. Select cells in A2 to C9 based on the fact Column A has the same name (Adam) from A2 to A9. I need the flexibility for the formula to automatically know to take all the new lines in case I add additional lines of expenses. IE: It will not always be rows 2 to 9 that list Adam's expenses. It might be rows 3 to 50.
2. Copy A2 to C9 into a new workbook.
3. Automatically save the new workbook to the desktop as Adam.XLS.
4. Automatically make a separate file for the other people as well. So, running the Macro once would give me a "Adam.xls, Mark.xls, Jenny.xls, and Erin.xls" file.
Thank you for your help!