SCROLL BAR TO PIVOT TABLE

AABID QURESHI

New Member
Joined
Dec 6, 2020
Messages
20
Office Version
  1. 2010
Platform
  1. Windows
Dear Sir,
I want to control the pivot display through scroll bar, please help me in this regards



DASHBOARD.xlsx
AUAVAW
2
3Count of Transfer To
4Transfer FromTransfer ToTotal
5AKSOBHDE4
6DHMA1
7IMWA1
8ARGADHMA4
9NAMI2
10SAMU1
11BANIGURM1
12MABH2
13TIMO4
14UJBA4
15BHDEMEJR1
16CWSPEPWS1
17MEJR2
18SHMA1
19DMPRNAMI3
20OMVR1
21DWKHBHAN11
22ENKIDHMA5
23MIGU1
24NAMI1
25TIMO4
26GNGADHMA2
27GURM1
28GULIENKI1
29KRIS1
30MABH3
31MAPI18
32MIGU1
33SHMA2
34GURMBHAN1
35UDHO1
36JOBABAAR1
37BITR1
38CWSP1
39DHMA1
40DWKH1
41ENKI2
42GORA1
43MABH1
44MIGU1
45RAMI1
46TIMO1
47UJBA6
48KADUMABH1
49MAPI1
50KAKAAKSO1
51BAAR3
52DHAN1
53ENKI2
54JOBA1
55MABH6
56MEJR1
57SHMA1
58TIMO5
59UJBA7
60KRISTIMO1
61MABHTIMO2
62MIGUBAAR2
63DHAN1
64ENKI3
65MEJR4
66MPCM1
67SAMU1
68TIGR1
69UDDK1
70MOBIARGA18
71BAAR2
72BHAN1
73DHMA12
74MABH2
75MEJR1
76NAMI29
77OMMI56
78OMPL1
79PAHR11
80SAMU1
81SHMA2
82SISA2
83TIMO2
84NAMIARGA2
85UJBA1
86OMBDENKI1
87OMDMBAAR2
88BANI5
89OMGLMAPI1
90OMGONAMI2
91OMHVARGA1
92OMJWDHAN1
93IMWA7
94OMPS1
95OMPLPAHR1
96OMVROMPL1
97PAHRARGA1
98BRJA1
99GNGA1
100SAMU6
101TIMO4
102RAMIBAAR3
103BHAN2
104ENKI4
105MABH1
106MIGU1
107TIMO3
108UJBA1
109SAMUARGA1
110DHAN1
111MABH1
112MEJR1
113SHMADHMA3
114MAPI1
115NAMI2
116SISAABCB1
117ARGA17
118BAAR2
119DHMA1
120MAPI1
121MOBI2
122NAMI13
123OMHV1
124OMPL7
125OMSI26
126OMVR1
127PAHR2
128SAMU4
129SHMA3
130TIMOGORA13
131SAMU3
132UDAIBAAR1
133UJBABANI1
134UPCBABCB1
135VARIARGA1
136OMVR1
137WAMAAKSO1
138DHMA3
139GORA16
140MEJR2
141SHMA2
142(blank)(blank)
TRANSFER
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,216,028
Messages
6,128,383
Members
449,445
Latest member
JJFabEngineering

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
Back
Top