Automatically Increment Numbers Between Worksheets

[shawnashawna]

Howdy!
I have a workbook, which will have many identical worksheets. Say my first worksheet (tab) is titled 0001, and the document is also number 0001 (cell J2), how can I have both the tab name and cell J2 update together, upon copying tab 0001, to number 0002?

Thank you in advance, help is appreciated!

Shawna

[Hurricanefly]

Hi, sounds like a simple macro but, if you post an example of results expected then it would be easier to know exactly what you are after

[wenqq3]

Update Tab only when cell value change. VBA code

Please Login or Register  to view this content.

Update Cell only when tab value change.

Please Login or Register  to view this content.

[shawnashawna]

I feel so foolish, but I can't figure out how to attach an example??
The FAQ said to find the "browse" button, and attach my file from there, but I am not seeing a browse option?

[shawnashawna]

Oh, I got it..... wenqq3, your second option is great. Thank you both, very much!!

[wenqq3]

Your are welcome. Thanks for feedback.

FYI
Post a WORKBOOK.
To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), (Add Files) browse to the required file, and then push the Upload button.