View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default moving from one sheet to another from a cell of a sheet

Right Click--Hyperlink--Select 'Place in this document'-- Select the
target sheet name--Type the target cell reference --Click OK

--
If this post helps click Yes
---------------
Jacob Skaria


"mah1608" wrote:

how to create the reference in one sheet so as to move clicking on the cell
of the sheet it could move to another sheet of the excel file