Hi
I have two sheets with the exact same column headers and data that changes constantly. I need a formula that will "search" both sheets for a specific word in one of the columns and copy the rows that has that word to the third sheet.
Dont know if i'm explianing it correctly.... but how it should work is, if i type the word into "A1" of the third sheet, all the rows that contain that word in the specified column in sheet1 & 2 must "copy" to the third sheet from "A3" down.
Example : (criteria = hi
Sheet1 Sheet2 Sheet3
Column1 Column2 Column3 Column1 Column2 Column3 Column1 Column2 Column3
1 hi 2 3 ho 4 1 hi 2
5 ho 6 7 hi 8 7 hi 8
I don't know if this will have any bearing, but the actual sheets are 9 columns and the data goes as far as row 5000 in each of the two "search" sheets.
Any help will be greatly appreciated.
Bookmarks