I have made a template to preparea and take print of the Purchase requisitions. But I have struck at giving automatic numbering to these requisitios.
I wanted the running number to be this fashion: 2004/Dec/0001 . Basically I wanted excel to generate running number automatically whenever a new requisition is raised.
And I have made a form to which data gets picked by VLOOKUP to the format sheet from the data sheet, where in Key in the data.
Hope I have made the issue quite clear.
Any help would greatly be appreciated.