Excel Macro to sort columns of diff category [Closed]

Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
761
Could you explain more what you mean by "pull the values in C that match."

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!