ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Associated Worksheets (https://www.excelbanter.com/excel-programming/402963-associated-worksheets.html)

SOSN

Associated Worksheets
 
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

Gary''s Student

Associated Worksheets
 
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



All times are GMT +1. The time now is 11:56 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com