Results 1 to 8 of 8

enhancing Column A through Column B

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-12-2007
    Location
    Germany
    MS-Off Ver
    MS Office 2007 on Windows 10 (German Version)
    Posts
    105

    enhancing Column A through Column B

    Hello,

    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):

    Col.A      Col.B      Col.C
    A	B,C,D,E	FF
    S	A,F,G	FFG
    T	N,O,C	NFS
    U	V,X,W	EES
    Y	C,D	NNO
    Z	A,B,C	KKL
    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".
    
    col.A      col.B      Col.C
    B	A,C,D,E	FF
    C	A,B,D,E	FF
    D	A,B,C,E	FF
    E	A,B,C,D	FF
    F	S,G,A	FFG
    G	S,A,F	FFG
    N	T,O,C	NFS
    O	T,N,C	NFS
    V	U,X,W	EES
    X	U,V,W	EES
    W	U,V,X	EES
    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.

    image

    Thank you very much for each answer.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1