Help with rearranging similar entries side by side from two separate workbooks in one worksheet

[zainnofear]

Hello All,


I am currently working on a project wherein I am suppposed to compare the entries made by my supervisor and the entries that are generated from the software. This is becoming very tedious as I have to keep the two spreadsheets open side by side, then search for similar entries by eye balling and copy and paste them together side by side to show comparison.

I would be very grateful if someone may help me with a macro that can search for keywords, reorder and rearrange the entries. I am attaching the three worksheets for a better picture.

Worksheet A is the one prepared by my supervisor.
Worksheet B is the one generated from the Software
Worksheet C is what the macro code should be doing (desired). Right now worksheet C has been done manually by me which took me 3 hrs


Thanks a lot in advance.

 

[zainnofear]

I am unable to attach the worksheets. Can anyone guide me how to attach excel files here on this thread?

 

[zainnofear]

You may download the worksheets from the links below for review
Worksheet A - FileSwap.com : Worksheet C.xlsx download free
worksheet B - FileSwap.com : Worksheet B.xls download free
Worksheet C - FileSwap.com : Worksheet A.xlsx download free