troubleshooting Question

VBA: Copying data into new workbooks and saving the files

Avatar of jenpwagner
jenpwagner asked on
Visual Basic ClassicMicrosoft ExcelVB Script
3 Comments1 Solution380 ViewsLast Modified:
(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!

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 3 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 3 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros