Home

Value to change when opening a new file.

pshank
Occasional Visitor

When opening a new excel document, in the same file, I want the numbers to change to the next sequence. If its a work order number, I want the next time it is opened to go to the next consecutive number. I need a cell or sheet tab to say WO#500000, then the next time a new file is opened, I need that number to change to WO#500001.

 

Sorry for any confusion. I may have posted this once. but I cant find the question any where.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies