Shared Workbook VBA to replace pivot table sort rows by date function

[Marcor]

Hello Everyone,

I spent the better part of a week developing an extensive excel files that has a display fed by an entry pivot table on the first sheet.

It worked great, until I attempted to Share the Work book, so multiple users can edit it at the same time, and use the advanced features to refresh the information for the display.


Can someone help me understand if it is possible for a VBA to filter rows of data by Due Date (column C for example), in intervals that simulate real time updates. ie. every 5 minutes.

So for example: From the information below, if I add some content that has a due date of 1/12/2016, it will move the entire row to the top after 5 minutes.

[TABLE="width: 723"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Bar code[/TD]
[TD]Date Given[/TD]
[TD]Date Due[/TD]
[TD]Processor[/TD]
[TD]Date Started[/TD]
[TD]Date Completed[/TD]
[TD]Book Type[/TD]
[TD]Days Till[/TD]
[/TR]
[TR]
[TD]ac-1234004[/TD]
[TD="align: right"]12/26/2015[/TD]
[TD="align: right"]1/13/2016[/TD]
[TD]TJ[/TD]
[TD="align: right"]12/28/15[/TD]
[TD="align: right"]1/12/2016[/TD]
[TD]Horror[/TD]
[TD="align: right"]-21[/TD]
[/TR]
[TR]
[TD]ac-1234003[/TD]
[TD="align: right"]12/27/2015[/TD]
[TD="align: right"]1/14/2016[/TD]
[TD]TJ[/TD]
[TD="align: right"]12/29/15[/TD]
[TD="align: right"]1/13/2016[/TD]
[TD]Adventure[/TD]
[TD="align: right"]-20[/TD]
[/TR]
[TR]
[TD]ac-1234002[/TD]
[TD="align: right"]12/28/2015[/TD]
[TD="align: right"]1/15/2016[/TD]
[TD]TJ[/TD]
[TD="align: right"]12/30/15[/TD]
[TD="align: right"]1/14/2016[/TD]
[TD]Horror[/TD]
[TD="align: right"]-19[/TD]
[/TR]
[TR]
[TD]ac-1234005[/TD]
[TD="align: right"]1/1/2016[/TD]
[TD="align: right"]1/22/2016[/TD]
[TD]Dave[/TD]
[TD="align: right"]1/6/16[/TD]
[TD="align: right"]1/21/2016[/TD]
[TD]Fiction[/TD]
[TD="align: right"]-12[/TD]
[/TR]
[TR]
[TD]ac-1234006[/TD]
[TD="align: right"]1/2/2016[/TD]
[TD="align: right"]1/23/2016[/TD]
[TD]TJ[/TD]
[TD="align: right"]1/7/16[/TD]
[TD="align: right"]1/23/2016[/TD]
[TD]Romance[/TD]
[TD="align: right"]-11[/TD]
[/TR]
[TR]
[TD]ac-1234007[/TD]
[TD="align: right"]1/3/2016[/TD]
[TD="align: right"]1/24/2016[/TD]
[TD]Dave[/TD]
[TD="align: right"]1/8/16[/TD]
[TD="align: right"]1/23/2016[/TD]
[TD]Non-Fiction[/TD]
[TD="align: right"]-10[/TD]
[/TR]
[TR]
[TD]ac-1234008[/TD]
[TD="align: right"]1/4/2016[/TD]
[TD="align: right"]1/25/2016[/TD]
[TD]Jeff[/TD]
[TD="align: right"]1/9/16[/TD]
[TD="align: right"]1/25/2016[/TD]
[TD]Adventure[/TD]
[TD="align: right"]-9[/TD]
[/TR]
[TR]
[TD]ac-1234009[/TD]
[TD="align: right"]1/5/2016[/TD]
[TD="align: right"]1/26/2016[/TD]
[TD]Jeff[/TD]
[TD="align: right"]1/10/16[/TD]
[TD="align: right"]1/27/2016[/TD]
[TD]Horror[/TD]
[TD="align: right"]-8[/TD]
[/TR]
[TR]
[TD]Ab-1234005[/TD]
[TD="align: right"]1/25/2016[/TD]
[TD="align: right"]2/4/2016[/TD]
[TD]TJ[/TD]
[TD="align: right"]1/27/2016[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Ab-1234006[/TD]
[TD="align: right"]1/26/2016[/TD]
[TD="align: right"]2/4/2016[/TD]
[TD]TJ[/TD]
[TD="align: right"]1/27/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD]Ab-1234007[/TD]
[TD="align: right"]1/27/2016[/TD]
[TD="align: right"]2/6/2016[/TD]
[TD]Jeff[/TD]
[TD="align: right"]1/27/2016[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD]Ab-1234008[/TD]
[TD="align: right"]1/28/2016[/TD]
[TD="align: right"]2/7/2016[/TD]
[TD]Dave[/TD]
[TD="align: right"]1/29/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Ab-1234009[/TD]
[TD="align: right"]1/29/2016[/TD]
[TD="align: right"]2/7/2016[/TD]
[TD]Jeff[/TD]
[TD="align: right"]1/29/2016[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Ab-1234010[/TD]
[TD="align: right"]1/30/2016[/TD]
[TD="align: right"]2/7/2016[/TD]
[TD]Jeff[/TD]
[TD="align: right"]1/31/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD]Ab-1234011[/TD]
[TD="align: right"]1/31/2016[/TD]
[TD="align: right"]2/8/2016[/TD]
[TD]Jeff[/TD]
[TD="align: right"]1/31/2016[/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]5[/TD]
[/TR]
[TR]
[TD]Ab-1234012[/TD]
[TD="align: right"]2/1/2016[/TD]
[TD="align: right"]2/9/2016[/TD]
[TD]Jeff[/TD]
[TD="align: right"]2/1/2016[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD]ab-1234001[/TD]
[TD="align: right"]2/1/2016[/TD]
[TD="align: right"]2/14/2016[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]11[/TD]
[/TR]
</tbody>[/TABLE]


Thank you in advance for any advice and help in the matter

 

[Marcor]

Didn't find out how to have an auto sort in a shared work book, but made due with manual intervention. Built into process for operator to manually sort by due date before saving.