I have a workbook with multiple sheets, I am trying to change the value of a dropdown that is located in the "Summary" sheet with the value of a dropdown in the "Business Plan" sheet.
I am getting a "Unable to set the Value property of the DropDown class" error.
any idea how to accomplish this?
I am getting a "Unable to set the Value property of the DropDown class" error.
any idea how to accomplish this?