i have a list containing six columns A,B,C,D,E,F in Sheet"original". It seems like follows ( the columns C,D,E,F are not relevant for macro therefore i am puting only Column C as example for the Columns D,E,F):
Now i need a macro which enhances the column A through column B. The macro should put those members of Column B in Column A which donot already exist in column A. These new entries should be done in another sheet "new". For example the first entry in Column A is "A" and the corresponding members to that are "B,C,D,E" in column B. Now as far the corresponding members "B,C,D,E" dont exist as members in column A they should be added one after another to the new sheet to column A. This new entry in Column A in sheet "new" should have the original member from column A the "A" and "C,D,E" (not "B" itself") members in column B in sheet "new". All the corresponding members of other columns to the original column A should also be pasted to the new sheet in corresponding columns. No Duplicates in Column A in Sheet "new" should be allowed. After running the macro it should generate the following new list in sheet "new".
I am uploading an image and an excel file. The colors in the image means nothing but only an effort to make the problem understandable.
Thank you very much for each answer.