PFA Excel,
I have data in the Data Set tab and want to create a dependant dropdown list in C3 meaning only selections relative to the value in C2 can be selected;
E.g. C2 = Burco Maxol C3 will only display Microturbo 40 SRF & 40 MDF AND Microturbo 50 SRF & 50 MDF so on and so forth.
I have attached an excel with some data and removed everything sensitive. Thank you.
Attached Files Attached Files
Hi deanhall99,
Try uploading your attachment again as it isn't showing. See yellow banner above for guidance.
Regards,
Snook
Is this working? Thank you for the heads up!
Dean
Create named ranges using headings in I1 onwards
DV for C3
=INDIRECT(substitute(C2," ","_"))
as Excel will replace blanks in headings with underscore
Done for "Baxi Heating"
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thank you so much John!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks