VBA to filter top ten values then paste into the related tables

Hi All,

Extremely new to the forum and VBA. I was wondering if anyone can help me out?

I am looking for a VBA Code that can run through a data dump and filter for the Top ten highest variations and paste the correct data into the related tables.

I have included the worksheet for an example. I also understand this could be done in Pivot Table however I am trying to increase my understanding of VBA.

If anyone could help me with my issue that would be most appreciated

Thanks in Advance !

One way

Please Login or Register  to view this content.

Thanks for the response, However is there another way to write the code for this(I am not familar with ADO) . I only ask because I plan to further edit the code to apply to other tables I have.

Thanks for the response nonetheless

that's the one Jindon !

thanks a bunch my dude