Dear Sunny,
I have a series PO data with sub item in the list. Example PO A with sub item 1,2,3. In the line sub item #2 and #3, it has no PO number PO A. I would like to adding the PO number PO A at the sub item #2 and #3.
So in the end the list would be, PO A with sub item 1,
PO A with sub item 2,
PO A with sub item 3.
Please see PO number 004/1/2018/MKM-PO in the attachment, in the sheet "Pembelian 2018 BEFORE" and in the sheet "Pembelian 2018 AFTER"
Thank you and regards,
Chandra
Hi Chandra
OK so you want to repeat the Date, Supplier's Name and PO number.
Attached is the macro (ReptPONo) that will do the job.
You will need to select the correct worksheet before running the macro.
Please test it on a sample file first.
Hope this helps.
Sunny
Thanks Sunny,
it works! Amazing.
Best regards,
Chandra
You are welcome.
Sunny