Advertisement

There's no such thing as a stupid question, but they're the easiest to answer.
Login
Search

Advertisement

Business Applications Business Applications
Search Search
Search for:
Tech Support Guy > > >

Create sequential invoice numbers in Excel for Mac 2011


(!)

greeneg's Avatar
greeneg greeneg is offline
Member with 5 posts.
THREAD STARTER
 
Join Date: Jul 2012
21-Jul-2012, 08:12 AM #1
Create sequential invoice numbers in Excel for Mac 2011
Hi!

I need to create an Excel spreadsheet for invoices. I'd like the original to be Invoice 000001. Then, each time I open the sheet, I'd like it to increment +1, i.e., the first time I open the original, it becomes Invoice 000002, and so on.

I've been several hours now searching, and either nothing quite seems to fit, or it;s too advanced for me. I have zero macro experience, SEQ experience, etc., so if you have some thoughts, I would TRULYt appreciate it if you supplied them as though you were talking to your Labrador Retriever! :-)

I know this is a matter of some fairly rudimentary code, but issues like where the code gets pasted, etc., are stumping me so far.

Thanks for any and all help!

Last edited by etaf; 21-Jul-2012 at 08:58 AM..
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 53,060 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
21-Jul-2012, 08:45 AM #2
what cells are you wanting to change
do you mean excel - as the title says word?
greeneg's Avatar
greeneg greeneg is offline
Member with 5 posts.
THREAD STARTER
 
Join Date: Jul 2012
21-Jul-2012, 08:51 AM #3
Ooops!

Title should have said Excel.

I need to change just one cell. In other words, in the template there will be one cell with the invoice number in it. Each time I open the sheet I want that number to add +1.

So let's say cell A1, invoice number, has the value 000001 and I create a customer invoice The next time I open the template, I want A1 to read 000002, and I'll create and save another invoice. The time after that, the value when I open the template would be 000003, and so on.

Thanks !
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 53,060 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
21-Jul-2012, 08:58 AM #4
i have changed the title for you
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 53,060 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
21-Jul-2012, 09:02 AM #5
Code:
Private Sub Workbook_Open() 
    Sheets("Sheet1").Range("A1").Value = Sheets("Sheet1").Range("A1").Value + 1 
End Sub
BUT if you open and do not use then save - next time it will increment - so not all invoice numbers maybe used
greeneg's Avatar
greeneg greeneg is offline
Member with 5 posts.
THREAD STARTER
 
Join Date: Jul 2012
21-Jul-2012, 09:40 AM #6
That should work - but what do I do with the code? Where do I paste it or whatever. Thanks very much!
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 53,060 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
21-Jul-2012, 09:45 AM #7
greeneg's Avatar
greeneg greeneg is offline
Member with 5 posts.
THREAD STARTER
 
Join Date: Jul 2012
21-Jul-2012, 09:52 AM #8
Thanks again - but that file dates to 2005 and is for windows. I'm on a Mac, Excel 2011. So for example, the first step is press Alt-F11. There's no such command in Excel Mac 2011.

I'm stumped - I've been to Office Support, but that tells you how to record a macro, not how to insert one. On the one hand, I'm not a complete idiot, but on the other, this whole process seems unnecessarily complicated, not unusual for MS software.

That said, if you could hold my hand a bit longer, or point me to a more contemporary help file aimed at a Mac user, I would truly appreciate it!

G
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 53,060 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
21-Jul-2012, 09:54 AM #9
sorry about that - you did say Mac in title my mistake

I dont have or use a mac - so will have a search on google and see if i can find something that makes sense
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 53,060 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
21-Jul-2012, 10:17 AM #10
i think this is still for windows
http://office.microsoft.com/en-us/ex...010342313.aspx
as it mentions cntrl R
etaf's Avatar
etaf   (Wayne) etaf is offline
Computer Specs
Moderator with 53,060 posts.
 
Join Date: Oct 2003
Location: Surrey, UK
21-Jul-2012, 10:22 AM #11
Microsoft’s Excel 2011 team has also worked to make Mac macros compatible with those written for Excel for Windows. According to Microsoft, Excel 2011 for Mac features a full port of the Windows Office VBA environment; in most cases, the OS X and Windows versions of VBA now mirror each other

have a look at
The VBA Editor – A Quick Look
here
http://excelsemipro.com/2010/11/exce...ences-and-vba/
__________________
Wayne
Please let us know what the final solution was to any problem posted
As Seen On

BBC, Reader's Digest, PC Magazine, Today Show, Money Magazine
WELCOME TO TECH SUPPORT GUY!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.


(clock)
THIS THREAD HAS EXPIRED.
Are you having the same problem? We have volunteers ready to answer your question, but first you'll have to join for free. Need help getting started? Check out our Welcome Guide.

Search Tech Support Guy

Find the solution to your
computer problem!




Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools


WELCOME
You Are Using: Server ID
Trusted Website Back to the Top ↑

Content Relevant URLs by vBSEO 3.3.2