Auto incrementing PO number

Here is my spreadsheet...at least I hope it's attached

Ok, I've looked at the spreadsheet and the code....it's one of the codes I've used previously, but I've never seen the save button on the spreadsheet. Sorry to be thick, but what do I do with it? Do I click on the save button if I want to save a purchase order, or do I still go through save as? I just want to try it out several times before I get excited

I've tried saving the spreadsheet and the PO number changes the second I click on "save as"..is that supposed to happen? Also, the template number is still the original number, everytime I open it, it is showing as 7023, never changes when I open it?

I'm really sorry, I'm obviously doing something wrong because it's still incrementing the PO number when I click on "save as"? Could you give me a step by step to see what I'm doing wrong? I notice in your VB code it says "saveas" in the first line...is that why it's incrementing upon clicking the "save as" button? Can I have it so it increments upon closing or something? I'm really sorry for being so difficult, but I really don't get VB at all.

so do I put that code into the VB thisworkbook spot, same as I have been or is it a macro..I just notice it says submacro and am a bit confused? sorry again. getting really embarrassed now

I've done the run macro thing and it's come up with an error message straight away saying: Run time error '9' Subscript out of range? What does that mean. It gives me the option to debug. But problems in the past that I've tried the debug has not worked, so again, don't know if I'm doing it right?

Also, I notice that you told me to put the code in the module, whereas in the past I've always been putting the code into the ThisWorkbook part. What is the difference between the two?

ok I've tried again and I've gotten another error message, when I go to debug it's highlighted this part of the code:

Please Login or Register  to view this content.

(I hope I did the code tag properly...first time I've had to do it)

what does that part of the error mean?

Also, you've said

have added a Named Range for the PO number, which needs adding to your workbook

what does that mean?

ok, I think I named the cell I want the PO number to be in. I went to insert - name - define - and it came up automatically with Purchase_Order_Number, so I clicked the add button and then I got the same error message as before. So I've obviously done something wrong...what else can I do please? Really sorry to be such a pain, but I really want to understand this, I just don't.

I have changed both of the parts in the code to show Purchase_Order_Number, but it still had an error message come up showing this line as wrong

Please Login or Register  to view this content.

I then changed the first "PoNum" also to "Purchase_Order_Number", but that still showed as wrong. Still really not sure why it's not working for me, but it works for everyone else. I'm following the directions given to me and it still doesn't work...user error I know, but I really don't get what I'm doing wrong? Maybe I should just give up on this idea of having the number auto increment...if it's this difficult and not working. I don't know that I should waste anymore time trying to do it.

I have changed it to this:

Please Login or Register  to view this content.

and it still doesn't work, I still get the error message and when I go into debug, that line still shows up as highlighted

I see what's happening now! I think I had old VB code in the "ThisWorkbook" section first of all. Second, I didn't realise that to increment the number on the spreadsheet I needed to run the macro after each time I saved a spreadsheet under a different name. I think it's finally working for me now. Thank you so much. I think the light finally came on above my head you're so thanks again...especially for being patient with me. Will definitely come back here for all my excel questions in the future.