I have a workbook with one table with the data source coming from a query (DataPull1). I want to know how to switch and run a second query and replace the data with data from the newly activated one (DataPull2).
I do not want a second table unless it is placed in the exact same location.
I did it accidently once but, cant seem to find out how to do it intentionally.
(Note: If possible, I plan to record the steps and do the steps and record a macro to switch between 1 and 2 so that I can run either at the click of a button)