Soldato
Can anyone help me code a macro that looks at a large range of cells for the string 'x' and if it finds one then it looks up a value in column F of its row and row 4 of its column and outputs both to a text file. It then carries on looking through the rest of that range.