Filter all the data for multiple IDs on separate tab Excel 2013

Sufiyan97

Sufiyan97

Well-known Member
Joined
Apr 12, 2019
Messages
1,585
Office Version
  1. 365
  2. 2013
Platform
  1. Windows
Below is raw data

Dunkin New Import - Copy.xlsx
ABCDEFGHIJKLM
1Profit CenterInvoice NumberInvoice DateVendorDescriptionVendor Invoice NumberInvoice AmountDue DateInvoice BalancePayment StatusPayment DateRecipient EmailHold Status
231029612198342/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-310296$1.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
335831712203352/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-358317$1.002/24/2024$0.00Paid2/27/2024ms@goldendonut.netNo
435791312206352/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-357913$1.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
535452512215872/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-354525$1.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
630788112180192/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-307881$2.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
731027712198272/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-310277$2.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
834993012208352/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-349930$3.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
935924412209992/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-359244$4.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
1035924212209982/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-359242$4.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
1136305412203482/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-363054$7.002/24/2024$0.00Paid2/27/2024Hk@goldendonut.netNo
1233201112192982/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-332011$8.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
1334688012199112/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-346880$12.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
1435973912177242/9/2024DUNKIN' BRANDS BILLINGDD Pint-Size Charitable ContributionBRCHARITY-09FEB24-359739$17.002/19/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
15359242118877292/5/2024NCR CORPORATIONDD NCR Regular300409021$20.242/15/2024$0.00Paid2/15/2024Ms@goldendonut.netNo
16345213118878032/5/2024NCR CORPORATIONDD NCR Regular300408624$48.022/15/2024$0.00Paid2/15/2024Ms@goldendonut.netNo
17307881118840772/2/2024COATES US INCDD COATES QTR24118451$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
18358317118860552/2/2024COATES US INCDD COATES QTR24119554$78.002/12/2024$0.00Paid2/13/2024ms@goldendonut.netNo
19359739118847432/2/2024COATES US INCDD COATES QTR24118661$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
20357913118851912/2/2024COATES US INCDD COATES QTR24119329$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
21359244118859232/2/2024COATES US INCDD COATES QTR24119544$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
22359242118859112/2/2024COATES US INCDD COATES QTR24119519$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
23363054118854682/2/2024COATES US INCDD COATES QTR24119376$78.002/12/2024$0.00Paid2/13/2024Hk@goldendonut.netNo
24349930118834242/2/2024COATES US INCDD COATES QTR24120834$82.682/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
25346880119056802/26/2024NCR CORPORATIONDD NCR Regular100676335$118.523/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
26358317118889802/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-358317$159.002/16/2024$0.00Paid2/20/2024ms@goldendonut.netNo
27331152118920222/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-331152$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
28335411118922062/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-335411$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
29345213118924732/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-345213$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
30349930118931732/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-349930$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
31354525118887942/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-354525$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
32346880118927202/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-346880$208.182/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
33306008118889832/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-306008$208.282/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
34330704118933342/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330704$208.652/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
35310277118932412/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310277$208.652/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
36310092118890842/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310092$208.652/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
37363054118887112/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-363054$223.462/16/2024$0.00Paid2/20/2024Hk@goldendonut.netNo
38330524118933322/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330524$232.572/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
39310092119088332/26/2024NCR CORPORATIONDD NCR Quarterly201053568$233.083/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
40363054119097052/26/2024NCR CORPORATIONDD NCR Quarterly201052759$248.893/7/2024$0.00Paid3/7/2024Hk@goldendonut.netNo
41310296118932432/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310296$251.242/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
42332011118921112/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-332011$251.242/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
43307881118930622/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-307881$254.742/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
44359244118892052/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359244$255.522/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
45359739118886292/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359739$256.862/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
46359242118892042/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359242$256.862/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
47330704119046052/26/2024NCR CORPORATIONDD NCR Quarterly201051805$269.613/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
48363625118856942/2/2024COATES US INCDD COATES QTR24120977$276.062/12/2024$0.00Paid2/13/2024billing@goldendonut.netNo
49357913118889372/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-357913$281.872/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
50310277119083212/26/2024NCR CORPORATIONDD NCR Quarterly201053975$381.803/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
51331152119068782/26/2024NCR CORPORATIONDD NCR Quarterly201056980$396.933/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
52358317119087632/26/2024NCR CORPORATIONDD NCR Quarterly201054441$401.703/7/2024$0.00Paid3/7/2024ms@goldendonut.netNo
53359242119124672/26/2024NCR CORPORATIONDD NCR Quarterly201059679$404.343/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
54345213119068792/26/2024NCR CORPORATIONDD NCR Quarterly201056981$421.003/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
55357913119105452/26/2024NCR CORPORATIONDD NCR Quarterly201055773$430.423/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
56346880119055122/26/2024NCR CORPORATIONDD NCR Quarterly201054101$446.863/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
57349930119042282/26/2024NCR CORPORATIONDD NCR Quarterly201060827$447.983/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
58306008119118402/26/2024NCR CORPORATIONDD NCR Quarterly201059035$466.063/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
59354525119107552/26/2024NCR CORPORATIONDD NCR Quarterly201056425$475.263/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
60335411119052062/26/2024NCR CORPORATIONDD NCR Quarterly201053216$487.513/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
61332011119052072/26/2024NCR CORPORATIONDD NCR Quarterly201053217$493.513/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
62359244119099932/26/2024NCR CORPORATIONDD NCR Quarterly201056288$500.623/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
63310296119052082/26/2024NCR CORPORATIONDD NCR Quarterly201053218$518.263/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
64359739119125032/26/2024NCR CORPORATIONDD NCR Quarterly201060847$547.613/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
65330524119052092/26/2024NCR CORPORATIONDD NCR Quarterly201053219$562.683/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
66307881119068762/26/2024NCR CORPORATIONDD NCR Quarterly201056978$592.863/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
67346880118879872/5/2024NCR CORPORATIONDD NCR Regular100672607$7,160.962/15/2024$0.00Paid2/15/2024Ms@goldendonut.netNo
68331152119023442/23/2024COATES US INCDD COATES REG24123700$22,600.253/4/2024$0.00Paid3/5/2024Ms@goldendonut.netNo
Raw Data



