Hi everybody,

I'm trying to work out a macro to find text with in a cell in this case "Main Crop" and copy the cell to the right and the cell to the left into 2 different cells of a newly opened spreadsheet.
Along with finding 3 other cells with text in them to the spreadsheet as well.

Much thanks in advance for any help.

Chris.