copy and past to different sheets based on criteria

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

Assuming the managers name is in column A of the data dump and the manager sheets are named exactly the same this should do the trick:

Please Login or Register  to view this content.

Dom

I have a macro that may be "ready to use" for parsing rows of data from one sheet to many sheets named for the same values.

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing.

=======
Dom,

If the macro parses values that are numeric, this created a referencing problem at times that I had to solve in my macro. Numeric values need to be consistently converted to text before inserting into the sheet references. Take a look and you'll see what I had to do to make it work for both text and numeric references.

Well spotted, I've come across that in the past.

Per Jerry's suggestion this line in my code should be changed from:

Please Login or Register  to view this content.

to:

Please Login or Register  to view this content.

Dom