Macro for matching by shifting rows down and getting difference

[kumarrajesh]

Hi All,

Many thanks in advance for the help.

I am looking to write a small macro for a task that we do daily on huge data. The task is to compare two columns (A&B) match them and get difference of columns (C&D) in difference column.

If value in column ‘A’ is greater than value in column ‘C’, then shift down rows in column ‘A’ and vice versa, if value in column ‘A’ is less than value in column ‘C’ then shift down rows in column ‘C’.

After matching process is completed we have to get the difference of column ‘B’ and column ‘D’ in difference column.

Also what if data in columns ‘A’ and ‘C’ are alphanumeric values, still can be done.

For reference attached the sheet.

Regards,
Rajesh.

 

[Abdul Matheen]

Hi,

I have made macro as per your requirement, check the attached workbook and run the macro "rearrange".

Regards
Abdul Matheen

 

[kumarrajesh]

Thank you very very much Matheen, thank you for your time. The code works perfect. Great work.