Return values from column matching criteria VBA

Hello guys,

I got a workbook which downloads data from web every hour and i need to distribute data from one column with matching criteria across different sheets. For example I got:

Sheet DATA from web and all category names appear on A sheet, B names on B sheet and C names on C sheet.

Array formula is out of a question as it takes to long to calculate and return non duplicate data because it can reach over 500 lines to work through. What would be your suggestions chaps?

http://www.excelforum.com/attachment...1&d=1481473256

Originally Posted by Richard Buttrey

The first question in cases like this is do you really NEED to copy subsets of data to individual sheets.

What's the ultimate aim here. Is it to be able to see subsets of data whenever you choose or have them permanently available (and taking up space).

Have you considered using an Autofilter or better still a Pivot Table?

Pivot table is not a solution because after the name im planning to have a vlookup formula which would use the name to return value. Names will always change, one will disappear or new will be added same with order its not constant. Im planning to send every sheet to different email like an hourly report. If that makes sense?