Worksheet sorting/managing

[me5h1]

Hello fellow excel users,

I'm looking at using a macro to sort through a workbook for me, basically towards the end of the month (as its december, be mid month) i pull of a report which will have multiple worksheets.

These sheets automatically get named, and the names for the tabs are listed in another excel spreadsheet.

Hopefully people are still with me ..

What i want it to do!

Is to sort through the workbook, referencing the workbook that has a list of codes and then i'll add an aditional column to the list which contains a name.

I want it then to check through all the tabs on the report, and match them to a name on the other list.

So someone might receive three work sheets while another receives two, all depending on the list. i want it to split the worksheets or move the worksheets to a new book, that matches the persons name in the list... if the name doesnt exist in a specific folder create a new one else add any other worksheets to it :S

Pseudo Code

If worksheet name in report.xls
is equal to "Column A" in "list.xls"
then save a copy as "persons name"

else if persons name file already exists then copy the worksheet to persons name file

end if

Hopefully that makes sence and someone can help me i have attached a small example of sheets i want to work with

[Leith Ross]

Heloo me5h1,

If I understand this correctly, the worksheet name in Lists column "A" will be used to add a sheet to the workbook named in Lists column "C". If the workbook doesn't exist then create it. What should be done if the worksheet name already exists? Are all the workbooks in the same folder?

Thanks,
Leith Ross

[me5h1]

Hi Leith Ross,

Thanks for your quick response, yes that is exactly what i mean.. but if there already is a file that exists then i want it to add the other workbooks to it (basically just merging all the worksheets to relevent people in column "c" in lists.xls)

now, which way would be easier - cause i always get the report in one spreadsheet with multiple worksheets, and i use a macro to split the worksheets into the tab names. So instead of having one workbook with 10 worksheets i split it, and get ten workbooks representing one worksheet.

Ideally i would like it split from the one workbook, and loop and split from that?

But im not to bright on this sort of thing..

thanks for yourt help Leith Ross, merry christmas to you.. and i hope you can help resolve this matter

Thank You

[me5h1]

any luck with this, or any ideas?

thanks