Hello,

I'm trying to put information from one worksheet which for every item is presented in two rows into a new worksheet where the information is reduced and put into one row.
Unfortunately I can't upload files from the office so written down below is what should happen.

worksheet Source has item information in two rows, columns A to O. (All cells have values).
The worksheet has information about 800 different items (so the number of rows will be different for every new monthly file).
The information in a cell on the worksheet Source has to be copied to the worksheet Target as follows:
Source!A1 to Target!A1
Source!B1 to Target!B1
Source!B2 to Target!C1
Source!E1 to Target!D1
Source!C2 to Target!E1
Source!D2 to Target!F1
Source!E2 to Target!G1
Source!F2 to Target!H1
Source!H2 to Target!I1
Source!I2 to Target!J1
Source!J2 to Target!K1
Source!K2 to Target!L1
Source!L2 to Target!M1
Source!L1 to Target!N1

I think it has to be solved in VBA, but any suggestion will be appreciated!

Regards,

Jurgen