Navigation between Excel Workbook/Worksheet

The other day sekhar was referring to similar issue of organizing his activities during his trip. Then comes the issue of managing his various Excel workbooks and worksheets.

Below is the procedure for Navigation – Excel 2007.

1. In sourcebk1, select cell you want to link to destbk1.
2. Find the "Hyperlink" button in "Insert" ribbon, select the same.
a. Case 1: Navigation between workbooks (sourcebk1, destbk1)

1. Select Existing File or Page in the opened window

2. Select the required destination file.

3. Press Ok button
b. Case 2: Navigation between worksheets in same workbook.

1. Select Place in this referance with the cell to be referred.

2. Select required destination worksheet

3. Click Ok button.

Its as simple as playing with a page and work is done ......