Dynamic Range Based on Keywords

maddclutch

New Member
Joined
Feb 20, 2014
Messages
1
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.
 

Forum statistics

Threads
1,085,307
Messages
5,382,838
Members
401,807
Latest member
xlWatcher

Some videos you may like

This Week's Hot Topics

Top