EXCEL PO generator

[rakesh14246]

hi all,
I am creating a PO generator and excel I need support.

1. I want to generate PO number in the format as ex: companyname/projectdescription/Projectcode/SLNO like ABDC/CSM/AA456/001.
here variable is project code , projectdescription,SLno.
this PO number has to trace the last PO number from the PO tracking sheet and generate new PO SL No for the particular Project.

 

[Logit]

.
Sounds like VLOOKUP and CONCATENATE are in order.

Someone would be more likely to assist if you posted a copy of your workbook for download. You can use DROPBOX or similar to post the file.

 

[rakesh14246]

thank you
how to upload file.

 

[Logit]

This Forum doesn't have a means of uploading a file.

Search for "cloud sites".. Some folks use DropBox ... I use Amazon Cloud ... I understand Google has a means of uploading files. All of these sites and more
will permit you to upload a file and other folks can then download it. The cloud site will provide you with a link that you can post here so folks can be guided to
your file.