Dynamic Range Based on Keywords

[maddclutch]

Can someone give me a hand with this? I have several charts of different types that reference data on a separate tab. The tab where the data resides is similar to this:

Year	Quarter	Region	Period	Opened	Closed	Pending	Pending 30
2013	Q1	Africa/ Eurasia	Q1 '13
2013	Q1	Asia	Q1 '13
2013	Q1	Europe	Q1 '13
2013	Q1	Global	Q1 '13
2013	Q1	Latin America	Q1 '13
2013	Q1	North America	Q1 '13
2013	Q1	South Pacific	Q1 '13
2013	Q2	Africa/ Eurasia	Q2 '13	16	14	2
2013	Q2	Asia	Q2 '13	7	7
2013	Q2	Europe	Q2 '13	19	16	3
2013	Q2	Global	Q2 '13	2	2
2013	Q2	Latin America	Q2 '13	11	10	1
2013	Q2	North America	Q2 '13	41	41
2013	Q2	South Pacific	Q2 '13	23	23
2013	Q3	Africa/ Eurasia	Q3 '13	16	11	5
2013	Q3	Asia	Q3 '13	5	3	2
2013	Q3	Europe	Q3 '13	24	18	6
2013	Q3	Global	Q3 '13	4	2	2

<tbody>
</tbody>

Rather than manually updating the range on each chart (total of 224), is there a formula that I can use so that the range on any given chart consists of rows containing a specific region?

For example, using the above set, how would I set the range to A1:H19 WHERE C:C = North America

Any help on this would be greatly appreciated.

Thanks.