Ask Your Question
0

Auto sequential numbering [closed]

asked 2013-02-15 17:43:53 +0200

sl4grl gravatar image

Hello I am looking to create a Form spread sheet with a 5 digit sequential number that I can put onto our server that others can access and fill out. I am looking to create a Macro so that when the file is opened or saved or in some manner, that 5 digit sequential number will auto advance. Is there any thing out there like that available.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2015-10-22 11:21:33.216519

2 Answers

Sort by » oldest newest most voted
1

answered 2013-02-18 19:38:15 +0200

sl4grl gravatar image

I am looking for a single cell to have a sequential number that advances upon opening or saving. What I am attempting to do, is to create a Purchase order form that I can put onto our server. We have a dozen people whom generate Purchase orders. I have created an interactive form fill PDF file, but I can't get an auto advance sequential number to work with it. As of now we buy carbon Purchase order form books that are numbered. So alas, we get our number from this. Looking to do away with paper as much as possible so looking to do something digital without spending money on software. So, my attention turned towards generating some thing in LibreOffice using a Macro, if this is possible.

Thanks in Advance.

edit flag offensive delete link more
0

answered 2013-02-15 23:38:09 +0200

qubit gravatar image

Hi @sl4grl,

What sequential numbering do you want to increase? Are you looking for a new file to be created:

spreadsheet_00001.ods
spreadsheet_00002.ods
spreadsheet_00003.ods
...

Or do you want increasing numbering in a column in the spreadsheet?

Or something else?

edit flag offensive delete link more

Question Tools

Stats

Asked: 2013-02-15 17:43:53 +0200

Seen: 607 times

Last updated: Feb 18 '13