P
paulAPS
I have a pool service business and I have customers that I have monthly
contracts with.
I need to keep track of several things:
--When their payments are due
I was thinking of making an excel worksheet and creating a script to turn
the cell of the customer to a different color when their payment is within a
certain number of days from the due date.
--Each customers equipment, pool size, and other static data
--Weekly chart to record water chemistry, pressures, etc
Not sure whether I could do this all in excel or whether a combination of
excel and access. Also, if I do use a combo, is there a way to link the
information between the two programs?
Thanks
contracts with.
I need to keep track of several things:
--When their payments are due
I was thinking of making an excel worksheet and creating a script to turn
the cell of the customer to a different color when their payment is within a
certain number of days from the due date.
--Each customers equipment, pool size, and other static data
--Weekly chart to record water chemistry, pressures, etc
Not sure whether I could do this all in excel or whether a combination of
excel and access. Also, if I do use a combo, is there a way to link the
information between the two programs?
Thanks