PC Review


Reply
Thread Tools Rate Thread

Associated Worksheets

 
 
SOSN
Guest
Posts: n/a
 
      18th Dec 2007
I have a an excel document that was created by someone that no longer works
at my company. It has drop down menus that I need to modify and do not know
how. Also when any selections in the drop down menu are selected the work
next to the one I'm working in changes to the cooresponding item selected
from the drop down. Please tell me where I can go to look at the perameters
that were set up to support this function.

-
Best Regards.

Deniese
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      18th Dec 2007
Drop-downs ae usually implemented thru Data Validation. Click on the cell
containing the dropdown and type:

Data > Validation

It will tell you where the list is and then you can edit it.
--
Gary''s Student - gsnu200761


"SOSN" wrote:

> I have a an excel document that was created by someone that no longer works
> at my company. It has drop down menus that I need to modify and do not know
> how. Also when any selections in the drop down menu are selected the work
> next to the one I'm working in changes to the cooresponding item selected
> from the drop down. Please tell me where I can go to look at the perameters
> that were set up to support this function.
>
> -
> Best Regards.
>
> Deniese

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
How use info in Excel shared worksheets to create new worksheets =?Utf-8?B?ZGtj?= Microsoft Excel Worksheet Functions 0 28th Jun 2007 08:36 PM
How to hide worksheets and set marco to print those hidden worksheets? koo7891 Microsoft Access Macros 0 22nd Apr 2007 06:05 AM
Copy data from multiple worksheets to worksheets in a number of other spreadsheets SteveH Microsoft Excel Discussion 5 6th Nov 2006 06:59 PM
VBA / Macro for creating new worksheets and new columns from existing worksheets webby2006 Microsoft Excel Programming 3 25th Jul 2006 03:38 PM
Worksheets are referenced in expressions, how make the worksheets visible? Excel 2000 L Mehl Microsoft Excel Misc 2 27th Jul 2004 07:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:10 PM.