Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to reference 2 separate worksheets with validation
Ive been playing around the list command in validation and I was wondering if
there was a way to use ranges from 2 different worksheets to be the source to select from. I've tried using the name box command to name the cells and create a union, and that wont work, and something like the 3-D command wont work because I've already programmed a few macro's that are referencing those cells. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation from list on separate Workbook | Excel Discussion (Misc queries) | |||
Save 2 separate data imports in separate worksheets on the same ex | Excel Worksheet Functions | |||
Validation Tables For Drop Down list on a Separate Worksheet. | Excel Worksheet Functions | |||
How do I create a validation list on a separate worksheet? | Excel Worksheet Functions | |||
Validation - List - Separate Worksheet | Excel Worksheet Functions |