I'd like to do like this
http://www.excelforum.com/excel-prog...copy-rows.html
but
details:
a) 1 work book has many sheets.
b) each sheet contains 2 desired words (not table, (the files is from .xml) just sentense A in line1 column1, B in line2 column2, C in line 3 column1, D in line4 column 2,...)
c) copy that line to line1 column1 of SUMMARY SHEET
d) search and copy desired word2 to line1 column2 of SUMMARY SHEET.
e) go to other sheet for b) c) d)
f) it'd better if can get name of sheet to be column3 of SUMMARY SHEET.