vba code help needed (1 Viewer)

[lwarren1968]

I've been working on a project that involves combining Power Query with some VBA scripting, and I've hit a bit of a roadblock that i hope someone can help me with.

Here's what I've done so for:

• I have a main table in the "QRY" sheet.
• Column K [VALUE 1] in the table has a dropdown list that matches the values in column I [Product Category] with the values in column A [cat] from the VALUE ! sheet.
• The dropdown in column K should return the corresponding detail from column B [DROP DOWN} as a list

Where I'm stuck:

• • I need to add to my VBA or adjust the VBA code that will automatically:
  • Combined the contents of column I [Product Category] and column K [VALUE 1] in the QRY sheet (with no spaces)
    • Match this combined result with the [CAT_SUB] column in the ATTRIBUTES sheet
    • Return columns F through P [Label 1], [Label 2]. etc. from the ATTRIBUTES sheet to the QRY sheet, starting at column L
    • Insert a blank column after each returned column, as these columns are already named.

I just can't get thispart to work, and any guidence would be greatly appreciated.

Thanks in advance for you help.

 

[raziel3]

All this can be done with power query. VBA may not be needed.