I've been looking for something quite simple, but cannot seem to get my head around this.
I would like to copy a row of data from one worksheet to another, based on there being an 'x' in the first column, i.e.
Column = A, B, C, D, E
Row 1 = _, NL , Shop, £3m, 5Yr
Row 2 = X, DE, CRM...