Hi Guys! I need your help with something. I have this concept for a macro file which will compare two excel sheets. The data on Sheet 1 is the same with Sheet 2 which will should be easy for most of you, however, the data in Sheet 2 is rearranged. Normally, i use HLOOKUP and VLOOKUP to copy the...