[greeneg]

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!

[etaf]

what cells are you wanting to change
do you mean excel - as the title says word?

[greeneg]

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]

i have changed the title for you

[etaf]

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]

That should work - but what do I do with the code? Where do I paste it or whatever. Thanks very much!

[etaf]

http://www.excelforum.com/excel-gene...xcel-file.html
should help

[greeneg]

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]

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]

i think this is still for windows
http://office.microsoft.com/en-us/ex...010342313.aspx
as it mentions cntrl R

[etaf]

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/