View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barbara Barbara is offline
external usenet poster
 
Posts: 97
Default Searching data within sheets

Hi,
I have a workbook with 2 worksheets. The 1st have anual client sales. The
2nd, all client information. both have a column with the client number.
I would like to be able to click on the client number of the anual sales and
be redirect to that specific client in the client information sheet.
How can I do that? I tried to format in the anual sales the clietn column
with hyperlink but didn't work.
Can someone give me a clue to solve this. Any help would be appreciate.
Thaks,
Barbara