Hello,
I have a pivot of info (as below). I have a master copy which i save every week by week number and dump in data from an external source. I want to filter "Time Into Loading" and "Time Finished Loading" so that it filters out and blank cells, however when new data is entered into the data source I have to re filter to include the new dates/times.
Is there a way to make the filter always include everything except for blanks?
Hope someone can assist.
Stephen
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I have a pivot of info (as below). I have a master copy which i save every week by week number and dump in data from an external source. I want to filter "Time Into Loading" and "Time Finished Loading" so that it filters out and blank cells, however when new data is entered into the data source I have to re filter to include the new dates/times.
Is there a way to make the filter always include everything except for blanks?
Hope someone can assist.
Stephen
Day of the week | Allocated Time | Load Ref | Time Into Loading | Time Finished Loading | Loading Time |
Monday | 12/03/2018 07:00 | 72700 | 12/03/2018 07:39 | 12/03/2018 08:58 | 01:19:00 |
Monday | 12/03/2018 07:00 | 72691 | 09/03/2018 17:49 | 12/03/2018 08:57 | 15:08:00 |
Monday | 12/03/2018 08:00 | 72678 | 12/03/2018 08:27 | 12/03/2018 10:09 | 01:42:00 |
Monday | 12/03/2018 09:00 | 72979 | 12/03/2018 12:13 | 12/03/2018 13:49 | 01:36:00 |
Monday | 12/03/2018 10:00 | 72845 | 12/03/2018 09:48 | 12/03/2018 13:50 | 04:02:00 |
Monday | 12/03/2018 11:00 | 72643 | 12/03/2018 13:32 | 12/03/2018 14:49 | 01:17:00 |
Monday | 12/03/2018 11:00 | 72644 | 12/03/2018 13:33 | 12/03/2018 14:44 | 01:11:00 |
Monday | 12/03/2018 12:00 | 73032 | 12/03/2018 12:23 | 12/03/2018 13:13 | 00:50:00 |
Monday | 12/03/2018 12:00 | 72645 | 12/03/2018 13:33 | 12/03/2018 15:43 | 02:10:00 |
Monday | 12/03/2018 13:00 | 72959 | 12/03/2018 14:11 | 12/03/2018 15:42 | 01:31:00 |
<colgroup><col><col><col><col><col><col></colgroup><tbody>
</tbody>