In support of this answer
https://excelfox.com/forum/showthrea...ll=1#post15046


Before:
___ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( Using Excel 2007 32 bit )
Row\Col A B C D E
1 Sales Man Territory Dimension Sales Amt Cost
2 John New York Tissue
1,000.00
200.00
3 Alfred Washington Soda
2,100.00
700.00
4 John New York Soda
2,050.00
1,500.00
5 Alfred New York Tissue
2,000.00
500.00
6 Leo Washington Soda
200.00
100.00
7 Leo New York Tissue
3,500.00
1,500.00
8 Maxwell Washington Towel
1,000.00
800.00
Worksheet: Export1


_____ Workbook: AllFormulasAndVBAMultipleCriteria.xlsm ( Using Excel 2007 32 bit )
Row\Col A B C D E
1 Sales Man Territory Dimension Sales Amt Cost
2 John New York Tissue
3 John New York Soda
4 John New York Paper
5 John New York Towel
6 John Washington Tissue
7 John Washington Soda
8 John Washington Paper
9 John Washington Towel
10 Alfred New York Tissue
11 Alfred New York Soda
12 Alfred New York Paper
13 Alfred New York Towel
14 Alfred Washington Tissue
15 Alfred Washington Soda
16 Alfred Washington Paper
17 Alfred Washington Towel
18 Leo New York Tissue
19 Leo New York Soda
20 Leo New York Paper
21 Leo New York Towel
22 Leo Washington Tissue
23 Leo Washington Soda
24 Leo Washington Paper
25 Leo Washington Towel
26 Maxwell New York Tissue
27 Maxwell New York Soda
28 Maxwell New York Paper
29 Maxwell New York Towel
30 Maxwell Washington Tissue
31 Maxwell Washington Soda
32 Maxwell Washington Paper
33 Maxwell Washington Towel
Worksheet: ResultVBA