Hello Everyone,
I'm pretty new to VBA so please go easy on me.
So here's the basic issue I'm having:
I have a workbook with large amounts of data. I need to extract certain data from this workbook. In this workbook, the data is categorized by drop down menus. So, I'd select an item in drop down menu, and then I can run a simple copy and paste macro. BUT, I need to be able to change the drop down selection in VBA.
Is there a way to do this? I have already identified what each shape is called, I just don't know the code to activate the value I want.
I've been searching and searching but I've only come up with codes that give me errors.
Your help would be greatly appreciated,
thank you!
Eric C.