Hi Andy,
So let's move the data one column, and indeed put the customername in column A.
The productnames are (can be filled) in columns B, D, F, H, J, L, N, P, R, T
The qty's are (can be filled) in columns C, E, G, I, K, M, O, Q ,S, U
On each row, a customername is in column A.
If a...