moving data to seperate tabs based on one condition

[dontgetit]

Hi Guys,

I have a huge data base with info in several columns. Each row of data has one variable that is the same - the province. So I have thousands of rows and columns of data. I want to put all the data for the provice AB on to a tab, for province BC onto a tab and so on.

I cannot change the downloaded info so I have to work with this. The province is in column T and there is data in columns and rows all down the spreadsheet. So basically instead of sorting, then cutting and pasting into seperate tabs, I would like each tab to automatically pull in the data for each province. Hope I am making sense.

Thanks

 

[dontgetit]

Did you name the macro Lapta? Can I change the name?
This is awesome ! Now I have to figure out how to make it a personal book, I'm running 2007. Then transfer it to my friend.

Thanks so much ! This is amazing.

 

[VoG]

Yes, just change the first line, for example

Sub MyVeryOwnMacro()