Hyperlinks or something pcor 30.09.2006 18:10:01 I have 2 sheets (sheet one and Sheet two) On sheet ONE in col A I have a number of entries I want to be able to click on any one entry in sheet ONE and be taken to a brief explanation on Sheet TWO. Once on sheet TWO I would like to return to the starting point on Sheet ONE Ex: I cliick on A12 in Sheet ONE, that would take me to Sheet TWO a50 Once I have read the explantion on sheet TWO I would click on A50 in sheets TWO and return to sheet ONE a12 One complication is that the entries on sheet ONE will not ALWAY be in the same location due to a sorting process. I would appreciate any help you can give me Thanks

Re: Hyperlinks or something "Jim Cone" <jim.coneXXX[ at ]rcn.comXXX> 30.09.2006 19:21:41 The Hyperlink item on the Insert menu does what you want. Select the cell for the hyperlink to appear in and click the menu item. A box opens with big buttons of the left side. Click the one that says "Places in this document". In the big white box, select the destination sheet. In the small box above it select the particular cell. Click OK. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "pcor" <pcor[ at ]discussions.microsoft.com> wrote in message I have 2 sheets (sheet one and Sheet two) On sheet ONE in col A I have a number of entries I want to be able to click on any one entry in sheet ONE and be taken to a brief explanation on Sheet TWO. Once on sheet TWO I would like to return to the starting point on Sheet ONE Ex: I cliick on A12 in Sheet ONE, that would take me to Sheet TWO a50 Once I have read the explantion on sheet TWO I would click on A50 in sheets TWO and return to sheet ONE a12 One complication is that the entries on sheet ONE will not ALWAY be in the same location due to a sorting process. I would appreciate any help you can give me Thanks

Re: Hyperlinks or something pcor 30.09.2006 19:36:02 Yes that is true...but. It would be nice if as I leave sheet ONE the program could "rememebr" where I came from. That way I would not need a hyperlink back on EVERY entry in sheet two in order to return to the proper place on sheet ONE. If somehow when I clicked on an entry in sheet one, it recorded the location I was at so that when I click sheet two to return it could read that address. Thansk "Jim Cone" wrote: [Quoted Text] > The Hyperlink item on the Insert menu does what you want. > Select the cell for the hyperlink to appear in and click the menu item. > A box opens with big buttons of the left side. > Click the one that says "Places in this document". > In the big white box, select the destination sheet. > In the small box above it select the particular cell. > Click OK. > -- > Jim Cone > San Francisco, USA > http://www.realezsites.com/bus/primitivesoftware > > > "pcor" <pcor[ at ]discussions.microsoft.com> > wrote in message > I have 2 sheets (sheet one and Sheet two) > On sheet ONE in col A I have a number of entries > I want to be able to click on any one entry in sheet ONE and be taken to a > brief explanation on Sheet TWO. > Once on sheet TWO I would like to return to the starting point on Sheet ONE > Ex: > I cliick on A12 in Sheet ONE, that would take me to Sheet TWO a50 > Once I have read the explantion on sheet TWO I would click on A50 in sheets > TWO and return to sheet ONE a12 > One complication is that the entries on sheet ONE will not ALWAY be in the > same location due to a sorting process. > I would appreciate any help you can give me > Thanks >

Re: Hyperlinks or something "Jim Cone" <jim.coneXXX[ at ]rcn.comXXX> 30.09.2006 20:07:12 Try adding the Web toolbar and clicking the back (left) arrow. -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "pcor" wrote in message Yes that is true...but. It would be nice if as I leave sheet ONE the program could "rememebr" where I came from. That way I would not need a hyperlink back on EVERY entry in sheet two in order to return to the proper place on sheet ONE. If somehow when I clicked on an entry in sheet one, it recorded the location I was at so that when I click sheet two to return it could read that address. Thansk "Jim Cone" wrote: [Quoted Text] > The Hyperlink item on the Insert menu does what you want. > Select the cell for the hyperlink to appear in and click the menu item. > A box opens with big buttons of the left side. > Click the one that says "Places in this document". > In the big white box, select the destination sheet. > In the small box above it select the particular cell. > Click OK. > -- > Jim Cone > San Francisco, USA > http://www.realezsites.com/bus/primitivesoftware > > > "pcor" > wrote in message > I have 2 sheets (sheet one and Sheet two) > On sheet ONE in col A I have a number of entries > I want to be able to click on any one entry in sheet ONE and be taken to a > brief explanation on Sheet TWO. > Once on sheet TWO I would like to return to the starting point on Sheet ONE > Ex: > I cliick on A12 in Sheet ONE, that would take me to Sheet TWO a50 > Once I have read the explantion on sheet TWO I would click on A50 in sheets > TWO and return to sheet ONE a12 > One complication is that the entries on sheet ONE will not ALWAY be in the > same location due to a sorting process. > I would appreciate any help you can give me > Thanks >