PDA

View Full Version : vba for shifting or arranging certain column with respect to Data1 sheet



akshita
12-26-2018, 11:22 PM
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.

akshita
01-30-2019, 09:48 AM
Still waiting for the reply