Hi all,
I am looking to set up a new PO system on excel. There is a column on the spreadsheet for Yes/No/Blank if the PO's on individual lines have been approved (I have protected this column on the spreadsheet for when this process is in place). My question is twofold,
1. Is it possible to get excel to generate a sequential PO number based on when the column mentioned above is yes? As at the moment its ordering sequentially even when some PO's are not approved. I have highlighted this in the attachment.
2. Based on this is it possible to create a macro to automatically populate the data from this excel once it is approved and has a P.O number into an excel P.O template already used in the business also attached?
Thanks
R
Bookmarks