ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keeping record of clients and job numbers per bill? (https://www.excelbanter.com/excel-discussion-misc-queries/110386-keeping-record-clients-job-numbers-per-bill.html)

Chhaya

Keeping record of clients and job numbers per bill?
 
I want to make bills and also want to track them by job numbers and clients
name. How do i segregate them? Is there a way to add the new job numbers and
dates automatically?
Thanks in advance.
Chhaya Singh.

JLatham

Keeping record of clients and job numbers per bill?
 
You could look through the available Excel templates he
http://office.microsoft.com/en-us/te...356681033.aspx
and see if any would work for you. Look for ones dealing with INVOICING or
INVOICE - as that's what a bill is usually called in the business world.

If you decide to go custom, yes, automatic assigning of dates and numbers is
available, usually through a little VBA coding of a macro or two.

The tracking by job numbers and clients actually could be better done by
setting things up in a small database such as Microsoft Access.

"Chhaya" wrote:

I want to make bills and also want to track them by job numbers and clients
name. How do i segregate them? Is there a way to add the new job numbers and
dates automatically?
Thanks in advance.
Chhaya Singh.



All times are GMT +1. The time now is 03:27 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com