Criteria which meets ID number in column A of raw data, I want all below IDs data to a separate tab using Excel 2013

Dunkin New Import - Copy.xlsx
O
2359739
3359739
4363054
5357913
6306008
7354525
8359242
9310092
10358317
11359244
12363625
Raw Data
 
Sort by date Sort by votes
Georgiboy said:
Another potential option, if you add a sheet named "Criteria" and put he criteria in it as below:
Book1
A
1Profit Center
2359739
3359739
4363054
5357913
6306008
7354525
8359242
9310092
10358317
11359244
12363625
Criteria


Then you could give the below a try:
VBA Code: 
Sub test()
    Dim wsRD As Worksheet, wsCr As Worksheet, rngRD As Range, rngCr As Range, rngDest As Range
 
    Set wsRD = Sheets("Raw Data")
    Set wsCr = Sheets("Criteria")
    Set rngRD = wsRD.UsedRange
    Set rngCr = wsCr.UsedRange

    rngRD.AdvancedFilter xlFilterInPlace, rngCr
    Set rngDest = Application.InputBox("Select destination cell", "Select cell", Type:=8)
    rngRD.SpecialCells(xlCellTypeVisible).Copy rngDest
    wsRD.ShowAllData
End Sub
Click to expand...

Hi Georgiboy, thanks for responding

When I run this code

It gets all the data you can see below, I have added additional column to show what happens

