Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #41   Report Post  
Old January 16th 07, 10:07 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2007
Posts: 10
Default Auto Number in Invoice

For the good of the people on the site and the people trying to help, no one
should take offense to anyone that is making a contribution to the site and
its people. We are all here to try to learn , or to try to help those that
want to learn or that have a problem they are trying to solve. No one should
take offense to the people that are trying to help others. We are all here
for the better understanding and knowledge to be gained of the subject, so
its best if everyone work together as a whole for all to gain !!
--
lizard1socal


"Rookie 1st class" wrote:



  #42   Report Post  
Old January 19th 07, 01:05 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Aug 2006
Posts: 152
Default Auto Number in Invoice

liz if you think I was angry you were mistaken. Dave has saved my bacon to
many times to count. When Dave responds to any problem I alway read it. This
is my first time with J, he done good too. He had considerably more patience
with your inquiry than would have I. I would have asked you to begin a
separate thread even though you and Pammi had similar problems. I would only
have requested that because I am not capable of multi-tasking. I think both
you and Pammi would have been better served with your own thread. I think the
solution to both problems would also have easier to follow. My concern was
Pammi I didn't realize J was fixing her problem in addition to yours.
Lou

"lizard1socal" wrote:

For the good of the people on the site and the people trying to help, no one
should take offense to anyone that is making a contribution to the site and
its people. We are all here to try to learn , or to try to help those that
want to learn or that have a problem they are trying to solve. No one should
take offense to the people that are trying to help others. We are all here
for the better understanding and knowledge to be gained of the subject, so
its best if everyone work together as a whole for all to gain !!
--
lizard1socal


"Rookie 1st class" wrote:


  #43   Report Post  
Old January 19th 07, 01:36 AM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default Auto Number in Invoice

Thanks for the nice words.

The thing that scares me with this thread is that it's just too long (for me
anyway). There are so many branches and responses that I don't think I can
figure out what the problem is and what's been tried.

It think a lot of readers may think that, too.


Rookie 1st class wrote:

liz if you think I was angry you were mistaken. Dave has saved my bacon to
many times to count. When Dave responds to any problem I alway read it. This
is my first time with J, he done good too. He had considerably more patience
with your inquiry than would have I. I would have asked you to begin a
separate thread even though you and Pammi had similar problems. I would only
have requested that because I am not capable of multi-tasking. I think both
you and Pammi would have been better served with your own thread. I think the
solution to both problems would also have easier to follow. My concern was
Pammi I didn't realize J was fixing her problem in addition to yours.
Lou

"lizard1socal" wrote:

For the good of the people on the site and the people trying to help, no one
should take offense to anyone that is making a contribution to the site and
its people. We are all here to try to learn , or to try to help those that
want to learn or that have a problem they are trying to solve. No one should
take offense to the people that are trying to help others. We are all here
for the better understanding and knowledge to be gained of the subject, so
its best if everyone work together as a whole for all to gain !!
--
lizard1socal


"Rookie 1st class" wrote:



--

Dave Peterson
  #44   Report Post  
Old February 26th 07, 11:39 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 2
Default Auto Number in Invoice

I don't know if you've solved your problem yet. I do have a question though.
Do you post you invoices to an excel database workbook? If you do a very
simple formula can be entered into the cell where you want your invoice
numbers.

=if(cell="",MAX('C:\MyFiles\FolderName1\SubFolder\ NameofDatabase.xls'!INVOICE)+1,gotonext"

If you access your record again, the invoice number won't automatically
change. It also asks if you want to update your link. I went into my
database and inserted names for all of my data columns. This will always
insert the next invoice number available. It's much easier than the
solutions I read here so far. I've written some very complext formulas, and
sometimes the simplist is the best.

Good luck and I hope this will work for you.
"Pammi J" wrote:

Rookie 1st class
your solution does work but only if you open the same as last invoice - it
doesnt work off just the original template. which is a shame i thought we had
got it sorted then. I need to be able to open a clean invoice from template
each time (other than the incrementing invoice no) as i have to add customer
details to each one.
im going to have a play around with JLatham zip file now and will let you
know how i get on.

"JLatham" wrote:

Would you like me to go back through the method you were investigating and
check anything out? I suspect that the way you describe it as working may be
by intent - create a new file from the template, set up what ever individual
info is needed to get started, close it down and then next time you open it,
it starts incrementing? That kind of operation would be ok for a setup where
you were just printing the created invoice, filling in unique information
each time to print out a new one. The auto-incrementing of it on each open
would be troublesome if you were also trying to keep copies of the invoices
as part of your workbook.

"Rookie 1st class" wrote:

J, Liz & Pam My method works if not a template or you reopen the template
(negates purpose of template). You must open the document for it to add a 1.
Opening a copy (<File, <New) of a Template does NOT open the original
document. Therefore it never increments. I suspect that is also true of
McGimpsey link. Dave HELP!!!
Lou

"JLatham" wrote:

Grab the .zip file I uploaded for Pammi J he
http://www.microsoft.com/office/comm...c-bd3aeb241c30

that will give you one way to do it. You can change the reference to cell
E5 in the code to whatever cell on a worksheet you'd like the Invoice number
to show up in. By revising the InvoiceNumber.txt file, you can even set your
own starting number for your first invoice.

"lizard1socal" wrote:

JLantham or somebody..........
Could somebody ,anbody answer my last post , por favor? just want to know
how to auto number an invoice !!??
lizard1socal
--
lizard1socal





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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Trying to do a auto number generater EricHiew Excel Worksheet Functions 2 May 2nd 06 04:14 AM
Generate Auto Order Number cher Excel Discussion (Misc queries) 1 March 28th 06 06:15 PM
Auto Number horseman Excel Discussion (Misc queries) 2 November 24th 05 05:28 PM
Auto number invoices in Excel Fay Excel Worksheet Functions 1 September 12th 05 04:43 PM
assign auto number and auto date Krit Kasem Excel Discussion (Misc queries) 2 January 14th 05 03:55 AM


All times are GMT +1. The time now is 09:54 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017