I have a sheet that is completed by a customer which I need to search based on a keyword, locate the cell that has that keyword, shift one cell down, copy that cells info and paste to another sheet. I would normally just use = to copy the cells information over but I don't know where the info entered by the customer will start.