Dunkin New Import - Copy - Copy.xlsx
ABCDEFGHIJKLMNO
1Profit CenterAdditional ColumnProfit CenterInvoice NumberInvoice DateVendorDescriptionVendor Invoice NumberInvoice AmountDue DateInvoice BalancePayment StatusPayment DateRecipient EmailHold Status
2359739#N/A3102961219834########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-310296$1.00########$0.00Paid########Ms@goldendonut.netNo
335973993583171220335########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-358317$1.00########$0.00Paid########ms@goldendonut.netNo
436305443579131220635########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-357913$1.00########$0.00Paid########Ms@goldendonut.netNo
535791363545251221587########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-354525$1.00########$0.00Paid########Ms@goldendonut.netNo
6306008#N/A3078811218019########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-307881$2.00########$0.00Paid########Ms@goldendonut.netNo
7354525#N/A3102771219827########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-310277$2.00########$0.00Paid########Ms@goldendonut.netNo
8359242#N/A3499301220835########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-349930$3.00########$0.00Paid########Ms@goldendonut.netNo
9310092103592441220999########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-359244$4.00########$0.00Paid########Ms@goldendonut.netNo
1035831773592421220998########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-359242$4.00########$0.00Paid########Ms@goldendonut.netNo
1135924433630541220348########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-363054$7.00########$0.00Paid########Hk@goldendonut.netNo
12363625#N/A3320111219298########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-332011$8.00########$0.00Paid########Ms@goldendonut.netNo
13#N/A3468801219911########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-346880$12.00########$0.00Paid########Ms@goldendonut.netNo
14135973912177242/9/2024DUNKIN' BRANDS BILLINGDD Pint-Size Charitable ContributionBRCHARITY-09FEB24-359739$17.00########$0.00Paid########Ms@goldendonut.netNo
157359242118877292/5/2024NCR CORPORATIONDD NCR Regular3E+08$20.24########$0.00Paid########Ms@goldendonut.netNo
16#N/A345213118878032/5/2024NCR CORPORATIONDD NCR Regular3E+08$48.02########$0.00Paid########Ms@goldendonut.netNo
17#N/A307881118840772/2/2024COATES US INCDD COATES QTR24118451$78.00########$0.00Paid########Ms@goldendonut.netNo
189358317118860552/2/2024COATES US INCDD COATES QTR24119554$78.00########$0.00Paid########ms@goldendonut.netNo
191359739118847432/2/2024COATES US INCDD COATES QTR24118661$78.00########$0.00Paid########Ms@goldendonut.netNo
204357913118851912/2/2024COATES US INCDD COATES QTR24119329$78.00########$0.00Paid########Ms@goldendonut.netNo
2110359244118859232/2/2024COATES US INCDD COATES QTR24119544$78.00########$0.00Paid########Ms@goldendonut.netNo
227359242118859112/2/2024COATES US INCDD COATES QTR24119519$78.00########$0.00Paid########Ms@goldendonut.netNo
233363054118854682/2/2024COATES US INCDD COATES QTR24119376$78.00########$0.00Paid########Hk@goldendonut.netNo
24#N/A349930118834242/2/2024COATES US INCDD COATES QTR24120834$82.68########$0.00Paid########Ms@goldendonut.netNo
25#N/A34688011905680########NCR CORPORATIONDD NCR Regular1.01E+08$118.523/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
269358317118889802/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-358317$159.00########$0.00Paid########ms@goldendonut.netNo
27#N/A331152118920222/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-331152$207.46########$0.00Paid########Ms@goldendonut.netNo
28#N/A335411118922062/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-335411$207.46########$0.00Paid########Ms@goldendonut.netNo
29#N/A345213118924732/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-345213$207.46########$0.00Paid########Ms@goldendonut.netNo
30#N/A349930118931732/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-349930$207.46########$0.00Paid########Ms@goldendonut.netNo
316354525118887942/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-354525$207.46########$0.00Paid########Ms@goldendonut.netNo
32#N/A346880118927202/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-346880$208.18########$0.00Paid########Ms@goldendonut.netNo
335306008118889832/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-306008$208.28########$0.00Paid########Ms@goldendonut.netNo
34#N/A330704118933342/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330704$208.65########$0.00Paid########Ms@goldendonut.netNo
35#N/A310277118932412/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310277$208.65########$0.00Paid########Ms@goldendonut.netNo
368310092118890842/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310092$208.65########$0.00Paid########Ms@goldendonut.netNo
373363054118887112/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-363054$223.46########$0.00Paid########Hk@goldendonut.netNo
38#N/A330524118933322/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330524$232.57########$0.00Paid########Ms@goldendonut.netNo
39831009211908833########NCR CORPORATIONDD NCR Quarterly2.01E+08$233.083/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
40336305411909705########NCR CORPORATIONDD NCR Quarterly2.01E+08$248.893/7/2024$0.00Paid3/7/2024Hk@goldendonut.netNo
41#N/A310296118932432/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310296$251.24########$0.00Paid########Ms@goldendonut.netNo
42#N/A332011118921112/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-332011$251.24########$0.00Paid########Ms@goldendonut.netNo
43#N/A307881118930622/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-307881$254.74########$0.00Paid########Ms@goldendonut.netNo
4410359244118892052/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359244$255.52########$0.00Paid########Ms@goldendonut.netNo
451359739118886292/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359739$256.86########$0.00Paid########Ms@goldendonut.netNo
467359242118892042/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359242$256.86########$0.00Paid########Ms@goldendonut.netNo
47#N/A33070411904605########NCR CORPORATIONDD NCR Quarterly2.01E+08$269.613/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
4811363625118856942/2/2024COATES US INCDD COATES QTR24120977$276.06########$0.00Paid########billing@goldendonut.netNo
494357913118889372/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-357913$281.87########$0.00Paid########Ms@goldendonut.netNo
50#N/A31027711908321########NCR CORPORATIONDD NCR Quarterly2.01E+08$381.803/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
51#N/A33115211906878########NCR CORPORATIONDD NCR Quarterly2.01E+08$396.933/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
52935831711908763########NCR CORPORATIONDD NCR Quarterly2.01E+08$401.703/7/2024$0.00Paid3/7/2024ms@goldendonut.netNo
53735924211912467########NCR CORPORATIONDD NCR Quarterly2.01E+08$404.343/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
54#N/A34521311906879########NCR CORPORATIONDD NCR Quarterly2.01E+08$421.003/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
55435791311910545########NCR CORPORATIONDD NCR Quarterly2.01E+08$430.423/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
56#N/A34688011905512########NCR CORPORATIONDD NCR Quarterly2.01E+08$446.863/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
57#N/A34993011904228########NCR CORPORATIONDD NCR Quarterly2.01E+08$447.983/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
58530600811911840########NCR CORPORATIONDD NCR Quarterly2.01E+08$466.063/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
59635452511910755########NCR CORPORATIONDD NCR Quarterly2.01E+08$475.263/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
60#N/A33541111905206########NCR CORPORATIONDD NCR Quarterly2.01E+08$487.513/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
61#N/A33201111905207########NCR CORPORATIONDD NCR Quarterly2.01E+08$493.513/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
621035924411909993########NCR CORPORATIONDD NCR Quarterly2.01E+08$500.623/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
63#N/A31029611905208########NCR CORPORATIONDD NCR Quarterly2.01E+08$518.263/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
64135973911912503########NCR CORPORATIONDD NCR Quarterly2.01E+08$547.613/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
65#N/A33052411905209########NCR CORPORATIONDD NCR Quarterly2.01E+08$562.683/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
66#N/A30788111906876########NCR CORPORATIONDD NCR Quarterly2.01E+08$592.863/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
67#N/A346880118879872/5/2024NCR CORPORATIONDD NCR Regular1.01E+08################$0.00Paid########Ms@goldendonut.netNo
68#N/A33115211902344########COATES US INCDD COATES REG24123700########3/4/2024$0.00Paid3/5/2024Ms@goldendonut.netNo
Criteria
Cell Formulas
RangeFormula
B2:B68B2=MATCH(C2,$A$2:$A$12,0)
 
Upvote 0

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
The Type:=8 inputbox method in post 6 allows you to select a range, have you tested that?

When the inputbox pops up, put your cursor in the input part of the inputbox and then select the range on another sheet where you want the data to be posted.
 
Upvote 0
Yes it allows me to select the destination
But what my point is it is taking all the data from Raw Data sheet, I just want the data which meets criteria.

