on values in cell A and cell B.
I've looked all over, and I cannot find any solutions. I think this has to be done in VBA. I want the options in cell C to be contingent upon what is selected in cell A and cell B.
on values in cell A and cell B.
I've looked all over, and I cannot find any solutions. I think this has to be done in VBA. I want the options in cell C to be contingent upon what is selected in cell A and cell B.
Try a search for Excel Dependent DropDown List
Here's one very good guide.
Create Dependent Drop Down Lists
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Thank you, but I do not think this is the solution. Does anyone know how to have drop down lists with only one item automatically display that item? That would solve my problem.
Hi btatc620
Welcome to the Forum!!
Please attach a sample workbook the Structure of which is the same as your actual workbook.
Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Thanks jaslake! I will upload shortly.
See my comments in yellow on tab 2.
anyone have any suggestions?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks