Macro VBA Code - Extract using unique identifiers

[JMcelhone]

Hi,

I am fairly new and inexperienced in writing code but I am looking for some assistance in writing a macro that extracts specific columns from a workbook based on two unique identifiers (in this case by Brand, by Vendor Name) into new workbooks. I am including an example of what I am attempting to extract



Step 1 - Sort raw data (Workbook 1) and identify any line items that are from the same Brand and same Vendor - see attached example

Attachment 391844

Step 2 - Extract this information, but I only need to extract specific columns from all rows that are same Brand, same Vendor. Vendor Name, PO, Cost.

Step 3 - Extracted information should be placed in formatted debit memo. Including example below. Red text indicates where extracted information should be placed.

Could someone please provide me with a starting point?

Thank you!!

Jenna

[mikeTRON]

I would build a pivot table then count how many instances that pops up then you can use a simple index+match.

I am all about using pivots to find unique values instead of using clever (and complicated) formulas.

[JMcelhone]

I like that idea and that would be perfect if I was executing and sending the debit memos, however, I am creating for our A/P department and they are not as well versed with Excel. I'd like to just write a macro and assign it to a command button so all functions are automatically generated for them as this is something they do each month.

[mikeTRON]

You can use the pivot in the background and then simple formulas on the front end and they won't know HOW or WHY you did anything.