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 data from sheet 2 into Sheet 1, realigning the data in the process. Here is the step by step process.
1. The macro will have a dialogue box which will ask which cells from sheet 2 are to be copied.
2. Another dialogue box will appear asking to where to paste the data (sheet 1 most likely). The range indicated in the dialogue box will be copied into sheet 1, except that, this time, the data should now be rearranged like in sheet 1 data.
3. Lastly, the original data in Sheet 1 will be compared to the copied data (like A1 = A17). If the copied data from sheet 2 is not the same with sheet 1 data then the copied data shall be highlighted (RED color maybe).
Appreciate the help guys!
Thank you in advance!
1. The macro will have a dialogue box which will ask which cells from sheet 2 are to be copied.
2. Another dialogue box will appear asking to where to paste the data (sheet 1 most likely). The range indicated in the dialogue box will be copied into sheet 1, except that, this time, the data should now be rearranged like in sheet 1 data.
3. Lastly, the original data in Sheet 1 will be compared to the copied data (like A1 = A17). If the copied data from sheet 2 is not the same with sheet 1 data then the copied data shall be highlighted (RED color maybe).
Appreciate the help guys!
Thank you in advance!