[varshatoke]

Hi,
I want to connect two cells from same workbook, like if I click on a particular cell of X sheet it should directly jump on a particular cell of y sheet of the same workbook.

[JBeaucaire]

This is accomplished with HYPERLINKS. You can click on a cell and CTRL-K to open the Hyperlink wizard to add a link to another spot in the same workbook.


There is also a HYPERLINK formula that can be used to hyperlink to other spots in your workbook, and it can be more dynamic... if the "target" on the other sheets might move, the HYPERLINK formula could still find it.

The CTRL-K hyperlinks you can do pretty easily. If you want some help with dynamic HYPERLINK() formulas, post up your workbook and point out examples of where you'd "click" and where that would take you...

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook.