Loop macro to separate spreadsheet into multiple

[DLE2885]

Hi everyone

Sorry if this question has been asked a million times, but I need a macro to separate one spreadsheet into multiple spreadsheets based on the name in column A

I then need the spreadsheet to be named whatever is in column A.

I got this working fine with a filter macro, but apparently the last time this was used, it omitted data because the spreadsheet is very large and so a looping macro would work better.

It also needs a failsafe mechanism which will check that the correct file was made with the correct entries.

Can anyone help?

Thank you!

 

[Tom Urtis]

A couple of clarification items...

So maybe in Sheet1 is a list of items and you want to insert and name a spreadsheet in that same workbook for each item.

What does this mean?
"It also needs a failsafe mechanism which will check that the correct file was made with the correct entries."

What would the logic be for knowing what a correct file is and what a correct entry is? Are you talking about illegal naming characters or something else.

Why did you mention the word "file", if you are working inside a single workbook already, and you are only inserting worksheets in that one workbook file. Are you actually trying to create workbooks or worksheets.

 

[DLE2885]

Hi Tom

Thanks for your reply.

I have a master spreadsheet eg:

<style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small } --> </style> <table frame="VOID" rules="NONE" border="0" cellspacing="0" cols="3"> <colgroup><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <tr> <td align="LEFT" height="17" width="86">Name</td> <td align="LEFT" width="86">Product ID</td> <td align="LEFT" width="86">Result</td> </tr> <tr> <td align="LEFT" height="17">Steve</td> <td align="center">57</td> <td align="LEFT">good</td> </tr> <tr> <td align="LEFT" height="17">Dave</td> <td align="center">57</td> <td align="LEFT">good</td> </tr> <tr> <td align="LEFT" height="17">Steve</td> <td align="center">60</td> <td align="LEFT">ok</td> </tr> <tr> <td align="LEFT" height="17">Steve</td> <td align="center">56</td> <td align="LEFT">ok</td> </tr> <tr> <td align="LEFT" height="17">Steve</td> <td align="center">34</td> <td align="LEFT">good</td> </tr> <tr> <td align="LEFT" height="17">Dave</td> <td align="center">56</td> <td align="LEFT">bad</td> </tr> <tr> <td align="LEFT" height="17">Dave</td> <td align="center">23</td> <td align="LEFT">bad</td> </tr> </tbody> </table>
What I want is a looping macro to create a new workbook (i.e. not a sheet within the existing workbook) which is named Dave.xls and Steve.xls

I want the headers included and the formatting to remain the same if possible.

I would also like to define the location to save them.

Is this possible?

With regard to the failsafe check, I was asked to provide this. I understood it as being some kind of check which ensured that Dave.xls only had Dave's information in it and that all of Dave's information was in Dave.xls. If this isn't possible, or makes no sense, that's ok.

Many thanks for your help!!

 

[DLE2885]

Also, as mentioned above, I have been asked not to use a filter macro because it caused problems last time.

 

[DLE2885]

bump
can anyone help me please?