VBA for Selecting Multiple Row Items In Pivot Table


Board Regular
Jan 22, 2014
Hi everyone!!!
I ve been struggling with this for quite a long. I had no luck. I have multiple ways of selecting a single range but nothing on selecting unions of ranges.
I need macro to select specific row items in a pivot table. The "table" provided below is actualy a Pivot Table.
From label "Year" till label "2 P/L" data are placed in the "Row" section of the Pivot Table called "TablePvt"
I need a macro to select the following union of data under the labels from "Year" till "Odds Class" and then from "R" till "Ft/Tl" and then from "1 P/L" till "2 P/L" leaving the totals row of the Pivot Table out of the selection

*I would prefer to use Pivot Table and labels names defining the union of data if possible*
Thank you all in advance!!!

YearDateTimeLeagueEntoseKTos11.%XX.%22.%Odds Class1stRHtScHt/DiffHt/TlRScFt/DiffFt/TlHt-FtOvUnIOvUnIIOvUnIIIGN1 P/LX P/L2 P/LΜ.Ο. Ft/HgΜ.Ο.Ft/Ag Odds Class
17 1812/8/201717:00:00ΑΓΓΠΤΣΕΛΣΙΜΠΕΡΝΛΙ1,1577%5,7515%11,508%ΑΓΓΠ 0,120:3-3322:3-1522OOOG-1,00-1,0010,502,003,001
17 1827/8/201718:00:00ΑΓΓΠΤΟΤΕΝΑΜΜΠΕΡΝΛΙ1,1577%5,5016%12,007%ΑΓΓΠ 0,1X0:000X1:102XXOuuG-1,004,50-1,001,001,001
17 1816/9/201717:00:00ΑΓΓΠΛΙΒΕΡΠΟΥΛΜΠΕΡΝΛΙ1,1578%6,2514%11,508%ΑΓΓΠ 0,1X1:102X1:102XXOuuG-1,005,25-1,001,001,001
17 181/10/201714:00:00ΑΓΓΠΑΡΣΕΝΑΛΜΠΡΑΙΤΟΝ1,1578%6,2514%11,508%ΑΓΓΠ 0,111:01112:02211Ouun0,15-1,00-1,002,000,001
17 1818/11/201719:30:00ΑΓΓΠΜΑΝΤΣΕΣΤΕΡ ΓΙΟΥΝΑΙΤΕΝΤΝΙΟΥΚΑΣΤΛ1,2075%5,0018%12,008%ΑΓΓΠ 0,112:11314:13511OOOG0,20-1,00-1,004,001,001
17 1825/11/201717:00:00ΑΓΓΠΤΟΤΕΝΑΜΓΟΥΕΣΤ ΜΠΡΟΜ1,1577%6,0015%12,007%ΑΓΓΠ 0,120:1-11X1:1022XOuuG-1,005,00-1,001,001,001
17 1826/12/201717:00:00ΑΓΓΠΜΑΝΤΣΕΣΤΕΡ ΓΙΟΥΝΑΙΤΕΝΤΜΠΕΡΝΛΙ1,2074%5,0018%11,508%ΑΓΓΠ 0,120:2-22X2:2042XOOOG-1,004,00-1,002,002,001
17 189/5/201821:45:00ΑΓΓΠΤΣΕΛΣΙΧΑΝΤΕΡΣΦΙΛΝΤ1,1577%6,0015%12,007%ΑΓΓΠ 0,1X0:000X1:102XXOuuG-1,005,00-1,001,001,001
17 189/5/201822:00:00ΑΓΓΠΤΟΤΕΝΑΜΝΙΟΥΚΑΣΤΛ1,1578%6,2514%11,508%ΑΓΓΠ 0,1X0:00011:011X1uuun0,15-1,00-1,001,000,001
17 1813/5/201817:00:00ΑΓΓΠΛΙΒΕΡΠΟΥΛΜΠΡΑΙΤΟΝ1,1479%6,5014%12,008%ΑΓΓΠ 0,112:02214:04411OOOn0,14-1,00-1,004,000,001
18 1922/9/201817:00:00ΑΓΓΠΛΙΒΕΡΠΟΥΛΣΑΟΥΘΑΜΠΤΟΝ1,1578%6,5014%11,508%ΑΓΓΠ 0,113:03313:03311OOun0,15-1,00-1,003,000,001
18 1915/12/201814:30:00ΑΓΓΠΜΑΝΤΣΕΣΤΕΡ ΣΙΤΙΕΒΕΡΤΟΝ1,1578%6,7513%11,008%ΑΓΓΠ 0,111:01113:12411OOOG0,15-1,00-1,003,001,001
18 1914/1/201922:00:00ΑΓΓΠΜΑΝΤΣΕΣΤΕΡ ΣΙΤΙΓΟΥΛΒΣ1,1380%7,0013%11,508%ΑΓΓΠ 0,112:02213:03311OOun0,13-1,00-1,003,000,001
18 1919/1/201917:00:00ΑΓΓΠΛΙΒΕΡΠΟΥΛΚΡΙΣΤΑΛ ΠΑΛΑΣ1,1578%6,5014%11,508%ΑΓΓΠ 0,120:1-1114:31721OOOG0,15-1,00-1,004,003,001
18 1929/1/201921:45:00ΑΓΓΠΑΡΣΕΝΑΛΚΑΡΝΤΙΦ1,1578%6,5014%11,508%ΑΓΓΠ 0,1X0:00012:113X1OOuG0,15-1,00-1,002,001,001
18 192/2/201917:00:00ΑΓΓΠΤΣΕΛΣΙΧΑΝΤΕΡΣΦΙΛΝΤ1,1578%6,2514%12,008%ΑΓΓΠ 0,112:02215:05511OOOn0,15-1,00-1,005,000,001
18 1922/4/201922:00:00ΑΓΓΠΤΣΕΛΣΙΜΠΕΡΝΛΙ1,1777%6,0015%11,508%ΑΓΓΠ 0,1X2:204X2:204XXOOOG-1,005,00-1,002,002,001
19 206/10/201916:00:00ΑΓΓΠΜΑΝΤΣΕΣΤΕΡ ΣΙΤΙΓΟΥΛΒΣ1,1280%7,7512%11,508%ΑΓΓΠ 0,1X0:00020:2-22X2Ouun-1,00-1,0010,500,002,001
19 207/3/202014:30:00ΑΓΓΠΛΙΒΕΡΠΟΥΛΜΠΟΡΝΜΟΥΘ1,1479%6,8513%11,508%ΑΓΓΠ 0,112:11312:11311OOuG0,14-1,00-1,002,001,001
Grand Total2,261,0519

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Forum statistics

Latest member

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back