Forum

or they can map this VBA File into their C: whatever. Then, no matter when you do the update, can be make avail to all these users . Of course you...

Thanks Sunny I got it fixed already , thanks your sincere help again and again.

Sorry if we want to write the unquie LOR No of each invoice at the left end bottom of the invoice how to change the macro?

Thanks, Sunny that's exactly the idea to place the desired data into the re-designed template, using the new master record. Will recheck if more ...

THANKS SUNNY.FULLY UNDERSTAND THE LIMITAION. BUT NOW WHEN I CHANGE THE TEMPLATE LAYOUT PLS REFER, NOW CAN NOT USE THE MACRO TO ALLOT THE DAT...

Sunny. The macro works perfectly. Thanks again... BTW , can we use the Pivot Table, the idea you demonstrate earlier and using the Page Field to ...

But really need to split the Inovice one by one and send to Customer, what to do next , pls help further...

Perfect Sunny! But really need to split the Inovice one by one and send to Customer, what to do next , pls help further...

Thanks Sunny ! Separate Invoice file, already using the Split macro, but to include multiple items per univque invoice number per Master works...

Yes ... but not sure how to modified the Macro to suit the purpose

Tks Sunny ...We learn a lot and honestly all of us here agreed we enhance our Excel skills so much via this Forum day after day .... Your positive...

Tks millions again, Sunny that superb, reallly excellent painting, my one better forget and shame to share.

How to make the following "Copy" VB script more precise and comprehensive Sub Copy() Sheets("Test").Activate Range("A:F").ClearContents ...

Thanks so much Sunny will test on the VB with live data.