Let me know if I am not clear.

Also it gives below error

1710501455265.png


in this line

1710501471855.png
 
Upvote 0
To run my code you need the sheet named 'Raw Data':
Book1
ABCDEFGHIJKLM
1Profit CenterInvoice NumberInvoice DateVendorDescriptionVendor Invoice NumberInvoice AmountDue DateInvoice BalancePayment StatusPayment DateRecipient EmailHold Status
231029612198342/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-31029612/24/20240Paid2/27/2024Ms@goldendonut.netNo
335831712203352/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-35831712/24/20240Paid2/27/2024ms@goldendonut.netNo
435791312206352/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-35791312/24/20240Paid2/27/2024Ms@goldendonut.netNo
535452512215872/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-35452512/24/20240Paid2/27/2024Ms@goldendonut.netNo
630788112180192/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-30788122/24/20240Paid2/27/2024Ms@goldendonut.netNo
731027712198272/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-31027722/24/20240Paid2/27/2024Ms@goldendonut.netNo
834993012208352/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-34993032/24/20240Paid2/27/2024Ms@goldendonut.netNo
935924412209992/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-35924442/24/20240Paid2/27/2024Ms@goldendonut.netNo
1035924212209982/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-35924242/24/20240Paid2/27/2024Ms@goldendonut.netNo
1136305412203482/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-36305472/24/20240Paid2/27/2024Hk@goldendonut.netNo
1233201112192982/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-33201182/24/20240Paid2/27/2024Ms@goldendonut.netNo
1334688012199112/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-346880122/24/20240Paid2/27/2024Ms@goldendonut.netNo
14359739121772402/09/2024DUNKIN' BRANDS BILLINGDD Pint-Size Charitable ContributionBRCHARITY-09FEB24-359739172/19/20240Paid2/20/2024Ms@goldendonut.netNo
153592421188772902/05/2024NCR CORPORATIONDD NCR Regular30040902120.242/15/20240Paid2/15/2024Ms@goldendonut.netNo
163452131188780302/05/2024NCR CORPORATIONDD NCR Regular30040862448.022/15/20240Paid2/15/2024Ms@goldendonut.netNo
173078811188407702/02/2024COATES US INCDD COATES QTR241184517802/12/20240Paid2/13/2024Ms@goldendonut.netNo
183583171188605502/02/2024COATES US INCDD COATES QTR241195547802/12/20240Paid2/13/2024ms@goldendonut.netNo
193597391188474302/02/2024COATES US INCDD COATES QTR241186617802/12/20240Paid2/13/2024Ms@goldendonut.netNo
203579131188519102/02/2024COATES US INCDD COATES QTR241193297802/12/20240Paid2/13/2024Ms@goldendonut.netNo
213592441188592302/02/2024COATES US INCDD COATES QTR241195447802/12/20240Paid2/13/2024Ms@goldendonut.netNo
223592421188591102/02/2024COATES US INCDD COATES QTR241195197802/12/20240Paid2/13/2024Ms@goldendonut.netNo
233630541188546802/02/2024COATES US INCDD COATES QTR241193767802/12/20240Paid2/13/2024Hk@goldendonut.netNo
243499301188342402/02/2024COATES US INCDD COATES QTR2412083482.6802/12/20240Paid2/13/2024Ms@goldendonut.netNo
25346880119056802/26/2024NCR CORPORATIONDD NCR Regular100676335118.5203/07/20240Paid03/07/2024Ms@goldendonut.netNo
263583171188898002/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-3583171592/16/20240Paid2/20/2024ms@goldendonut.netNo
273311521189202202/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-331152207.462/16/20240Paid2/20/2024Ms@goldendonut.netNo
283354111189220602/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-335411207.462/16/20240Paid2/20/2024Ms@goldendonut.netNo
293452131189247302/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-345213207.462/16/20240Paid2/20/2024Ms@goldendonut.netNo
303499301189317302/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-349930207.462/16/20240Paid2/20/2024Ms@goldendonut.netNo
313545251188879402/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-354525207.462/16/20240Paid2/20/2024Ms@goldendonut.netNo
323468801189272002/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-346880208.182/16/20240Paid2/20/2024Ms@goldendonut.netNo
333060081188898302/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-306008208.282/16/20240Paid2/20/2024Ms@goldendonut.netNo
343307041189333402/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330704208.652/16/20240Paid2/20/2024Ms@goldendonut.netNo
353102771189324102/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310277208.652/16/20240Paid2/20/2024Ms@goldendonut.netNo
363100921188908402/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310092208.652/16/20240Paid2/20/2024Ms@goldendonut.netNo
373630541188871102/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-363054223.462/16/20240Paid2/20/2024Hk@goldendonut.netNo
383305241189333202/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330524232.572/16/20240Paid2/20/2024Ms@goldendonut.netNo
39310092119088332/26/2024NCR CORPORATIONDD NCR Quarterly201053568233.0803/07/20240Paid03/07/2024Ms@goldendonut.netNo
40363054119097052/26/2024NCR CORPORATIONDD NCR Quarterly201052759248.8903/07/20240Paid03/07/2024Hk@goldendonut.netNo
413102961189324302/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310296251.242/16/20240Paid2/20/2024Ms@goldendonut.netNo
423320111189211102/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-332011251.242/16/20240Paid2/20/2024Ms@goldendonut.netNo
433078811189306202/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-307881254.742/16/20240Paid2/20/2024Ms@goldendonut.netNo
443592441188920502/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359244255.522/16/20240Paid2/20/2024Ms@goldendonut.netNo
453597391188862902/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359739256.862/16/20240Paid2/20/2024Ms@goldendonut.netNo
463592421188920402/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359242256.862/16/20240Paid2/20/2024Ms@goldendonut.netNo
47330704119046052/26/2024NCR CORPORATIONDD NCR Quarterly201051805269.6103/07/20240Paid03/07/2024Ms@goldendonut.netNo
483636251188569402/02/2024COATES US INCDD COATES QTR24120977276.0602/12/20240Paid2/13/2024billing@goldendonut.netNo
493579131188893702/06/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-357913281.872/16/20240Paid2/20/2024Ms@goldendonut.netNo
50310277119083212/26/2024NCR CORPORATIONDD NCR Quarterly201053975381.803/07/20240Paid03/07/2024Ms@goldendonut.netNo
51331152119068782/26/2024NCR CORPORATIONDD NCR Quarterly201056980396.9303/07/20240Paid03/07/2024Ms@goldendonut.netNo
52358317119087632/26/2024NCR CORPORATIONDD NCR Quarterly201054441401.703/07/20240Paid03/07/2024ms@goldendonut.netNo
53359242119124672/26/2024NCR CORPORATIONDD NCR Quarterly201059679404.3403/07/20240Paid03/07/2024Ms@goldendonut.netNo
54345213119068792/26/2024NCR CORPORATIONDD NCR Quarterly20105698142103/07/20240Paid03/07/2024Ms@goldendonut.netNo
55357913119105452/26/2024NCR CORPORATIONDD NCR Quarterly201055773430.4203/07/20240Paid03/07/2024Ms@goldendonut.netNo
56346880119055122/26/2024NCR CORPORATIONDD NCR Quarterly201054101446.8603/07/20240Paid03/07/2024Ms@goldendonut.netNo
57349930119042282/26/2024NCR CORPORATIONDD NCR Quarterly201060827447.9803/07/20240Paid03/07/2024Ms@goldendonut.netNo
58306008119118402/26/2024NCR CORPORATIONDD NCR Quarterly201059035466.0603/07/20240Paid03/07/2024Ms@goldendonut.netNo
59354525119107552/26/2024NCR CORPORATIONDD NCR Quarterly201056425475.2603/07/20240Paid03/07/2024Ms@goldendonut.netNo
60335411119052062/26/2024NCR CORPORATIONDD NCR Quarterly201053216487.5103/07/20240Paid03/07/2024Ms@goldendonut.netNo
61332011119052072/26/2024NCR CORPORATIONDD NCR Quarterly201053217493.5103/07/20240Paid03/07/2024Ms@goldendonut.netNo
62359244119099932/26/2024NCR CORPORATIONDD NCR Quarterly201056288500.6203/07/20240Paid03/07/2024Ms@goldendonut.netNo
63310296119052082/26/2024NCR CORPORATIONDD NCR Quarterly201053218518.2603/07/20240Paid03/07/2024Ms@goldendonut.netNo
64359739119125032/26/2024NCR CORPORATIONDD NCR Quarterly201060847547.6103/07/20240Paid03/07/2024Ms@goldendonut.netNo
65330524119052092/26/2024NCR CORPORATIONDD NCR Quarterly201053219562.6803/07/20240Paid03/07/2024Ms@goldendonut.netNo
66307881119068762/26/2024NCR CORPORATIONDD NCR Quarterly201056978592.8603/07/20240Paid03/07/2024Ms@goldendonut.netNo
673468801188798702/05/2024NCR CORPORATIONDD NCR Regular1006726077160.962/15/20240Paid2/15/2024Ms@goldendonut.netNo
68331152119023442/23/2024COATES US INCDD COATES REG2412370022600.2503/04/20240Paid03/05/2024Ms@goldendonut.netNo
Raw Data


