johnandbeth
Board Regular
- Joined
- Apr 8, 2002
- Messages
- 168
I had some great help from some of the experts here on this topic: http://www.mrexcel.com/board2/viewtopic.php?t=233293&highlight=
When you open this worksheet, now I can type in the 2 variables and it will give me the correct information. But if I want to, after running that query, run another query and put in the two variables, the "answer" section clears itself out and doesn't run the search.
How would I add some vba into my spreadsheet that will let me run the search/variables again without closing out and going back in?
Thanks,
Beth
When you open this worksheet, now I can type in the 2 variables and it will give me the correct information. But if I want to, after running that query, run another query and put in the two variables, the "answer" section clears itself out and doesn't run the search.
How would I add some vba into my spreadsheet that will let me run the search/variables again without closing out and going back in?
Thanks,
Beth