Hi All,
I have created one invoice template, different users will use this invoice template for inventory management as well.
We have given selection Sale / Purchase so that transactions can be identified.
I am looking for VBA which will copy entire details updated in Invoice and paste in Data tab.
VBA should copy and paste below earlier data
AT times we may have 1-2 spare lines and in some case it will be up to 15 spare lines VBA should be able handle these changes
Note:- If Transaction type is Purchase then Customer type, Customer name, Contact number, City filed are not necessary
Sample file is available at drive - Please help me build this VBA
File location.
https://drive.google.com/file/d/1cQ4ffJlMBhDA3e02GRpQkFj-uon4Nuop/view?usp=drivesdk
Thanks & Regards,
Sanket
I have created one invoice template, different users will use this invoice template for inventory management as well.
We have given selection Sale / Purchase so that transactions can be identified.
I am looking for VBA which will copy entire details updated in Invoice and paste in Data tab.
VBA should copy and paste below earlier data
AT times we may have 1-2 spare lines and in some case it will be up to 15 spare lines VBA should be able handle these changes
Note:- If Transaction type is Purchase then Customer type, Customer name, Contact number, City filed are not necessary
Sample file is available at drive - Please help me build this VBA
File location.
https://drive.google.com/file/d/1cQ4ffJlMBhDA3e02GRpQkFj-uon4Nuop/view?usp=drivesdk
Thanks & Regards,
Sanket
Last edited by a moderator:
