Which formula to use & how

Occasional Visitor

Index creation help: If there is a certain letter in column A, I need the entire row to copy to another sheet. For example; cell A1-A10 have the letter E in it (E-1, E-2, etc) other cells in column A have other letters (ex: F-1). I need any cell in column A with the letter E in it to copy to a designated sheet in the same workbook and to bring the entire row with it. 

TIA for the help!

0 Replies