Help to join 2 sets of data by modifying MACRO into VBA

Dear All,

We need to get data from 2 system and combine them into 1 summary and format the header and do a sum adding.

I had attached a workbook with the MACRO that I had created which some steps that still needs to do manually.

Is it possible to write a VBA and do it in 1 button?

Please Login or Register  to view this content.

Kind regards
Leo

Hi
Try

Please Login or Register  to view this content.

Thanks to both LeoTaxi and mohadin.

I had adopted and do some amendments to LeoTaxi's script but was stuck on how to fixed the row height to 15.5 using LeoTaxi's script.

I had tried few ways to add in a fixed row height script but failed.

Can I fixed a top page margin to 4cm and bold the last row (the sum amount)?

Can someone help?

Originally Posted by LeoTaxi

Please Login or Register  to view this content.

Kind regards
Leo

Dear Leo,

I had amended this section as the addition is not working as my rows will change from time to time.

Please Login or Register  to view this content.

Thank you for the guidance and the code works great!!

Originally Posted by mohadin

Hi
Try

Please Login or Register  to view this content.

Dear Mohadin,

Your code was "too complicated" for me to modify but appreciate your help.