hello,

is this possible, and if so any ideas/tips and code?

Well basically I'm looking to split the worksheets in a workbook..

The Scenario :

I want to pull reports from a server, which will be in xls files. I want to put the files in certail folders for example:

folder name > filename.xls

C:\1\1.xls
C:\2\2.xls

etc. etc. (obviously the file paths and name will be longer and vary a bit)

In those reports, i want to split the sheets and save them in seperate folders, another example:

for file 1.xls >

sheet 001 = C:\1\mesh1o\rrate.xls
sheet 002 = C:\1\exceltip\rrate.xls
sheet 003 - 006 = C:\1\google\rrate.xls

and so on..

I was thinking in the spreadsheet i will have a colum saying the file needing spliting, and then the persons name (mesh1o, exceltip and google) and the sheets they require...?

hope that makes sence and its clear what im looking for... i;d have to do this 4 times, with different reports so i want this macro/vba in a differnt sheet to the actual report?

Thanksfor your time,

hope someone can help