Excel Macro to sort columns of diff category

Closed
sporty9x - Jun 16, 2010 at 11:46 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 16, 2010 at 12:21 PM
I have a spreadsheet that i'm supposed to "automate" because the source keeps changing I'm not sure how to so.. I'm here.. I need to figure out a way to sort this by products in column 1 then search for "flowers" in column b and each of its regions and pull the values in C that match. I've been told to write a macro but im not sure how to do that rather than just pull the fixed references.

the cells look like this-

Product Flowers 100
Product East coast (1) 20
Product East coast (2) 30
Product Central (1) 10
Product Midwest 10
Product West 20
Product Metals 110
Product East coast (1) 210
Product East coast (2) 310
Product Central (1) 110
Product Midwest 110
Product West 210
Plant Metal 55
Plant East coast 80
Plant Central 100
Plant West 22
Plant Flowers 55
Plant East coast 80
Plant Central 100
Plant West 22

Outputs-
Flowers Product East coast (1) 20
Metal product east coast 1 110

Flower Plant East coast 1 80

etc

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Jun 16, 2010 at 12:21 PM
Could you explain more what you mean by "pull the values in C that match."
0