Forum Discussion
Please can any one help with a macro?
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.
Hi Riny_van_Eekelen your help with this is much appreciated. I have attached a version of the file as requested. Basically I want to type a team in Col I4 and then get it to copy and paste the last 50 appearances that the team appears in COLS D and E . The four cols I want to copy are DEFG so the cell count is 200. When copied I would simply paste the 200 cells into the next process. Thanks again Dave
harwood66 Have a look at the attached workbook. Change the team name in the yellow cell (a Named Range called "SelectedTeam") on the "Data tab".
On the Data ribbon, press "Refresh All".
and go to the Top50 tab where you can pick-up the top 50 table for the selected team.
Now, the trick is that as long as your Data is stored in a structured table (and in this case called "Table1"). the refresh should work over-and-over-again. By selecting "Queries & Connections" you will be able to access the fairly simple queries that make it all possible. Try and see is this is a workable solution for you.
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
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.
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