Greetings all,
First off, Im great with formulas and even sql but clueless in vba. As such, I have a report I need to recreate urgently, which has 2 drop down menu boxes that populate the underlying spreadsheet.( The actual data is stored in subsequent tabs and static) Also, there are 9 total combinations of conditions. I have no clue where to begin but I assume the following: I would only need to assign a Macro to one drop down list box and I could just copy and paste ranges based on an if statement of some sort. Any help would be much appreciated. Also willing to pay for some help too.
Here are the conditions if I were to copy the data.
Condition1: IF Drop box1 value = Product 1 and Drop Box2 value = Metric 1 then
Copy Paste Special Values
(From: Tab3Wk D2:BD3 To: Report 1 F11:BF12
From: Tab2Wk C2:D9 To: Report 1 C14:D21
From: Tab2Wk E2:BE9 To: Report 1 F14:BF21
From: Tab1Wk C2:E45 To: Report 1 B28:D71
From: Tab1Wk F2:BF45 To: Report 1 F28:BF71 )
Condition2:Condition1 IF Drop box1 value = Product 2 and Drop Box2 value = Metric 1 then
Copy Paste Special Values(From: Tab3Wk D4:BD5 To: Report 1 F11:BF12
From: Tab2Wk C10:D17 To: Report 1 C14:D21
From: Tab2Wk E10:BE17 To: Report 1 F14:BF21
From: Tab1Wk C46:E89 To: Report 1 B28:D71
From: Tab1Wk F46:BF89 To: Report 1 F28:BF71 )
So forth and so on.
First off, Im great with formulas and even sql but clueless in vba. As such, I have a report I need to recreate urgently, which has 2 drop down menu boxes that populate the underlying spreadsheet.( The actual data is stored in subsequent tabs and static) Also, there are 9 total combinations of conditions. I have no clue where to begin but I assume the following: I would only need to assign a Macro to one drop down list box and I could just copy and paste ranges based on an if statement of some sort. Any help would be much appreciated. Also willing to pay for some help too.
Here are the conditions if I were to copy the data.
Condition1: IF Drop box1 value = Product 1 and Drop Box2 value = Metric 1 then
Copy Paste Special Values
(From: Tab3Wk D2:BD3 To: Report 1 F11:BF12
From: Tab2Wk C2:D9 To: Report 1 C14:D21
From: Tab2Wk E2:BE9 To: Report 1 F14:BF21
From: Tab1Wk C2:E45 To: Report 1 B28:D71
From: Tab1Wk F2:BF45 To: Report 1 F28:BF71 )
Condition2:Condition1 IF Drop box1 value = Product 2 and Drop Box2 value = Metric 1 then
Copy Paste Special Values(From: Tab3Wk D4:BD5 To: Report 1 F11:BF12
From: Tab2Wk C10:D17 To: Report 1 C14:D21
From: Tab2Wk E10:BE17 To: Report 1 F14:BF21
From: Tab1Wk C46:E89 To: Report 1 B28:D71
From: Tab1Wk F46:BF89 To: Report 1 F28:BF71 )
So forth and so on.