A sheet named 'Criteria' containing the profit centre numbers you wish to extract, this column needs to have the same heading as found in the 'Raw Data' tab:
Book1
A
1Profit Center
2359739
3359739
4363054
5357913
6306008
7354525
8359242
9310092
10358317
11359244
12363625
13
14
15
16
Criteria


And a blank sheet for the result to be pasted.

Run the code, select a cell in the blank sheet (using the inputbox) and click ok.
 
Upvote 0
Okay, I did that

added Criteria Sheet and added blank sheet "Sheet5"

Below is Raw Data

Dunkin New Import - Copy - Copy.xlsx
ABCDEFGHIJKLM
1Profit CenterInvoice NumberInvoice DateVendorDescriptionVendor Invoice NumberInvoice AmountDue DateInvoice BalancePayment StatusPayment DateRecipient EmailHold Status
231029612198342/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-310296$1.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
335831712203352/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-358317$1.002/24/2024$0.00Paid2/27/2024ms@goldendonut.netNo
435791312206352/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-357913$1.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
535452512215872/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-354525$1.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
630788112180192/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-307881$2.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
731027712198272/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-310277$2.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
834993012208352/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-349930$3.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
935924412209992/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-359244$4.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
1035924212209982/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-359242$4.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
1136305412203482/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-363054$7.002/24/2024$0.00Paid2/27/2024Hk@goldendonut.netNo
1233201112192982/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-332011$8.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
1334688012199112/14/2024DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-346880$12.002/24/2024$0.00Paid2/27/2024Ms@goldendonut.netNo
1435973912177242/9/2024DUNKIN' BRANDS BILLINGDD Pint-Size Charitable ContributionBRCHARITY-09FEB24-359739$17.002/19/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
15359242118877292/5/2024NCR CORPORATIONDD NCR Regular300409021$20.242/15/2024$0.00Paid2/15/2024Ms@goldendonut.netNo
16345213118878032/5/2024NCR CORPORATIONDD NCR Regular300408624$48.022/15/2024$0.00Paid2/15/2024Ms@goldendonut.netNo
17307881118840772/2/2024COATES US INCDD COATES QTR24118451$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
18358317118860552/2/2024COATES US INCDD COATES QTR24119554$78.002/12/2024$0.00Paid2/13/2024ms@goldendonut.netNo
19359739118847432/2/2024COATES US INCDD COATES QTR24118661$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
20357913118851912/2/2024COATES US INCDD COATES QTR24119329$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
21359244118859232/2/2024COATES US INCDD COATES QTR24119544$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
22359242118859112/2/2024COATES US INCDD COATES QTR24119519$78.002/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
23363054118854682/2/2024COATES US INCDD COATES QTR24119376$78.002/12/2024$0.00Paid2/13/2024Hk@goldendonut.netNo
24349930118834242/2/2024COATES US INCDD COATES QTR24120834$82.682/12/2024$0.00Paid2/13/2024Ms@goldendonut.netNo
25346880119056802/26/2024NCR CORPORATIONDD NCR Regular100676335$118.523/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
26358317118889802/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-358317$159.002/16/2024$0.00Paid2/20/2024ms@goldendonut.netNo
27331152118920222/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-331152$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
28335411118922062/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-335411$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
29345213118924732/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-345213$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
30349930118931732/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-349930$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
31354525118887942/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-354525$207.462/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
32346880118927202/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-346880$208.182/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
33306008118889832/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-306008$208.282/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
34330704118933342/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330704$208.652/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
35310277118932412/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310277$208.652/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
36310092118890842/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310092$208.652/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
37363054118887112/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-363054$223.462/16/2024$0.00Paid2/20/2024Hk@goldendonut.netNo
38330524118933322/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330524$232.572/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
39310092119088332/26/2024NCR CORPORATIONDD NCR Quarterly201053568$233.083/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
40363054119097052/26/2024NCR CORPORATIONDD NCR Quarterly201052759$248.893/7/2024$0.00Paid3/7/2024Hk@goldendonut.netNo
41310296118932432/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310296$251.242/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
42332011118921112/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-332011$251.242/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
43307881118930622/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-307881$254.742/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
44359244118892052/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359244$255.522/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
45359739118886292/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359739$256.862/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
46359242118892042/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359242$256.862/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
47330704119046052/26/2024NCR CORPORATIONDD NCR Quarterly201051805$269.613/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
48363625118856942/2/2024COATES US INCDD COATES QTR24120977$276.062/12/2024$0.00Paid2/13/2024billing@goldendonut.netNo
49357913118889372/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-357913$281.872/16/2024$0.00Paid2/20/2024Ms@goldendonut.netNo
50310277119083212/26/2024NCR CORPORATIONDD NCR Quarterly201053975$381.803/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
51331152119068782/26/2024NCR CORPORATIONDD NCR Quarterly201056980$396.933/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
52358317119087632/26/2024NCR CORPORATIONDD NCR Quarterly201054441$401.703/7/2024$0.00Paid3/7/2024ms@goldendonut.netNo
53359242119124672/26/2024NCR CORPORATIONDD NCR Quarterly201059679$404.343/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
54345213119068792/26/2024NCR CORPORATIONDD NCR Quarterly201056981$421.003/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
55357913119105452/26/2024NCR CORPORATIONDD NCR Quarterly201055773$430.423/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
56346880119055122/26/2024NCR CORPORATIONDD NCR Quarterly201054101$446.863/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
57349930119042282/26/2024NCR CORPORATIONDD NCR Quarterly201060827$447.983/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
58306008119118402/26/2024NCR CORPORATIONDD NCR Quarterly201059035$466.063/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
59354525119107552/26/2024NCR CORPORATIONDD NCR Quarterly201056425$475.263/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
60335411119052062/26/2024NCR CORPORATIONDD NCR Quarterly201053216$487.513/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
61332011119052072/26/2024NCR CORPORATIONDD NCR Quarterly201053217$493.513/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
62359244119099932/26/2024NCR CORPORATIONDD NCR Quarterly201056288$500.623/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
63310296119052082/26/2024NCR CORPORATIONDD NCR Quarterly201053218$518.263/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
64359739119125032/26/2024NCR CORPORATIONDD NCR Quarterly201060847$547.613/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
65330524119052092/26/2024NCR CORPORATIONDD NCR Quarterly201053219$562.683/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
66307881119068762/26/2024NCR CORPORATIONDD NCR Quarterly201056978$592.863/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
67346880118879872/5/2024NCR CORPORATIONDD NCR Regular100672607$7,160.962/15/2024$0.00Paid2/15/2024Ms@goldendonut.netNo
68331152119023442/23/2024COATES US INCDD COATES REG24123700$22,600.253/4/2024$0.00Paid3/5/2024Ms@goldendonut.netNo
Raw Data


