Macro for moving multiple rows/columns with different criteria to different sheets

Hi,

I have been visiting this site for quite some time and really enjoy it. I appreciate everyone's help and have learned a lot...but this is my first post so sorry if it is confusing, or if it has already been mentioned somewhere. I have searched and not found anything about my problem, or maybe I am just phrasing it incorrectly...anyways here goes

I have the below information in 1 worksheet...and obviously there would be more rows columns data etc... I need to move each person to a new sheet, but keeping their characteristics(products,sales,weight etc...) with them too. I found a macro that moves each person and the data into a different sheet, however the headers in each next sheet is always the same as for Scott for example...but I want Kimmy in the next sheet with those headers and their data that are specific to her(products,type,day,sales) and the same for Rick and anyone else who comes after. Right now I am not sure if there is a space between the peoples names when I run this report in our system, I don't know if that makes a difference.

Is it at all possible to achieve what I am asking for?

city days products
Scott London 2 19
Scott Hamilton 8 32
Scott Sydney 1 7



products type days sales
Kimmy 45 single 18 15000
Kimmy 10 multiple 12 25000




Brand Weight City
Rick Oroblam 150kg Athens
Rick Lomlup 0.15kg Vienna
Rick Tohs Gib 100kg LA

Submit an example workbook with before and after expectations

Thanks for the reply...I am going to attach a before sheet and an after one....just one quick note, I am having a hard time remembering what exactly the file looks like as I do not have access to it from home..So in the before file there is one example of how I think it looks in sheet 1 and another in sheet 2(in sheet two the only difference is there is an extra row between the data)...If it is the same for either or could you please just let me know?

Edit:Also forgot to mention...if it is possible to have the tab have the same name as the person....Scott ....Kimmy .... Rick...etc...etc.

Based upon your before and after workbooks

Please Login or Register  to view this content.