LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
John
 
Posts: n/a
Default incrementing account numbers

Hi,

I'm having a lot of issues here understanding how to use a the macro's with
an Excel 2003 workbook.

The scenario is to create an invoice and each must have a different invoice
number which will be incremented by 1 each time I use the workbook. I'll
actually want to save-as the workbook to a new one per invoice.

I spent the afternoon reading threads and trying out various macro's and got
myself totally lost. In the end I deleated the workbook which had about 10
different macro's in it. I'd like to just start all over from scratch. The
invoice itself isn't complicated and can be drawn up in 10 minutes, it is
just increasing the invoice number that I have trouble with.

I'd like to know why MS didn't just include this.. it has everything else.
 
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
Match Last Occurrence of two numbers and Return Date Sam via OfficeKB.com Excel Worksheet Functions 6 April 5th 05 12:40 PM
Match Last Occurrence of two numbers and Count to Previous Occurence Sam via OfficeKB.com Excel Worksheet Functions 33 April 4th 05 02:17 PM
Count and Sum Total occurrances of two specific numbers Sam via OfficeKB.com Excel Worksheet Functions 10 March 29th 05 08:13 PM
How do I delete 100 account numbers from a spreadsheet colume wer. Ndubuisi Azuogu Excel Worksheet Functions 2 November 11th 04 04:11 PM
How do I setup a list box that has several account numbers so use. Jackie Excel Worksheet Functions 1 November 8th 04 07:03 PM


All times are GMT +1. The time now is 07:46 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"