Hi,
I have 3 worksheet namely-Data1,Data2,Data2(Revised).The entire structure of Data1 is fixed.I have highlighted by green Data1 and Data2 columns A,B,F whose match are found between Data1 & Data2.The third column i.e J is being highlighted as Red as they are not found exact match even though A,B,F column are matched.In order to get J column exact match,I have shifted row from F to J row (or say A:J row can be shifted).
This will result in exact match which I have shown in Data2(Revised) worksheet.
There are a lot of such cases in Data2 whose rows is required to be altered/shifted so that there will be exact match of A,B,F & J columns between Data1 and Data2 worksheets.Sample results is shown in Data2(Revised) worksheet.
Since, I have very large data.I want this all to be done by VBA code.
Reply With Quote