OK, my problem is probably very simple, but i just can't seem to figure it out. I import 13 .csv files into one excel workbook, each into a separate sheet. In each .csv file there is the word "FINALS", which will always be in column A, but never the same row. I need to locate the word "FINALS" and then return the data in the following two rows below it (across columns A-L). The 14th sheet (named results) will gather the data i have collected from each of the 13 sheets.
HOW?
Thanks for any help.
jeff.
Bookmarks