Forum

Notifications
Clear all

Adding the Purchase Order number for the sub item

4 Posts
2 Users
0 Reactions
51 Views
(@chandra_polimyahoo-co-id)
Posts: 5
Active Member
Topic starter
 

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

 
Posted : 15/01/2019 8:46 pm
(@sunnykow)
Posts: 1417
Noble Member
 

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

 
Posted : 16/01/2019 4:09 am
(@chandra_polimyahoo-co-id)
Posts: 5
Active Member
Topic starter
 

Thanks Sunny,

it works! Amazing.

Best regards,

Chandra

 
Posted : 28/01/2019 8:37 pm
(@sunnykow)
Posts: 1417
Noble Member
 

You are welcome.

Sunny

 
Posted : 28/01/2019 9:29 pm
Share: