VBA Help

H

hoopslogan

Board Regular
Joined
Jun 21, 2016
Messages
94
Hi,

I need help creating code for the following situation:
I have two sheets. The first sheet is called the targetSheet and the second sheet is the sourceSheet. In column 4 of the targetsheet the values are either True or False. I want to make a graph of the monthly data for each True value on the targetsheet and place these graphs onto a new sheet. Basically, if the value is True on the targetSheet I want it to lookup the data from the sourcesheet for the corresponding row and create a line graph of the monthly data provided.

TARGETSHEET
[TABLE="width: 500"]
<colgroup><col span="2"><col><col><col></colgroup><tbody>[TR]
[TD]Industry 1[/TD]
[TD]Industry 2[/TD]
[TD]Values[/TD]
[TD]T/F[/TD]
[TD]Index[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T1[/TD]
[TD]Value 1[/TD]
[TD="align: center"]FALSE[/TD]
[TD]A-T1-Value 1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T1[/TD]
[TD]Value 2[/TD]
[TD="align: center"]TRUE[/TD]
[TD]A-T1-Value 2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T2[/TD]
[TD]Value 1[/TD]
[TD="align: center"]TRUE[/TD]
[TD]A-T2-Value 1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T2[/TD]
[TD]Value 2[/TD]
[TD="align: center"]FALSE[/TD]
[TD]A-T2-Value 2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T3[/TD]
[TD]Value 1[/TD]
[TD="align: center"]TRUE[/TD]
[TD]A-T3-Value 1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T3[/TD]
[TD]Value 2[/TD]
[TD="align: center"]FALSE[/TD]
[TD]A-T3-Value 2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T4[/TD]
[TD]Value 1[/TD]
[TD="align: center"]FALSE[/TD]
[TD]A-T4-Value 1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T4[/TD]
[TD]Value 2[/TD]
[TD="align: center"]FALSE[/TD]
[TD]A-T4-Value 2[/TD]
[/TR]
[TR]
[TD]A Total 1[/TD]
[TD] [/TD]
[TD]Total Value 1[/TD]
[TD="align: center"]FALSE[/TD]
[TD]A Total 1--Total Value 1[/TD]
[/TR]
[TR]
[TD]A Total 2[/TD]
[TD] [/TD]
[TD]Total Value 2[/TD]
[TD="align: center"]FALSE[/TD]
[TD]A Total 2--Total Value 2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F1[/TD]
[TD]Value 1[/TD]
[TD="align: center"]FALSE[/TD]
[TD]B-F1-Value 1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F1[/TD]
[TD]Value 2[/TD]
[TD="align: center"]FALSE[/TD]
[TD]B-F1-Value 2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F2[/TD]
[TD]Value 1[/TD]
[TD="align: center"]TRUE[/TD]
[TD]B-F2-Value 1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F2[/TD]
[TD]Value 2[/TD]
[TD="align: center"]FALSE[/TD]
[TD]B-F2-Value 2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F3[/TD]
[TD]Value 1[/TD]
[TD="align: center"]FALSE[/TD]
[TD]B-F3-Value 1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F3[/TD]
[TD]Value 2[/TD]
[TD="align: center"]FALSE[/TD]
[TD]B-F3-Value 2[/TD]
[/TR]
[TR]
[TD]B Total 1 [/TD]
[TD] [/TD]
[TD]Total Value 1[/TD]
[TD="align: center"]FALSE[/TD]
[TD]B Total 1 --Total Value 1[/TD]
[/TR]
[TR]
[TD]B Total 2[/TD]
[TD] [/TD]
[TD]Total Value 2[/TD]
[TD="align: center"]FALSE[/TD]
[TD]B Total 2--Total Value 2[/TD]
[/TR]
</tbody>[/TABLE]






SOURCESHEET
[TABLE="width: 954"]
<colgroup><col span="2"><col><col span="9"><col></colgroup><tbody>[TR]
[TD]Industry 1[/TD]
[TD]Industry 2[/TD]
[TD]Values[/TD]
[TD]Month 1[/TD]
[TD]Month 2 [/TD]
[TD]Month 3[/TD]
[TD]Month 4[/TD]
[TD]Month 5[/TD]
[TD]Month 6[/TD]
[TD]Month 7[/TD]
[TD]Month 8[/TD]
[TD]Month 9[/TD]
[TD]Index[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T1[/TD]
[TD]Value 1[/TD]
[TD="align: right"]1.00 %[/TD]
[TD="align: right"]2.00 %[/TD]
[TD="align: right"]3.00 %[/TD]
[TD="align: right"]4.00 %[/TD]
[TD="align: right"]5.00 %[/TD]
[TD="align: right"]6.00 %[/TD]
[TD="align: right"]7.00 %[/TD]
[TD="align: right"]8.00 %[/TD]
[TD="align: right"]9.00 %[/TD]
[TD]A-T1-Value 1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T1[/TD]
[TD]Value 2[/TD]
[TD="align: right"]2.00%[/TD]
[TD="align: right"]3.00%[/TD]
[TD="align: right"]4.00%[/TD]
[TD="align: right"]5.00%[/TD]
[TD="align: right"]6.00%[/TD]
[TD="align: right"]7.00%[/TD]
[TD="align: right"]8.00%[/TD]
[TD="align: right"]9.00%[/TD]
[TD="align: right"]10.00%[/TD]
[TD]A-T1-Value 2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T2[/TD]
[TD]Value 1[/TD]
[TD="align: right"]3.00 %[/TD]
[TD="align: right"]4.00 %[/TD]
[TD="align: right"]5.00 %[/TD]
[TD="align: right"]6.00 %[/TD]
[TD="align: right"]7.00 %[/TD]
[TD="align: right"]8.00 %[/TD]
[TD="align: right"]9.00 %[/TD]
[TD="align: right"]10.00 %[/TD]
[TD="align: right"]11.00 %[/TD]
[TD]A-T2-Value 1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T2[/TD]
[TD]Value 2[/TD]
[TD="align: right"]4.00%[/TD]
[TD="align: right"]5.00%[/TD]
[TD="align: right"]6.00%[/TD]
[TD="align: right"]7.00%[/TD]
[TD="align: right"]8.00%[/TD]
[TD="align: right"]9.00%[/TD]
[TD="align: right"]10.00%[/TD]
[TD="align: right"]11.00%[/TD]
[TD="align: right"]12.00%[/TD]
[TD]A-T2-Value 2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T3[/TD]
[TD]Value 1[/TD]
[TD="align: right"]5.00 %[/TD]
[TD="align: right"]6.00 %[/TD]
[TD="align: right"]7.00 %[/TD]
[TD="align: right"]8.00 %[/TD]
[TD="align: right"]9.00 %[/TD]
[TD="align: right"]10.00 %[/TD]
[TD="align: right"]11.00 %[/TD]
[TD="align: right"]12.00 %[/TD]
[TD="align: right"]13.00 %[/TD]
[TD]A-T3-Value 1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T3[/TD]
[TD]Value 2[/TD]
[TD="align: right"]6.00%[/TD]
[TD="align: right"]7.00%[/TD]
[TD="align: right"]8.00%[/TD]
[TD="align: right"]9.00%[/TD]
[TD="align: right"]10.00%[/TD]
[TD="align: right"]11.00%[/TD]
[TD="align: right"]12.00%[/TD]
[TD="align: right"]13.00%[/TD]
[TD="align: right"]14.00%[/TD]
[TD]A-T3-Value 2[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T4[/TD]
[TD]Value 1[/TD]
[TD="align: right"]7.00 %[/TD]
[TD="align: right"]8.00 %[/TD]
[TD="align: right"]9.00 %[/TD]
[TD="align: right"]10.00 %[/TD]
[TD="align: right"]11.00 %[/TD]
[TD="align: right"]12.00 %[/TD]
[TD="align: right"]13.00 %[/TD]
[TD="align: right"]14.00 %[/TD]
[TD="align: right"]15.00 %[/TD]
[TD]A-T4-Value 1[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]T4[/TD]
[TD]Value 2[/TD]
[TD="align: right"]8.00%[/TD]
[TD="align: right"]9.00%[/TD]
[TD="align: right"]10.00%[/TD]
[TD="align: right"]11.00%[/TD]
[TD="align: right"]12.00%[/TD]
[TD="align: right"]13.00%[/TD]
[TD="align: right"]14.00%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]16.00%[/TD]
[TD]A-T4-Value 2[/TD]
[/TR]
[TR]
[TD]A Total 1[/TD]
[TD] [/TD]
[TD]Total Value 1[/TD]
[TD="align: right"]9.00 %[/TD]
[TD="align: right"]10.00 %[/TD]
[TD="align: right"]11.00 %[/TD]
[TD="align: right"]12.00 %[/TD]
[TD="align: right"]13.00 %[/TD]
[TD="align: right"]14.00 %[/TD]
[TD="align: right"]15.00 %[/TD]
[TD="align: right"]16.00 %[/TD]
[TD="align: right"]17.00 %[/TD]
[TD]A Total 1--Total Value 1[/TD]
[/TR]
[TR]
[TD]A Total 2[/TD]
[TD] [/TD]
[TD]Total Value 2[/TD]
[TD="align: right"]10.00%[/TD]
[TD="align: right"]11.00%[/TD]
[TD="align: right"]12.00%[/TD]
[TD="align: right"]13.00%[/TD]
[TD="align: right"]14.00%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]16.00%[/TD]
[TD="align: right"]17.00%[/TD]
[TD="align: right"]18.00%[/TD]
[TD]A Total 2--Total Value 2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F1[/TD]
[TD]Value 1[/TD]
[TD="align: right"]11.00 %[/TD]
[TD="align: right"]12.00 %[/TD]
[TD="align: right"]13.00 %[/TD]
[TD="align: right"]14.00 %[/TD]
[TD="align: right"]15.00 %[/TD]
[TD="align: right"]16.00 %[/TD]
[TD="align: right"]17.00 %[/TD]
[TD="align: right"]18.00 %[/TD]
[TD="align: right"]19.00 %[/TD]
[TD]B-F1-Value 1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F1[/TD]
[TD]Value 2[/TD]
[TD="align: right"]12.00%[/TD]
[TD="align: right"]13.00%[/TD]
[TD="align: right"]14.00%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]16.00%[/TD]
[TD="align: right"]17.00%[/TD]
[TD="align: right"]18.00%[/TD]
[TD="align: right"]19.00%[/TD]
[TD="align: right"]20.00%[/TD]
[TD]B-F1-Value 2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F2[/TD]
[TD]Value 1[/TD]
[TD="align: right"]13.00 %[/TD]
[TD="align: right"]14.00 %[/TD]
[TD="align: right"]15.00 %[/TD]
[TD="align: right"]16.00 %[/TD]
[TD="align: right"]17.00 %[/TD]
[TD="align: right"]18.00 %[/TD]
[TD="align: right"]19.00 %[/TD]
[TD="align: right"]20.00 %[/TD]
[TD="align: right"]21.00 %[/TD]
[TD]B-F2-Value 1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F2[/TD]
[TD]Value 2[/TD]
[TD="align: right"]14.00%[/TD]
[TD="align: right"]15.00%[/TD]
[TD="align: right"]16.00%[/TD]
[TD="align: right"]17.00%[/TD]
[TD="align: right"]18.00%[/TD]
[TD="align: right"]19.00%[/TD]
[TD="align: right"]20.00%[/TD]
[TD="align: right"]21.00%[/TD]
[TD="align: right"]22.00%[/TD]
[TD]B-F2-Value 2[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F3[/TD]
[TD]Value 1[/TD]
[TD="align: right"]15.00 %[/TD]
[TD="align: right"]16.00 %[/TD]
[TD="align: right"]17.00 %[/TD]
[TD="align: right"]18.00 %[/TD]
[TD="align: right"]19.00 %[/TD]
[TD="align: right"]20.00 %[/TD]
[TD="align: right"]21.00 %[/TD]
[TD="align: right"]22.00 %[/TD]
[TD="align: right"]23.00 %[/TD]
[TD]B-F3-Value 1[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]F3[/TD]
[TD]Value 2[/TD]
[TD="align: right"]16.00%[/TD]
[TD="align: right"]17.00%[/TD]
[TD="align: right"]18.00%[/TD]
[TD="align: right"]19.00%[/TD]
[TD="align: right"]20.00%[/TD]
[TD="align: right"]21.00%[/TD]
[TD="align: right"]22.00%[/TD]
[TD="align: right"]23.00%[/TD]
[TD="align: right"]24.00%[/TD]
[TD]B-F3-Value 2[/TD]
[/TR]
[TR]
[TD]B Total 1[/TD]
[TD] [/TD]
[TD]Total Value 1[/TD]
[TD="align: right"]17.00 %[/TD]
[TD="align: right"]18.00 %[/TD]
[TD="align: right"]19.00 %[/TD]
[TD="align: right"]20.00 %[/TD]
[TD="align: right"]21.00 %[/TD]
[TD="align: right"]22.00 %[/TD]
[TD="align: right"]23.00 %[/TD]
[TD="align: right"]24.00 %[/TD]
[TD="align: right"]25.00 %[/TD]
[TD]B Total 1--Total Value 1[/TD]
[/TR]
[TR]
[TD]B Total 2[/TD]
[TD] [/TD]
[TD]Total Value 2[/TD]
[TD="align: right"]18.00%[/TD]
[TD="align: right"]19.00%[/TD]
[TD="align: right"]20.00%[/TD]
[TD="align: right"]21.00%[/TD]
[TD="align: right"]22.00%[/TD]
[TD="align: right"]23.00%[/TD]
[TD="align: right"]24.00%[/TD]
[TD="align: right"]25.00%[/TD]
[TD="align: right"]26.00%[/TD]
[TD]B Total 2--Total Value 2[/TD]
[/TR]
</tbody>[/TABLE]
 
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

H
  • Question Question
multiple criteria Costing
Replies
6
Views
231
harky
H
J
  • Question Question
Issue returning a value based on values between two percentage points
2
Replies
10
Views
981
awoohaw
awoohaw
J
  • Question Question
Lookup
Replies
3
Views
164
AhoyNC
A
K
  • Question Question
adjusting code or alternative on userform to change way of price average calculation
Replies
0
Views
82
KalilMe
K
F
  • Solved
Reference Current Non Blank Cell - Monthly Calendar
2
Replies
13
Views
1K
FERG NATION
F

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top