create invoice from excel data

[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

 

[Tim]

Hello. That sounds like something that could be done in Microsoft Access. It
may be a little harder to set up, but once it is, you'll love it. Try using
access for this and use the wizards to help you. If you get stuck reply to
this post and let me know and I'll give you my MSN or AIM screen name so that
I can more easily help you.