Dear all
I have a button in my workbook and I have 3 queries in it, when i hit the button which i have created, i need all the queries in workbook to be refreshed one by one, I am not familiar with VB. Could you please assist me with the code for a macro.
I also need to jump to a different workbook (Query) by right click on a cell and the value of that cell is a input variable to the target query. I am sure i can use RRI if its from query to query. but i need VB code which picks the value from the cell and sends it to target query which is also in a workbook.
Thank you very much.
Vardhan