Forum Discussion

Memphis_JW's avatar
Memphis_JW
Regular Visitor
3 years ago
Solved

Two queries, one table. How to switch between the two

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)