Macro to Look Up and Sort

[andrewc]

Hi,

I’m trying without success to write code to extract into the “Look Up” sheet from the “Data” sheet each Product for which the Data Type is “Current” (column B in “Data”). An added wrinkle is that I would like the results in “Look Up” to be sorted in descending order of the relative relationship (ie ((1+Growth %/100)/(1+Growth %(base)/100)-1)*100) between each product’s growth rate and that of its base (columns C and D in “Data”).

The results that I’d expect are entered in A2 :C4 in the “Look Up” sheet.

Can someone please suggest VBA code that would accomplish these results?

Thanks!

[Fotis1991]

Hi

Give a try to this. In fact we use the advanced filter option.

Please Login or Register  to view this content.

[AB33]

You have not shown "An added wrinkle" on your result, so I am sure I am missing something.

[andrewc]

Thank you both!