separate data with column item

[fakhteh]

hi every one
i have too long data record file and i have to separate them in to different excel sheets
fore example data have to separate with location item (highlight yellow ( utm x utm y)) in to
sheet 2 and 3 and .....
please help with vba code . i know that i can filter or sort but it takes time to separate
thank you

[JBeaucaire]

This is a macro published on my blog here. I've simply tweaked the 3 variables:

vCol = 7
Set ws = Sheets("Sheet1")
vTitles = "A1:L1"


Here's the full edited code:

Please Login or Register  to view this content.

I've installed into your workbook and added a button.

[fakhteh]

Thank you so much
i am surprised of your solution
well done