Auto-Number for PO spreadsheet

Hi All

I have just set up a new Purchase Order spreadsheet for work, but am struggling with the auto-numbering.

I want the PO numbers to been in the format of 2016001, 2016002, 2016003 (as shown), and to show the newest at the top/.

I want to be able to press the 'new po number' button, and a new blank row appear (in Row 4).

I've attached a quick screenshot for you.

Would be grateful for any assistance.

Thanks

SarahPO.png

Try this:-

Please Login or Register  to view this content.

Try this:-
Right click sheet tab, Select "View Code", Vbwindow appears, Past code in window, Close Vb window
Code runs when you click "A4"

Please Login or Register  to view this content.

Hi All

All works great, except that it copies the format of the row above, where the row colour is yellow :s

Perhaps this:-

Please Login or Register  to view this content.

Change line as below:-

Please Login or Register  to view this content.