Hi Experts,
I am looking for help, i know nothing about excel.
I have excel file with around more than 50 excel sheets. In each sheet, i want to compare for string "NAME" as topic in column "B",copy it to another sheet ex say result.xls, In column "D" the name is copied and copied to result.xls
For each name, In coloumn "B" i search for "Details" if found i copy to the result.xls. The details are in column "D" in the corresponding row as "Details". The details may be in more than one rows., i want to copy all the information till i get blank line, and copy in the in one cell corresponding to "Details".
Continue for all the sheets in the file.
Result.xls should look like
Name: George Washington
Details: blah blah blah .... < all details in many rows merged to single row> .
Prrint a blank line ..
and print another result for all the sheets.
Please can someone help me..
Regards
I am looking for help, i know nothing about excel.
I have excel file with around more than 50 excel sheets. In each sheet, i want to compare for string "NAME" as topic in column "B",copy it to another sheet ex say result.xls, In column "D" the name is copied and copied to result.xls
For each name, In coloumn "B" i search for "Details" if found i copy to the result.xls. The details are in column "D" in the corresponding row as "Details". The details may be in more than one rows., i want to copy all the information till i get blank line, and copy in the in one cell corresponding to "Details".
Continue for all the sheets in the file.
Result.xls should look like
Name: George Washington
Details: blah blah blah .... < all details in many rows merged to single row> .
Prrint a blank line ..
and print another result for all the sheets.
Please can someone help me..
Regards