VBA copy/paste range based two dropdowns
Budget: $10 – $30 USD
I have 2 dropdowns and would like to copy/paste different ranges based on selected values from the dropdowns.
First dropdown values:
-UFH
-AO
-LM
Second dropdown values:
-UFH
-PEX
-MLC
Ranges:
BD UFH = Sheet10 B2:C10
BD PEX = Sheet10 D2:E10
BD MLC = Sheet10 F2:G10
AO UFH = Sheet11 B2:C10
AO PEX = Sheet11 D2:E10
AO MLC = Sheet11 F2:G10
LM UFH = Sheet12 B2:C10
LM PEX = Sheet12 D2:E10
LM MLC = Sheet12 F2:G10
The ranges should be copied to active sheet
First dropdown values:
-UFH
-AO
-LM
Second dropdown values:
-UFH
-PEX
-MLC
Ranges:
BD UFH = Sheet10 B2:C10
BD PEX = Sheet10 D2:E10
BD MLC = Sheet10 F2:G10
AO UFH = Sheet11 B2:C10
AO PEX = Sheet11 D2:E10
AO MLC = Sheet11 F2:G10
LM UFH = Sheet12 B2:C10
LM PEX = Sheet12 D2:E10
LM MLC = Sheet12 F2:G10
The ranges should be copied to active sheet