Im trying to create dependent drop down lists with data validation
On sheet 2 i have my named ranges
On sheet 1 i have 2 cells, A1 and B1, so that B1 should be a list dependent on A1
My named ranges are all set up correct and the lists work fine.
However on sheet 1 i am using the simple =indirect(A1) into cell B1 but its not working...
Keeps telling me, "The source currently evaluates to an error"
Please help
Cannot attach file as its sensitive data
Attahced your workbook.
This coudl be a problem with your ranges(ie.missing $ sign)
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks