Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
bob
 
Posts: n/a
Default link drop down menu to info in worksheet

want to create a drop down that shows information from other worksheets. ie
as i select A it will read the information on A from the worksheet2.
  #2   Report Post  
Carole O
 
Posts: n/a
Default

How about a 'list'? Position your cursor where you want it in worksheet 1.
Go to
Data, Validation, Settings, Allow and choose List. In Source, click on the
red square in the spreadsheet icon, go to worksheet 2 and select what you
want displayed in worksheet 1. Click on the red again, and OK. When your
cursor enters the cell in worksheet 1, a downarrow appears with the list you
linked to.

HTH,
Carole O
"bob" wrote:

want to create a drop down that shows information from other worksheets. ie
as i select A it will read the information on A from the worksheet2.

  #3   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

In the data validation dialog box, you can refer to a list on another
sheet, but you'll have to name the list. There are instructions he

http://www.contextures.com/xlDataVal01.html

bob wrote:
want to create a drop down that shows information from other worksheets. ie
as i select A it will read the information on A from the worksheet2.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
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
Link in worksheet Yves Excel Discussion (Misc queries) 1 January 18th 05 06:27 AM
Why am I unable to link a cell in one worksheet to a cell in anot. Dave Excel Discussion (Misc queries) 1 January 8th 05 02:51 AM
Can I link a cell to reflect a worksheet name? bkester Excel Discussion (Misc queries) 3 January 5th 05 11:47 PM
Applying a formula to a drop menu choice Andrew Hill Excel Discussion (Misc queries) 1 January 4th 05 12:05 PM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 09:45 AM


All times are GMT +1. The time now is 11:33 PM.

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

About Us

"It's about Microsoft Excel"