Pivot Table or Macro to filter data with multiple criteria

Eskonn

New Member
Joined
Mar 28, 2018
Messages
18
I have a data sheet that I would like to make a pivot table or another sheet off of with a specific customer number and then day of the week.
Below is an example of some of the data.

Column E is customer numbers. I would like to make a table or sheet using specific numbers from column E and then also only if they show on a specific day from Column C
For this small example below I would like to pull the data for customers 1000097338 and 1000097338 for Thu

On my workbook I have the customer numbers on sheet 2


A B C D E F G H I J K L M N O P Q
RegionDateDay of WeekOrder NumberLocation IDNameRoute IDP SeqA SeqTotal StopsDriver NameDriver IDTW1TW2A ArivalA DepartA Service Time
STL-SAP1/2/2020Thu80038523301000102502WAL MART #7127 (POPLAR BLUFF)101124MCCSPADDEN, BRANDEN23805:00-10:0000:00-00:008:129:191:06
STL-SAP1/3/2020Wed80044225241000102502WAL MART #7127 (POPLAR BLUFF)101124MCCSPADDEN, BRANDEN23805:00-10:0000:00-00:008:129:191:06
STL-SAP1/4/2020Fri80051814201000102502WAL MART #7127 (POPLAR BLUFF)101124MCCSPADDEN, BRANDEN23805:00-10:0000:00-00:008:129:191:06
STL-SAP1/5/2020Sat80052145461000102502WAL MART #7127 (POPLAR BLUFF)101124MCCSPADDEN, BRANDEN23805:00-10:0000:00-00:008:129:191:06
STL-SAP1/2/2020Thu80053837171000102502WAL MART #7127 (POPLAR BLUFF)101124MCCSPADDEN, BRANDEN23805:00-10:0000:00-00:008:129:191:06
STL-SAP1/2/2020Thu80053975701000097338J D'S QUICK STOP102224MCCSPADDEN, BRANDEN23808:00-18:0000:00-00:009:269:390:13
STL-SAP1/4/2020Fri80054235711000097338J D'S QUICK STOP102224MCCSPADDEN, BRANDEN23808:00-18:0000:00-00:009:269:390:13
STL-SAP1/2/2020Thu80051079891000097504ALDI #34-POPLAR BLUFF1031924MCCSPADDEN, BRANDEN23806:00-11:0011:01-18:0020:0920:140:05
STL-SAP1/2/2020Thu80054016701000097822CASTELLO'S RESTAURANT104324MCCSPADDEN, BRANDEN23810:30-18:0000:00-00:009:449:540:09
STL-SAP1/2/2020Thu80051295121000136307RHODES 101 STOP #260105424MCCSPADDEN, BRANDEN23806:00-18:0000:00-00:009:5710:020:05

Please let me know if additional information is needed.
My list of customer numbers will change as well of the day of the week that I need but the source data will always be the same from this one sheet.
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

Forum statistics

Threads
1,136,445
Messages
5,675,900
Members
419,591
Latest member
mersanko

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
Top