Parsing Data in chunks! HELP ME!

[pablorynx]

I'm trying to write a macro which will parse out chunks of data from a dataset, based on criteria within the datachunk.
My data goes from A1:C10
the data in A1:A10 is one of five different labels
the data in B1:B10 is one of nine different labels
How can I get all the data in my chunk where the data in column A equals a particular element and the data in column B equals a particular element, and copy-paste it to another sheet? I can get the sheet sorted first by the elements in column A, then in column B. But I can't figure out how to transfer the data parsed out in such a fashion. Does anyone out there have a clue?

 

[Cbrine]

I'm trying to write a macro which will parse out chunks of data from a dataset, based on criteria within the datachunk.
My data goes from A1:C10
the data in A1:A10 is one of five different labels
the data in B1:B10 is one of nine different labels
How can I get all the data in my chunk where the data in column A equals a particular element and the data in column B equals a particular element, and copy-paste it to another sheet? I can get the sheet sorted first by the elements in column A, then in column B. But I can't figure out how to transfer the data parsed out in such a fashion. Does anyone out there have a clue?

I'm assuming you want to lookup the value in column C based on A and B.

Insert a column in front of column A and enter the following formula in A1
=B1&C1. This creates a unique index based on column B & C. This will move your data to B1:D10

On your second sheet I'm assuming you have the values of column B & C and want to value from D from your original sheet.

Use a vlookup
=Vlookup(A1&B1,$A$1,$D$10,4,false) where A1 & B1 is your unique index values and copy this formula down as needed.

Hope this helps.

 

[pablorynx]

Thanks, although I was looking for someway to do this in VBA. I need to do this quite a bit, so an automated solution via VBA code would be extremely much more helpful.

 

[Seti]

While not a VBA solution, you could use advanced data filters where you send the data to another location. Maybe try doing this once and record it and then tweak the resulting macro?