Forum

Julian Per request I attached the other Codes hope this can be useful. David

OK , no problems let me tidy up a bit the VB code, then share it with you after the Chiense New Year Holidays. Again thanks Sunny the great contri...

Sorry, some codes are denoted in Jap/Korean Language. David

It 's terrifice, wonderful you got the VB loop working beautifully. Really do arppreciate that , Sunny..

Thanks Sunny ! For Q2 (calculate balance to be delivered), is it a separate report? David :Yes , it is considered a separate report we want oursel...

Psl refer attn samples for New PO data to be upload the control summary

Thanks Sunny! I think you got the problems almost solved But there are two more points (1 ) How to add new PO data [ Sheet : "New PO" to the ...

Dear Sunny , Sequence is Today Reply --> Purchase Order Control summary[ Column: Today Reply] Qty PO Bal Qty =PO Qty - Received Qty

Thanks Sunny for the Vookup suggestion with iferror condition; but It' s not there yet Let me explain a little bit the field stucture in the Table ...

pls refer attach

I still got problem with the forum upload , so no choice I send attachment via Email .

Oh I see thanks Sunny !

A bit lost and sorry , pls show how to run this VB..

Again thanks so much Sunny, it works perfectly OK after a light modification to the VB loop. Rgds, David