VBA to create a sub-set of list (advance filter)

[VBA_Newbie]

Hi folks,

I was wondering if anyone could help me get started on a macro I'm trying to create (or point me in the direction of a similar thread).

Here's what I'm trying to accomplish:

I have a "master" list that looks as follows:

Subway Van Westendorp Pricing Model.xls
	B	C	D	E	F	G	H	I	J	K
1			Prices				PurchaseProbabilities
2	Region	Product	TooExpensive	Expensive	Bargain	TooCheap	TooExpensive	Expensive	Bargain	TooCheap
3	West	A	2.50	1.99	1.99	0.99	0.00	0.81	0.81	0.00
4	North	B	3.00	2.50	1.80	1.50	0.00	0.09	0.27	0.00
5	East	C	3.00	2.00	1.98	1.00	0.00	0.27	0.81	0.00
6	South	D	3.00	1.59	1.39	0.99	0.00	0.27	0.27	0.00
7	West	E	3.00	2.00	1.99	1.20	0.00	0.81	0.27	0.00
8	North	A	3.00	2.50	2.50	1.99	0.00	0.81	0.27	0.00
9	East	B	3.00	2.00	1.50	1.50	0.00	0.09	0.27	0.00
10	South	C	3.00	2.99	1.99	0.99	0.00	0.27	0.81	0.00
11	West	D	3.00	3.00	1.99	0.99	0.00	0.03	0.81	0.00
12	North	E	3.05	3.00	2.50	2.00	0.00	0.27	0.81	0.00
13	East	A	3.29	2.89	2.29	1.59	0.00	0.09	0.27	0.00
14	South	B	3.39	3.00	2.39	1.79	0.00	0.09	0.27	0.00
15	West	C	3.49	2.99	2.49	1.99	0.00	0.27	0.81	0.00
16	North	D	3.50	2.99	1.99	0.99	0.00	0.27	0.81	0.00
17	East	E	3.50	3.00	1.99	0.99	0.00	0.27	0.81	0.00
18	South	A	3.50	2.29	1.50	1.25	0.00	0.27	0.27	0.00
19	West	B	3.50	2.99	1.99	0.99	0.00	0.03	0.09	0.00
20	North	C	3.50	3.00	2.50	1.50	0.00	0.03	0.03	0.00
RAWDATA

I'm trying to create a sub-routine that will select specific sub-sets of this master list and paste it onto another work sheet. That is, I might want have only rows where the REGION is 'West' and the PRODUCT is "D".

Any suggestions?

 

[Legacy 51064]

Can you use a pivot table with the pre-selected criteria?

 

[VBA_Newbie]

It would work...but not really what I'm looking for.

You see, I'm modifying an existing macro. That macro is used to run pricing scenarios with 1 product and 1 region. I want to have it so that the user can select a specific product in a specific region and then run the pricing scenarios. To do this, I need to select a cut of data (using the REGION and PRODUCT) and paste it into the another worksheet. The other worksheet is where the existing macro gets its data from in order to run the scenarios. I hope I've explained this properly.

Many thanks.