View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Wickliffe Wickliffe is offline
external usenet poster
 
Posts: 5
Default How do I Go To a cell based on input in another cell?

An employee inputs data for 52 different weeks of the year. Each week's data
is input in various different places within the same spreadsheet or workbook.
I need a way for the employee to type a week number in cell A1 and have the
cursor leap or automatically hyperlink to the area of the spreadsheet where
data entry is needed for that week number specified in cell A1?

EXAMPLE: If "3" is input in cell A1, then the employee needs the cursor to
automatically go to the area of the spreadsheet where week 3 data needs to be
input.

How is this done automatically if there is input in cell A1?