LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create formula that will pull a value based on text in diff cell? So Tru Geo Excel Discussion (Misc queries) 0 June 22nd 06 08:16 PM
HELP| populate cell with particular value based on multiple condit doon Excel Worksheet Functions 7 February 13th 06 11:26 PM
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Input cell information RB Camp Excel Discussion (Misc queries) 3 May 18th 05 05:49 PM
Returning a Value to a Cell Based on a Range of Uncertain Size amc422 Excel Worksheet Functions 7 November 14th 04 03:03 PM


All times are GMT +1. The time now is 08:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"