I have a master list of customers/potentials that I sort by date of next
visit and I would like to be able to break them down further, for use
with streets and trips.

So, here's what I would like to do.

Take all entries that are within 6 days of the current date and reflect
them on their corresponding worksheet (Worksheets being Master, Monday,
Tuesday, Wednesday...etc).

So, I would like to still be able to see them on my master sheet, but if
the date of next visit falls with 6 days from now, they are reflected on
the worksheet day they belong to (Monday-Friday)

That came out a little jumbled, but I think I got my point accross.

Thx,

A