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