Basic excel template help

[floorcrete1]

Hey, i am making a excel PO forum for my company.

i've created a basic template, but was struggling with a few things.
I want to set it up like quick books, where after you log a po ( either saving it or opening a new tab),
a new template appears with the locked info (date, name, ect. cells) but i want the PO to automatically generate in a numerical order.

is this possible?

( i guess if thats confusing. i need help setting up a template that with every tab the same "po page" appears, and the PO number generates on its own)

Thanks. if that wasnt to confusing

( ps im a total novice at excel / computers so be gentle please)

[floorcrete1]

any help? or is this unfeasible ?

[trisoldee]

You said your pretty novice, are you at all familiar with macros? As long as the template format doesn't change this should work. This is assuming labels are in column A and the data is entered in column B(all of which to be changed based on however your template is set up), B1 would be your PO number. I would assign it to a big button with text something along the lines of "Save & New". Make sure it's saved as an xlsm file.

Sub Macro1()
'
' Macro1 Macro
' Public Sub AddOne()

'
    Application.Dialogs(xlDialogSaveAs).Show
    ActiveWorkbook.ActiveSheet.Copy After:=Sheets(1)
    Range("B2:B4").Select
    Range("B1").Activate
    Selection.ClearContents
    Range("B1").Value = Range("B1") + 1
End Sub

[floorcrete1]

ok thank you i will try it out!

[Fotis1991]

Welcome to the forum. Pls take some minutes to read forum rules, because:

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)