Transaction Number

[openofficeexcel]

I need help on populating excel cells as well.
However, my situation is a bit different.
I am designing a spreadsheet that requires transaction numbers.

Example)
Every time I click the New Trans button , the transaction number should increase by 1.
Reply With Quote

[VBA Noob]

See if link helps

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

VBA Noob

[royUK]

It depends on where the transaction numbedrs are, but you can use the MAx Function to get the next transaction number by adding 1 to the result, assuming they are stored in a column.