Flash Wrote:
-------------------------------------------------------
> I keep my color coding to a minimum. I have
> upcoming shops down the sheet a ways and as they
> get performed they get cut and pasted into the top
> of the sheet in sequence in which performed.
> Details get filled in at that time such as
> mileage, actual reimbursement amount to expect,
> etc. When paid they get a blue highlight along
> with the date and amount paid. When the shops are
> all blued out that means the month is full paid
> and the sheet can get moved to the back of the
> workbook.
>
> In the shops not yet performed, minimal details of
> a shop applied for go in and are highlighted in
> orange until assigned, at which time full details
> are put in. If not assigned or I withdraw my
> application, the line just gets deleted.
I use the custom sort feature and sort by the due date so my current shops stay on top.