I need to move data from main worksheet into multiple worksheets based on a criteria

[ksenia81]

I really need help. I have a file that combines data (multiple rows and columns) for several regions. I need to be able to copy data for each region and copy it into the new sheet for that region.
Any help is greatly appreciated .
Thank you,

K

[bopsgtir]

Something like this would work, im sure someone will be able to give you a better code but this would work.

Please Login or Register  to view this content.

[ksenia81]

Thank you very much for the response. I tried to add the string into macro but it does not work. I am a total dummy then it comes to macros so I have no idea what is causing the problem. I attached file with the sample data. Individual tabs for the regions were created manually by copying and pasting the data into appropriate tabs. I have more than 50 regions with lots of rows and I waste so much time doing this manually . Please HELP!