I need an Excel VBA developer
Budget: $20 – $30 SGD
Hi,
Attachment enclosed with just a few lines of the code.
I have three Sheets (1,2, and 3).
Sheet 1/2 -
I am attempting to have two ActiveX ComboBoxes that have the exact same drop down list options. If option A is selected in
first drop down, I would like it to become unavailable for selection in the second drop down (for comparison). Once a drop down
is selected on Sheet1, I would like to populate range of data from Sheet2 associated with the institution to Sheet1 in columns B3:B15 (vertically). I attempted
a copy range but it copies the data horizontally vs. vertically.
Sheet 3 -
I would like to populate ranges from Sheet3 to Sheet1 to correlate to drop down selection.
Note: One institution has two certificate options (i.e., advanced/professional) - so also need to differentiate.
I am open to any and all suggestions anyone has to assist.
Thank you in advance.
Attachment enclosed with just a few lines of the code.
I have three Sheets (1,2, and 3).
Sheet 1/2 -
I am attempting to have two ActiveX ComboBoxes that have the exact same drop down list options. If option A is selected in
first drop down, I would like it to become unavailable for selection in the second drop down (for comparison). Once a drop down
is selected on Sheet1, I would like to populate range of data from Sheet2 associated with the institution to Sheet1 in columns B3:B15 (vertically). I attempted
a copy range but it copies the data horizontally vs. vertically.
Sheet 3 -
I would like to populate ranges from Sheet3 to Sheet1 to correlate to drop down selection.
Note: One institution has two certificate options (i.e., advanced/professional) - so also need to differentiate.
I am open to any and all suggestions anyone has to assist.
Thank you in advance.