Vlookup for filtered data

[kakasha]

Hello,

I need help with a VBA code. I have a pivot table and I want to use vlookups. When I filter data I want the Vlookup formulas only to appear for the certain rows which return a value. For example if I filter by company that company has 20 products and I want the vlookups to show up for these 20, but another company has only 1 product so the vlookup needs to adjust to 1 row only.

[alansidman]

Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.