Thread: LOOP query
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default LOOP query

See

http://www.mcgimpsey.com/excel/sequentialnums.html

In article ,
Pedro AM wrote:

Hi
I have an issue with regards a function which I believe may be LOOP.
I have an invoice in Excel and I would like the invoice number to increase
by 1 everytime I press a button.
How do I do this?
and then, can I also make it copy into a list details like invoice number,
who to and amount before updating the invoice number, all in one macro
perhaps???

Any help on this would be great , thanks.