Hello everyone, first post for me and glad to join the forum.
I am looking to take data on the current sheet and split it into different files AND sheets. I have seen advice here on splitting sheets to different workbooks and also splitting data into sheets:
* http://www.excelforum.com/tips-and-t...-criteria.html
* http://www.excelforum.com/excel-gene...worksheet.html
But actually I am trying to do this:
* Look at column A to choose the file
* Look at column B to choose the sheet
* Take everything under STUFF and put it into that file and that sheet
When I start the macro, all the destination files and sheets will be empty, then it should create the workbooks and worksheets with the right data.
Screen Shot 2014-03-06 at 10.57.15 AM.png
Is anyone able to help or provide advice on how to take one of the above existing macros and serve this new purpose?
Thank you,
Wiley
Bookmarks