Jump from one query to another in one workbook

[Former Member]

Hi,

I have two similar queries in one workbook. Now I try to jump from the first one and the values from the second should change. But if I jump from the first one, it opens another excel workbook with the right result.

I read some threads here, but they didn't helped me much. Can I do here something with vb?

Thanks for you help

[Former Member]

Workbook cannot be a destination.

May be possible using macros.

Check :

[ChandranGanesan]

Hello Rene,

Jump target will always open a new workbook, rather then opening in the same workbook.

Thanks

Chandran