Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down Ref another sheet within the Workbook
I have been given the task of creating a letter within Excel, just figured it
would be easier than ref data from Word to Excel. What I need to do is have one cell we will call it Cell A determine what can be selected in Cell B. Both Cells will be drop downs. An example of this would be lets say I select Arizona in cell A, I would like cell B give me the ability to select paragraphs for Arizona only. The Cell A data and Cell B data will be stored in a seperate sheet within the workbook. I will potentialy have a seperate sheet for each state and the corresponding language. Does this make sense or can it even be done? Any help than can be offered would be greatly appreciated or if you can direct to a guide that might give me some of the info to complete this task. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Drop down Ref another sheet within the Workbook
Hi Eric,
I was working on something very similar. The best thing I can do for you is to point you in the direction of the Contextures website, which should have all of the information you need. http://www.contextures.com/xlDataVal02.html Kind Regards. Anthony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to link drop-down list of a workbook in to another workbook? | Excel Discussion (Misc queries) | |||
Named Range From One Workbook Used in Validation Drop Down in 2nd Workbook | Excel Discussion (Misc queries) | |||
Help needed: Getting all sheet setup data from one workbook toanother workbook | Excel Programming | |||
Select sheet tabs in workbook & save to separate workbook files | Excel Worksheet Functions | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) |