98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Data Validation, Named Ranges and Indirect references
Data Validation, Named Ranges and Indirect references
Resolved · Low Priority · Version 2003
Wed 23 Sep 2009, 16:17Delegate Paul said...
Paul has attended:
Project Intro Intermediate course
Excel Advanced course
Data Validation, Named Ranges and Indirect references
I want to make a drop-down list (named range) that refers to two other non-adjacent named ranges using an indirect reference as data validation. I want the drop down list to be consecutive, even though there may be blanks in my reference addresses, I could do it with a nested if function but with XL 2003 limited the number of nests to 6 in my case this won't work. Any ideas (besides an upgrade to 2007)? Thanks, Paul
Fri 25 Sep 2009, 16:47Trainer Andrew said...
RE: Data Validation, Named Ranges and Indirect references
Hi Paul
Thank you for your question - if you could send an example file through to info@stl-training.co.uk and mark it for my attention. I'll take a look and see if I can suggest a solution.
Kind regards,
Andrew
Tue 29 Sep 2009, 16:26Trainer Andrew said...
RE: Data Validation, Named Ranges and Indirect references
Hi Paul
I haven't found a way to achieve this directly using the end-user Excel interface. I believe some programming using Visual Basic for Applications would achieve the result you are looking for.
We do run VBA courses in Excel. You can find further information here:
https://www.stl-training.co.uk/excel-course-in-london-2003-vba.php
I'm sorry we weren't able to help.
Kind regards,
Andrew
Tue 6 Oct 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Entering text in Multiple WorksheetsIf you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows: |
