VBA- Auto save Invoice Details

[sanket_sk]

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