here is criteria

Dunkin New Import - Copy - Copy.xlsx
A
1Profit Center
2359739
3359739
4363054
5357913
6306008
7354525
8359242
9310092
10358317
11359244
12363625
13
14
15
16
Criteria


below is the result

Dunkin New Import - Copy - Copy.xlsx
ABCDEFGHIJKLMNOPQRSTUV
1Profit CenterInvoice NumberInvoice DateVendorDescriptionVendor Invoice NumberInvoice AmountDue DateInvoice BalancePayment StatusPayment DateRecipient EmailHold Status
23102961219834########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-310296$1.00########$0.00Paid########Ms@goldendonut.netNo3597391250 Moreland 359739
33583171220335########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-358317$1.00########$0.00Paid########ms@goldendonut.netNo3597391250 Moreland 359739
43579131220635########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-357913$1.00########$0.00Paid########Ms@goldendonut.netNo3630542229 SCENIC HWY 363054
53545251221587########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-354525$1.00########$0.00Paid########Ms@goldendonut.netNo35791330 Moreland 357913
63078811218019########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-307881$2.00########$0.00Paid########Ms@goldendonut.netNo3060084040 E BROOKHAVEN 306008
73102771219827########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-310277$2.00########$0.00Paid########Ms@goldendonut.netNo3545255910 JIMMY CARTER 354525
83499301220835########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-349930$3.00########$0.00Paid########Ms@goldendonut.netNo359242Centerville 359242
93592441220999########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-359244$4.00########$0.00Paid########Ms@goldendonut.netNo310092EQUITABLE 310092
103592421220998########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-359242$4.00########$0.00Paid########Ms@goldendonut.netNo358317FIVE FORKS TRICKUM 358317
113630541220348########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-363054$7.00########$0.00Paid########Hk@goldendonut.netNo359244Stone Mountain 359244
123320111219298########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-332011$8.00########$0.00Paid########Ms@goldendonut.netNo363625COVINGTON HWY 363625
133468801219911########DUNKIN' BRANDS BILLINGDD JICF PAPERICONDDCHARITY-14FEB24-346880$12.00########$0.00Paid########Ms@goldendonut.netNo
1435973912177242/9/2024DUNKIN' BRANDS BILLINGDD Pint-Size Charitable ContributionBRCHARITY-09FEB24-359739$17.00########$0.00Paid########Ms@goldendonut.netNo307881307881 Club Drive
15359242118877292/5/2024NCR CORPORATIONDD NCR Regular3E+08$20.24########$0.00Paid########Ms@goldendonut.netNo310277310277 Abernathy
16345213118878032/5/2024NCR CORPORATIONDD NCR Regular3E+08$48.02########$0.00Paid########Ms@goldendonut.netNo310296310296 Suwanee
17307881118840772/2/2024COATES US INCDD COATES QTR24118451$78.00########$0.00Paid########Ms@goldendonut.netNo330524330524 Chamblee
18358317118860552/2/2024COATES US INCDD COATES QTR24119554$78.00########$0.00Paid########ms@goldendonut.netNo330704330704 Suntrust
19359739118847432/2/2024COATES US INCDD COATES QTR24118661$78.00########$0.00Paid########Ms@goldendonut.netNo331152331152 Snellville
20357913118851912/2/2024COATES US INCDD COATES QTR24119329$78.00########$0.00Paid########Ms@goldendonut.netNo332011332011 Sugarhill
21359244118859232/2/2024COATES US INCDD COATES QTR24119544$78.00########$0.00Paid########Ms@goldendonut.netNo335411335411 Lilburn
22359242118859112/2/2024COATES US INCDD COATES QTR24119519$78.00########$0.00Paid########Ms@goldendonut.netNo345213345213 Sugarloaf
23363054118854682/2/2024COATES US INCDD COATES QTR24119376$78.00########$0.00Paid########Hk@goldendonut.netNo346880346880 Cascade
24349930118834242/2/2024COATES US INCDD COATES QTR24120834$82.68########$0.00Paid########Ms@goldendonut.netNo349930349930 Scenic Hwy
2534688011905680########NCR CORPORATIONDD NCR Regular1.01E+08$118.523/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
26358317118889802/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-358317$159.00########$0.00Paid########ms@goldendonut.netNo
27331152118920222/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-331152$207.46########$0.00Paid########Ms@goldendonut.netNo
28335411118922062/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-335411$207.46########$0.00Paid########Ms@goldendonut.netNo
29345213118924732/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-345213$207.46########$0.00Paid########Ms@goldendonut.netNo
30349930118931732/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-349930$207.46########$0.00Paid########Ms@goldendonut.netNo
31354525118887942/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-354525$207.46########$0.00Paid########Ms@goldendonut.netNo
32346880118927202/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-346880$208.18########$0.00Paid########Ms@goldendonut.netNo
33306008118889832/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-306008$208.28########$0.00Paid########Ms@goldendonut.netNo
34330704118933342/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330704$208.65########$0.00Paid########Ms@goldendonut.netNo
35310277118932412/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310277$208.65########$0.00Paid########Ms@goldendonut.netNo
36310092118890842/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310092$208.65########$0.00Paid########Ms@goldendonut.netNo
37363054118887112/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-363054$223.46########$0.00Paid########Hk@goldendonut.netNo
38330524118933322/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-330524$232.57########$0.00Paid########Ms@goldendonut.netNo
3931009211908833########NCR CORPORATIONDD NCR Quarterly2.01E+08$233.083/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
4036305411909705########NCR CORPORATIONDD NCR Quarterly2.01E+08$248.893/7/2024$0.00Paid3/7/2024Hk@goldendonut.netNo
41310296118932432/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-310296$251.24########$0.00Paid########Ms@goldendonut.netNo
42332011118921112/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-332011$251.24########$0.00Paid########Ms@goldendonut.netNo
43307881118930622/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-307881$254.74########$0.00Paid########Ms@goldendonut.netNo
44359244118892052/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359244$255.52########$0.00Paid########Ms@goldendonut.netNo
45359739118886292/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359739$256.86########$0.00Paid########Ms@goldendonut.netNo
46359242118892042/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-359242$256.86########$0.00Paid########Ms@goldendonut.netNo
4733070411904605########NCR CORPORATIONDD NCR Quarterly2.01E+08$269.613/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
48363625118856942/2/2024COATES US INCDD COATES QTR24120977$276.06########$0.00Paid########billing@goldendonut.netNo
49357913118889372/6/2024COMCAST HOLDINGS CORPORATIONStore Network Comcast Monthly193415170-357913$281.87########$0.00Paid########Ms@goldendonut.netNo
5031027711908321########NCR CORPORATIONDD NCR Quarterly2.01E+08$381.803/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
5133115211906878########NCR CORPORATIONDD NCR Quarterly2.01E+08$396.933/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
5235831711908763########NCR CORPORATIONDD NCR Quarterly2.01E+08$401.703/7/2024$0.00Paid3/7/2024ms@goldendonut.netNo
5335924211912467########NCR CORPORATIONDD NCR Quarterly2.01E+08$404.343/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
5434521311906879########NCR CORPORATIONDD NCR Quarterly2.01E+08$421.003/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
5535791311910545########NCR CORPORATIONDD NCR Quarterly2.01E+08$430.423/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
5634688011905512########NCR CORPORATIONDD NCR Quarterly2.01E+08$446.863/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
5734993011904228########NCR CORPORATIONDD NCR Quarterly2.01E+08$447.983/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
5830600811911840########NCR CORPORATIONDD NCR Quarterly2.01E+08$466.063/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
5935452511910755########NCR CORPORATIONDD NCR Quarterly2.01E+08$475.263/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
6033541111905206########NCR CORPORATIONDD NCR Quarterly2.01E+08$487.513/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
6133201111905207########NCR CORPORATIONDD NCR Quarterly2.01E+08$493.513/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
6235924411909993########NCR CORPORATIONDD NCR Quarterly2.01E+08$500.623/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
6331029611905208########NCR CORPORATIONDD NCR Quarterly2.01E+08$518.263/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
6435973911912503########NCR CORPORATIONDD NCR Quarterly2.01E+08$547.613/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
6533052411905209########NCR CORPORATIONDD NCR Quarterly2.01E+08$562.683/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
6630788111906876########NCR CORPORATIONDD NCR Quarterly2.01E+08$592.863/7/2024$0.00Paid3/7/2024Ms@goldendonut.netNo
67346880118879872/5/2024NCR CORPORATIONDD NCR Regular1.01E+08################$0.00Paid########Ms@goldendonut.netNo
6833115211902344########COATES US INCDD COATES REG24123700########3/4/2024$0.00Paid3/5/2024Ms@goldendonut.netNo
Sheet5



