Hi Community
I am Trying to hard with no result
I have a Data in excel which i am able to filter out and post it to a Table.
Now i have to filter that table to values in it and then send those filtered values as an attachment to email which i have in a separate sheet with one additional sheet (Buckets) with instructions.
Sheet Scan Compliance
Sheet DATA
Sheet Bucket List
i need Filtered data (Column C) from Scan Compliance to be in a new work book with filtered name + Scan Compliance and an aditional sheet that is Buckets to be send to filtered from DATA Sheet (DSP)
I am Trying to hard with no result
I have a Data in excel which i am able to filter out and post it to a Table.
Now i have to filter that table to values in it and then send those filtered values as an attachment to email which i have in a separate sheet with one additional sheet (Buckets) with instructions.
Sheet Scan Compliance
| Scan Compliance test.xlsm | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | |||
| 1 | tracking_id | operator_employee_id | DSP | station_code | delivery_date | distance_deviation | planned_lat | planned_long | delivery_lat | delivery_long | type_of_delivery | A | B | C | D | E | F | Comment | ||
| 2 | AT2104732798 | A3IANW22VRP3P3 | EGET | DAP5 | 6/24/2024 | 60.22256012 | 46.606257 | 13.832978 | 46.6063926 | 13.833741 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 3 | AT2104788535 | A3MJFM981QU0AD | EGET | DAP5 | 6/24/2024 | 52.73 | 46.62867 | 13.850387 | 46.6281975 | 13.8503301 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 4 | AT2105072539 | A1E97F7Y1UBS3U | RAPK | DAP5 | 6/25/2024 | 82.40 | 46.590259 | 14.272155 | 46.5908483 | 14.2728083 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 5 | AT2105357012 | A1RMRIKOVZPZ7I | RAPK | DAP5 | 6/27/2024 | 74.31 | 46.613065 | 14.295754 | 46.6124066 | 14.2955886 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 6 | AT2105558506 | AAB2W4SHY2UDU | RAPK | DAP5 | 6/28/2024 | 146.49 | 46.619816 | 14.301484 | 46.6198418 | 14.2995668 | DELIVERED_TO_MAIL_SLOT | |||||||||
| 7 | AT2105587360 | AAB2W4SHY2UDU | RAPK | DAP5 | 6/28/2024 | 97.34 | 46.621288 | 14.323329 | 46.6217677 | 14.3222632 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 8 | AT2105132898 | A1V8I9B8VAX9IA | RAPK | DAP5 | 6/26/2024 | 78.15 | 46.623938 | 14.27728 | 46.6242848 | 14.2763902 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 9 | AT2104985292 | A389GE1EPAKOU7 | RAPK | DAP5 | 6/26/2024 | 63.44 | 46.631664 | 14.330974 | 46.63209 | 14.3304217 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 10 | AT2105277819 | AAB2W4SHY2UDU | RAPK | DAP5 | 6/26/2024 | 74.69 | 46.61861 | 14.336148 | 46.618186 | 14.3369062 | DELIVERED_TO_SAFE_LOCATION | |||||||||
| 11 | AT2104645470 | A1BSJJJCDA4PC3 | SAYX | DAP5 | 6/24/2024 | 53.47 | 46.759934 | 14.357684 | 46.7601704 | 14.3570729 | DELIVERED_TO_SAFE_LOCATION | |||||||||
| 12 | AT2104664010 | A16UO6F0YUQJJ1 | SAYX | DAP5 | 6/24/2024 | 53.27 | 46.877098 | 14.463369 | 46.8767055 | 14.4637704 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 13 | AT2105066631 | A33ZVZMP35CHFF | EGET | DAP5 | 6/25/2024 | 82.53 | 46.608892 | 14.042222 | 46.608525 | 14.0412833 | DELIVERED_TO_SAFE_LOCATION | |||||||||
| 14 | AT2105602703 | A3TO8Q0IPA238O | SAYX | DAP5 | 6/28/2024 | 52.23 | 46.876378 | 14.516992 | 46.8766428 | 14.5175593 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 15 | AT2105601081 | A239E201D5P0LJ | RAPK | DAP5 | 6/28/2024 | 54.26 | 46.597317 | 14.277173 | 46.5974049 | 14.2764747 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 16 | AT2105592871 | A3KNDCRZCCD41J | RAPK | DAP5 | 6/28/2024 | 64.00 | 46.629058 | 14.343813 | 46.6295749 | 14.3441812 | DELIVERED_TO_SAFE_LOCATION | |||||||||
| 17 | AT2105762624 | A3TO8Q0IPA238O | SAYX | DAP5 | 6/29/2024 | 80.00 | 46.809317 | 14.562239 | 46.8095255 | 14.5632447 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 18 | AT2104816104 | A3APNOHI6MQG68 | RAPK | DAP5 | 6/25/2024 | 80.37 | 46.6214 | 14.267283 | 46.6212632 | 14.26625 | DELIVERED_TO_SAFE_LOCATION | |||||||||
| 19 | AT2104757045 | A17Y6NDRYXQPFN | RAPK | DAP5 | 6/25/2024 | 62.55 | 46.594839 | 14.040296 | 46.5953509 | 14.0406349 | DELIVERED_TO_SAFE_LOCATION | |||||||||
| 20 | AT2105078003 | A3APNOHI6MQG68 | RAPK | DAP5 | 6/25/2024 | 59.81 | 46.622461 | 14.272047 | 46.6223959 | 14.2712698 | DELIVERED_TO_SAFE_LOCATION | |||||||||
| 21 | AT2105428811 | AAB2W4SHY2UDU | RAPK | DAP5 | 6/27/2024 | 92.23 | 46.618107 | 14.309708 | 46.6183276 | 14.3108717 | DELIVERED_TO_SAFE_LOCATION | |||||||||
| 22 | AT2105690490 | A389GE1EPAKOU7 | RAPK | DAP5 | 6/28/2024 | 209.34 | 46.620339 | 14.334122 | 46.6207265 | 14.3368036 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 23 | AT2105791330 | AAB2W4SHY2UDU | RAPK | DAP5 | 6/29/2024 | 58.44 | 46.624335 | 14.326904 | 46.6248457 | 14.3270837 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 24 | AT2105624774 | A2HCHOXWTNUQR | EGET | DAP5 | 6/29/2024 | 90.09 | 46.723328 | 14.110048 | 46.7228584 | 14.1090853 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 25 | AT2104483926 | A3T3DYZVB9M5EG | RAPK | DAP5 | 6/24/2024 | 56.94 | 46.620655 | 14.289804 | 46.6208453 | 14.2891121 | DELIVERED_TO_HOUSEHOLD_MEMBER | |||||||||
| 26 | AT2104392128 | A35D4SJSB3JE5F | EGET | DAP5 | 6/24/2024 | 137.58 | 46.761887 | 14.29783 | 46.7629867 | 14.2986567 | DELIVERED_TO_MAIL_SLOT | |||||||||
ScanCompliance | ||||||||||||||||||||
| Cells with Conditional Formatting | ||||
|---|---|---|---|---|
| Cell | Condition | Cell Format | Stop If True | |
| F2:F651 | Cell Value | >RUN!$L$9 | text | NO |
| F1 | Cell Value | >50 | text | NO |
Sheet DATA
| Scan Compliance test.xlsm | |||||
|---|---|---|---|---|---|
| A | B | C | |||
| 1 | DSP Full Name | DSP Short Code | Email Adress | ||
| 2 | AllMunA Transportlogistik GmbH | AMTP | Dap5-dispatcher@allmuna. at; | ||
| 3 | EGES LOGISTICS GMBH | EGET | dap5.dispatcher@egeslogistics.at; sefa.yilmaz@egeslogistics.at; | ||
| 4 | Raketi Paketi Gmbh | RAPK | martin.koinig@wellpack.org; moisa.andrei@deligee.at; cernea.gheorghe@raketi.at | ||
| 5 | SAY Express GmbH | SAYX | dispatcher@sayexpress.at; kamran.butt@sayexpress.at; bianca.schneeberger01@sayexpress.at; | ||
DATA | |||||
Sheet Bucket List
| Scan Compliance test.xlsm | ||||
|---|---|---|---|---|
| A | B | |||
| 1 | Buckets | Identity | ||
| 2 | Swipe-To-Finish scans at incorrect locations | A | ||
| 3 | Device issues, Rabbit Issues, GPS issues, etc | B | ||
| 4 | Incorrect planned Geocodes | C | ||
| 5 | Customer Redirects | D | ||
| 6 | Complex / Large building address | E | ||
| 7 | Others | F | ||
Buckets | ||||
i need Filtered data (Column C) from Scan Compliance to be in a new work book with filtered name + Scan Compliance and an aditional sheet that is Buckets to be send to filtered from DATA Sheet (DSP)
