Need to be able to:
1) Allow for a prompt so can navigate to a text file within the text
import wizard
2) Filter the list of dates to remove weekends from the list after the
import has taken place
3) Set up a dynamic (each time this is ran there will be more entries
so this can't be limited to a range) pivot table to group each week
together and provide the Max figure of the number field for that week.


Mini sample of data
Client Date Time Number
888 06/01/2004 11:23:29 381
888 06/01/2004 12:23:29 1
888 07/01/2004 03:23:30 5
888 07/01/2004 04:23:29 6
888 08/01/2004 22:23:29 6
888 08/01/2004 23:23:30 9
888 09/01/2004 00:23:30 7
888 09/01/2004 01:23:30 7
888 15/01/2004 12:23:30 273
888 15/01/2004 13:23:30 225
888 15/01/2004 14:23:30 285
888 15/01/2004 15:23:30 261

Any help on this would be really appreciated - Many Thanks, Al (
)