Forum Discussion

Copper Contributor

Jul 01, 2020

Solved

Please can any one help with a macro?

Basically I want to enter a team name in I1 (Milan eg). I then need Col H to be searched for the last 50 times "Milan" appears. I then just want COLS D E F G to be auto copied for me to paste elsewhe...

excel

Macros and VBA

Riny_van_Eekelen
Jul 03, 2020
harwood66 Just give it a try. As long as you keep the structured table called "Table1". No need to pre-sort. The query does that for you. Come back if you encounter any problems.

harwood66

Copper Contributor

Jul 03, 2020

Riny_van_Eekelen Wow that is absolutely incredible to me. Am I able to update the "Data" table as per usual? I normally update from the bottom and then flip latest to the top. Cannot thank you enough you are so kind. Regards Dave

Riny_van_Eekelen

Platinum Contributor

Jul 03, 2020

harwood66 Just give it a try. As long as you keep the structured table called "Table1". No need to pre-sort. The query does that for you. Come back if you encounter any problems.

harwood66
Copper Contributor
Jul 03, 2020
Riny_van_Eekelen Absolutely brilliant, you have saved me several hours a week. I am going to have a look at this PQ online, and try and pick it up. Kind regards Dave