I may have made the mistake but let me know.
 
Upvote 0
Do you already have an autofilter on the data in the 'Raw Data' tab?
 
Upvote 0
Ah I think it is more to do with the 'Criteria' sheet having blank cells in the UsedRange of the sheet.

I have adjusted the below code to move away from UsedRange, give that a try:
VBA Code: 
Sub test()
    Dim wsRD As Worksheet, wsCr As Worksheet, rngRD As Range, rngCr As Range, rngDest As Range
   
    Set wsRD = Sheets("Raw Data")
    Set wsCr = Sheets("Criteria")
    Set rngRD = wsRD.Range("A1:M" & wsRD.Range("A" & Rows.Count).End(xlUp).Row)
    Set rngCr = wsCr.Range("A1:A" & wsCr.Range("A" & Rows.Count).End(xlUp).Row)

    rngRD.AdvancedFilter xlFilterInPlace, rngCr
    Set rngDest = Application.InputBox("Select destination cell", "Select cell", Type:=8)
    rngRD.SpecialCells(xlCellTypeVisible).Copy rngDest
    wsRD.ShowAllData
End Sub
 
Upvote 0
Solution
You must log in or register to reply here.

Similar threads

D
  • Question Question
Formula help needed for working with days and times.
Replies
0
Views
316
dshtesy
D
L
  • Solved
Calculate start time from end time with multiple times per day for each ID
2
Replies
10
Views
274
Fluff
Fluff
S
  • Question Question
Two way look up with mutiple duplicate criteria with mutiple return
Replies
3
Views
197
sanrama
S
E
  • Question Question
Pulling together data from multiple MS Forms spreadsheets and displaying into a single league table
Replies
6
Views
329
excelnewbie999
E
D
  • Solved
highs and lows
2
Replies
15
Views
384
felixstraube
F

Forum statistics

Threads
1,223,884
Messages
6,175,177
Members
452,615
Latest member
bogeys2birdies

Share this page

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