This is my macro here: 

Please Login or Register  to view this content.

It basically splits a worksheet using recurring data via (column A) into new worksheets. For example (as simple as poss) A list of data called "01 backup", "02 backup" etc and puts the data into a new worksheet so it is split by column A, then it deletes all column A's in the new worksheet because they are the worksheet name. That was the easy part of the macro, and it does its job perfectly. What i need to add is the ability to add a new worksheet left of the one that was made, using data from a different spreadsheet in the same column as before.

Ask me questions and stuff to get a better view.

=============================

Some examples as follows:

http://www.freewebs.com/davie1982/Book1.xls
^
The original spreadsheet

=================

http://www.freewebs.com/davie1982/Book2.xml
^
The spreadsheet after the macro is run

=================

http://www.freewebs.com/davie1982/to...added%20up.xml
^
The spreadsheet with data i want the original spreadsheet to contain as workbook names from the Invoice Number column

=================
http://www.freewebs.com/davie1982/Book2%20final.xml
^
The finalised spreadsheet (which i want in after or during the macro)

If this is any extra help i hope you can help me find a solution.

Also posted this problem at http://www.mrexcel.com/board2/viewtopic.php?t=302268

It's Excel 2003