VBA Help

[hoopslogan]

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

Industry 1	Industry 2	Values	T/F	Index
A	T1	Value 1	FALSE	A-T1-Value 1
A	T1	Value 2	TRUE	A-T1-Value 2
A	T2	Value 1	TRUE	A-T2-Value 1
A	T2	Value 2	FALSE	A-T2-Value 2
A	T3	Value 1	TRUE	A-T3-Value 1
A	T3	Value 2	FALSE	A-T3-Value 2
A	T4	Value 1	FALSE	A-T4-Value 1
A	T4	Value 2	FALSE	A-T4-Value 2
A Total 1		Total Value 1	FALSE	A Total 1--Total Value 1
A Total 2		Total Value 2	FALSE	A Total 2--Total Value 2
B	F1	Value 1	FALSE	B-F1-Value 1
B	F1	Value 2	FALSE	B-F1-Value 2
B	F2	Value 1	TRUE	B-F2-Value 1
B	F2	Value 2	FALSE	B-F2-Value 2
B	F3	Value 1	FALSE	B-F3-Value 1
B	F3	Value 2	FALSE	B-F3-Value 2
B Total 1		Total Value 1	FALSE	B Total 1 --Total Value 1
B Total 2		Total Value 2	FALSE	B Total 2--Total Value 2

<colgroup><col span="2"><col><col><col></colgroup><tbody>
</tbody>

SOURCESHEET

Industry 1	Industry 2	Values	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Index
A	T1	Value 1	1.00 %	2.00 %	3.00 %	4.00 %	5.00 %	6.00 %	7.00 %	8.00 %	9.00 %	A-T1-Value 1
A	T1	Value 2	2.00%	3.00%	4.00%	5.00%	6.00%	7.00%	8.00%	9.00%	10.00%	A-T1-Value 2
A	T2	Value 1	3.00 %	4.00 %	5.00 %	6.00 %	7.00 %	8.00 %	9.00 %	10.00 %	11.00 %	A-T2-Value 1
A	T2	Value 2	4.00%	5.00%	6.00%	7.00%	8.00%	9.00%	10.00%	11.00%	12.00%	A-T2-Value 2
A	T3	Value 1	5.00 %	6.00 %	7.00 %	8.00 %	9.00 %	10.00 %	11.00 %	12.00 %	13.00 %	A-T3-Value 1
A	T3	Value 2	6.00%	7.00%	8.00%	9.00%	10.00%	11.00%	12.00%	13.00%	14.00%	A-T3-Value 2
A	T4	Value 1	7.00 %	8.00 %	9.00 %	10.00 %	11.00 %	12.00 %	13.00 %	14.00 %	15.00 %	A-T4-Value 1
A	T4	Value 2	8.00%	9.00%	10.00%	11.00%	12.00%	13.00%	14.00%	15.00%	16.00%	A-T4-Value 2
A Total 1		Total Value 1	9.00 %	10.00 %	11.00 %	12.00 %	13.00 %	14.00 %	15.00 %	16.00 %	17.00 %	A Total 1--Total Value 1
A Total 2		Total Value 2	10.00%	11.00%	12.00%	13.00%	14.00%	15.00%	16.00%	17.00%	18.00%	A Total 2--Total Value 2
B	F1	Value 1	11.00 %	12.00 %	13.00 %	14.00 %	15.00 %	16.00 %	17.00 %	18.00 %	19.00 %	B-F1-Value 1
B	F1	Value 2	12.00%	13.00%	14.00%	15.00%	16.00%	17.00%	18.00%	19.00%	20.00%	B-F1-Value 2
B	F2	Value 1	13.00 %	14.00 %	15.00 %	16.00 %	17.00 %	18.00 %	19.00 %	20.00 %	21.00 %	B-F2-Value 1
B	F2	Value 2	14.00%	15.00%	16.00%	17.00%	18.00%	19.00%	20.00%	21.00%	22.00%	B-F2-Value 2
B	F3	Value 1	15.00 %	16.00 %	17.00 %	18.00 %	19.00 %	20.00 %	21.00 %	22.00 %	23.00 %	B-F3-Value 1
B	F3	Value 2	16.00%	17.00%	18.00%	19.00%	20.00%	21.00%	22.00%	23.00%	24.00%	B-F3-Value 2
B Total 1		Total Value 1	17.00 %	18.00 %	19.00 %	20.00 %	21.00 %	22.00 %	23.00 %	24.00 %	25.00 %	B Total 1--Total Value 1
B Total 2		Total Value 2	18.00%	19.00%	20.00%	21.00%	22.00%	23.00%	24.00%	25.00%	26.00%	B Total 2--Total Value 2

<colgroup><col span="2"><col><col span="9"><col></colgroup><tbody>
</tbody>

 

[hoopslogan]

Any recommendations?