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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is there a way to reference 2 separate worksheets with validation
Erik --
I've been trying to solve the same problem. The only way I could do it was a fairly crude "brute force" work-around. On the page where I had the validation function, I set aside (and hid if necessary) a section that automatically copies ("=Sheet2!A1, etc.) the validation list from the other worksheet. I set it up to copy a lot more cells than I have filled in on the source worksheet, so that I can add to the validation list later and not have to worry if I remember to update the list on the 'target' sheet. Then I use the copy on the 'target' sheet as the data validation list. It would be nice to see a more elegant solution -- hopefully both of us will hear from someone smarter than me. HTH "Erik" wrote: 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. |
Reply |
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 |