Making new worksheets in same workbook based on unique value in parent sheet

Hi

Saw the sheet you mailed me and yes data all mixed up. But when I do a rerun everything is ok. I can't see any problem. Returning file after I did a rerun. This is what I see i.e. sheet CBU only contains cbu data and sheet HERP only contains HERP data and so forth. Is there something I'm missing??

If you like to test you could try to step through my macro and see if you cand find something that does not work in your environment.

Alf