How do I pass contents of a cell to a string and then use that string value to search

[ExcelDud]

I have a sheetA of string values(Test Names) in a column. In sheetB I have the same string values(Test Names) in the top row. Each Test Name is mapped to some codes that are listed below it -one in each row.

I want to find the Test Name in Sheet A, in Sheet B, then copy all the codes mapped to it in SheetC. Then I want to copy values for the Test Name in Sheet A(in 2 consecutive cells) and paste them in the corresponding cells in SheetC. I have attached a file here with the 3 sheets.

Thanks in advance.

[watersev]

hi, ExcelDud, please check attachment, run code "test".

[venkat1926]

i AM returning the file now named as exceldud.xlsm
the names of sheet1 and sheet 2 are modified as given in the enclosed file
new sheet D is inserted which gives the result of macro

in sheet 1 the number of sub names in each of the names are given in column G as culled from sheet 2. so there can be only 82 subnames.

the macros are in module of the file and are also repeated here.

Please Login or Register  to view this content.

Please Login or Register  to view this content.