P
PC
Hi all,
I am relatively new to using excel but a fast Learner I hope.
I am secreatry of a semi vol local water supply group for about 450
customers and filling out the bi monthly invoices is rather tedious and
time consuming to say the least .
I want to calculate the following data and create an invoice for each
customer.
Name, Address, Bank Account No, Prevous Units, Present Units , Units Used ,
Cost Per unit, Free units, Total Cost ( ie units less free units * ?3.50) -
Thats the easy bit
But I want this information to be easilt transferred to an invoice which
includes the bank account and perhaps a balance owed ???
Is this complicated
Would I be safer getting another package to do it ?
Any help would be really appreciated
PC
I am relatively new to using excel but a fast Learner I hope.
I am secreatry of a semi vol local water supply group for about 450
customers and filling out the bi monthly invoices is rather tedious and
time consuming to say the least .
I want to calculate the following data and create an invoice for each
customer.
Name, Address, Bank Account No, Prevous Units, Present Units , Units Used ,
Cost Per unit, Free units, Total Cost ( ie units less free units * ?3.50) -
Thats the easy bit
But I want this information to be easilt transferred to an invoice which
includes the bank account and perhaps a balance owed ???
Is this complicated
Would I be safer getting another package to do it ?
Any help would be really appreciated
PC