Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create formula that will pull a value based on text in diff cell? | Excel Discussion (Misc queries) | |||
HELP| populate cell with particular value based on multiple condit | Excel Worksheet Functions | |||
Possible Lookup Table | Excel Worksheet Functions | |||
Input cell information | Excel Discussion (Misc queries) | |||
Returning a Value to a Cell Based on a Range of Uncertain Size | Excel Worksheet Functions |