codingnewbie
New Member
- Joined
- Feb 23, 2017
- Messages
- 2
I'm just learning to improve my VBA skills. Made lots of progress yesterday but now I find myself faced with a momentary wall...
My dilema:
I have two sets of data in Sheet2: one set in array AT1:BU2000 and the second in array AB1:AR2000.
There is a drop-down menu in Sheet 1 containing a list of 7 text values.
If the menu contains these values: 30x20, 50x20, 180x20 or SL, then I need the values in Sheet 2 array AB1:AR2000 to be copied to Sheet 3 cell AS 1.
Otherwise, if the drop-down menu is selected to one of the 4 remaining options (50x20, 130x70, 150x50), them the code should copy values in Sheet2 array AT1:BU2000 to Sheet3 cell AS1.
Also, values (not formulas) should be copied to Sheet 3
Could anyone please help?
Thank you in advance!
My dilema:
I have two sets of data in Sheet2: one set in array AT1:BU2000 and the second in array AB1:AR2000.
There is a drop-down menu in Sheet 1 containing a list of 7 text values.
If the menu contains these values: 30x20, 50x20, 180x20 or SL, then I need the values in Sheet 2 array AB1:AR2000 to be copied to Sheet 3 cell AS 1.
Otherwise, if the drop-down menu is selected to one of the 4 remaining options (50x20, 130x70, 150x50), them the code should copy values in Sheet2 array AT1:BU2000 to Sheet3 cell AS1.
Also, values (not formulas) should be copied to Sheet 3
Could anyone please help?
Thank you in advance!