thomasuponor
New Member
- Joined
- Sep 13, 2018
- Messages
- 44
- Office Version
- 2016
- Platform
- Windows
I have 2 dropdowns and would like to copy/paste different ranges based on selected values from the dropdowns (I know how to copy/paste but not based on dropdowns).
First dropdown values:
-BD
-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
Any tips on how to do this?
Thx
First dropdown values:
-BD
-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
Any tips on how to do this?
Thx