Filter pivot table as per list

aaravgaba

New Member
Joined
Sep 15, 2013
Messages
24
Below is the pivot table I want to filter based on a separate list containing deliverynotenumber.

Could anyone help as normally this column contains hundreds of deliverynotenumbers and i need to filter the pivot table for appx 20-22 numbers, which is very time consuming manually.

Thanks for helping everyone.

Sum of Qty Delivered
DeliverynotenumberECP PO#Supplier Part NoECP Part NoTotal
6259516670106371367882006285907705
701063 Total 5
701112713678820062859077011
701112 Total 11
70137462432113306377461706
701374 Total 6
70142962432113306377461707
62432251906417238408
701429 Total 15
70143162432113306377461707
701431 Total 7
701432414001710064444014013
62432251906417238408
701432 Total 21
70144862432113306377461706
71362631006288503305
701448 Total 11
70145062432113306377461706
701450 Total 6
701490511009310013659003048
624315810064111085062
62432113306377461707
701490 Total 117
701491511009310013659003048
619309000064172737013
624315810064111085030
701491 Total 91
701492511009310013659003048
624315810064111085031
62432113306377461707
701492 Total 86
7015265330017100326220380226
62031173306377232808
621304233063772349014
62330010006411106704
62330820006414421302
62331593406377233305
62334010006414429902
624308733063772211028
62430873406377291101
62432113306377461706
624324733063722105038
624328500064144281012
62433420006414426205
62433490906417356307
62433970006414429403
62435220006414430503
62530380906417471207
626303333063758753010
713678790062866074050
71369710006286301404
701526 Total 435
62595167701610511009310013659003050
53005761003487786583
624321133063774617011
62432850006414428107
62433970006414429404
713626310062885033012
71369710006286301404
701610 Total 91
7016115330017100326220380173
62130423306377234905
624308733063772211014
624318009064144203023
62432850006414428107
713678790062866074068
701611 Total 290
851707625310600064169235025
851707 Total 25
85465271362631006288503307
713678820062859077030
854652 Total 37
85530862432251906417238403
713678820062859077024
855308 Total 27
856544624322519064172384012
856544 Total 12
857156619309000064172737013
857156 Total 13
85869562433460006411105301
858695 Total 1
8602036243180090641442030198
860203 Total 198
860625624315810064111085099
624318009064144203046
62432003406377471503
624321133063774617012
62433460006411105301
71362631006288503305
860625 Total 166
860854624315810064111085060
624318009064144203023
713626310062885033021
860854 Total 104
86122271361867006288203404
71362631006288503307
861222 Total 11
86194651100931001365900301
533001710032622038092
624318009064144203022
71364942006281105303
713678790062866074051
861946 Total 169
861947624131300064159071012
62432113306377461707
861947 Total 19
86229653403361003262213004
535012810042559009023
624131300064159071012
862296 Total 39
86259653005341003488202287
53204023003267203607
53403361003262213006
53403621003265463901
62211900006415905301
71361867006288203404
862596 Total 26
862956418039510065059013036
420001010031333003016
500033320064488002015
500106510064444008010
510013310064582012012
510022510064574005045
511035310013659007090
51200451006455801008
53005241003487797281
53005371003486901786
53005731003489000186
53005761003487786584
53005771003485900885
53005781003485401588
53005811003486700289
530058210034877827891
53005841003484407586
53100301003265451304
53200511003284400618
53201441003261102003
53203081003267452405
532040230032672036020
532053410032674638021
532055610032611125031
53300011003261101402
53400391003261106108
534014710032658077018
534018010032654621028
534024010032674644052
534027810032644216010
535000510042544002063
53500361004254401305
53501641004251100404
53501741004258300208
53501941004255901506
54101461006192207256
61800430606414400206
61816930006415401508
61819700006414412304
61830863306377400707
61900150606415907803
619239533063772203013
6193063330637592380156
62002780606414401303
62008570006415500703
620128400064144062023
620309034063772943017
62116460006416602102
62121350006415936802
62130123306377218302
62130133306375909302
62130270006417201003
621304509064172374026
621305033063772381011
62203020606417450504
62211900006415905302
62220910006415905905
62223170006417219102
622240533063722057010
6222414330637592240222
62224143406375905706
622309533063772309017
62231133306375929403
62231280906415929804
622313909064159103012
62231463306377273607
62232310906415910808
62306080006417215303
62309720006417216005
62311390006414411202
623184500064158216017
62321023306377219202
623210433063744124014
62322910906417461202
623304300064173523058
62330830906417457701
62331313306377222104
62331480006418300201
62331593406377233306
623321009064172359014
62332410006417300403
62332920006414427402
62333140906418115503
62414890006415820301
62421580006412205502
62422310906416603302
62422770006414412802
62430330006414422204
62430773306377232008
624311600064144172013
62431200906417220801
624312609064144186013
624315433063766003020
62431563406374420907
62431720006411110503
62432193306377461904
62432303406374420705
62432601906416608101
624327909064144239010
624328500064144281015
624329733063759284053
62433090006415923209
6243312090641746370128
62433123306377493708
62433123406377463705
62433300006414424607
62433583306375103507
62433763306375103102
62433783306375925505
62434343306377201101
624355309064144312012
62530700906418223203
713615710062859524010
71362037006286701104
713649280062811030023
713649380062811061023
71366102006286907603
71366716006281100903
713667330062891000013
713667340062891001014
71366735006282201504
71366801006282209909
71367806006285901505
713678430062859055038
862956 Total 1900
6259516870155653001351003487710684
530031310034877090812
530054210034877996842
701556 Total 58
6259517470149141501581003361109804
415027310033685005010
701491 Total 14
701492415027310033685005017
701492 Total 17
701526415024410033644066021
415027210033660012071
415027310033685005013
415028410033682023011
41503001003368501006
41503861003361112208
41504851003367400007
415054310033667002031
701526 Total 168
Grand Total 4196

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Watch MrExcel Video

Forum statistics

Threads
1,108,911
Messages
5,525,593
Members
409,653
Latest member
rishir

This Week's Hot Topics

Top