Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default 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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 09:03 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"