How to stay on same sheet after running excel query

[watermasa]

Hello,
I extract needful data from website through excel web query. I combined two queries and get result in sheet 1 and another result in sheet 2. On the basis of these two sheets my analysis is on sheet 3. Therefore I always stay on sheet 3 and refresh query from sheet 3 on certain interval and update data. My problem is here. When I refresh query, excel go on showing result of sheet 2 and sheet 1 and stay on sheet 1. I need to come back on sheet 3 for my analysis. How do I remain on sheet 3 without dancing through sheets?

[alansidman]

I believe that instead of using the Native Refresh, you will need a VBA solution to refresh the data and then direct it to go to sheet 3.

Please Login or Register  to view this content.

[watermasa]

Hi Alan, No its not working. Facing same problem. Dancing through sheets and finally stay on sheet 1. Only one thing happening here, that instead of clicking "Refresh All" I am running this macro. that's it.