Hello everyone, I look for a code that can help me to set up a report and move the data based on conditions: IF the first data string is different from 2018 in Column A and/or B that string of data should be cut and pasted in the last column above that very line. So every time the expression is different from "2018" than the number and text string should be pasted in the last column above. 2018, 1, 90712, 10024405, G6, Snr HR Assistant (HQ), CHE, BIREAUD, Diana, 10012792, 10000.5 2018, 1, 90712, 10022552, P3, PSFR Officer (Switzerland), CHE, DAVIES,Jane, 10033382, 10000.72 2018, 1, 90712, 10020882, P4, Head of Global Comm Desk (NY), CHE, GHEDINI,Jon, 10006723, 10000.64 2018, 1, 90712, 10012632, P4, Snr Prjt Dvlpt Officer (PSFR), CHE, KEITH,Eleanora, 10006729, 100056.44 I can send an attached xls file if necessary Best Anthony

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

VBA loop that moves data based on conditions

Thread starter MRDecarte
Start date Aug 8, 2018
Tags

che column data pasted string

MRDecarte

New Member

Aug 8, 2018

Hello everyone,

I look for a code that can help me to set up a report and move the data based on conditions:

IF the first data string is different from 2018 in Column A and/or B that string of data should be cut and pasted in the last column above that very line. So every time the expression is different from "2018" than the number and text string should be pasted in the last column above.

2018, 1, 90712, 10024405, G6, Snr HR Assistant (HQ), CHE, BIREAUD, Diana, 10012792, 10000.5
2018, 1, 90712, 10022552, P3, PSFR Officer (Switzerland), CHE, DAVIES,Jane, 10033382, 10000.72
2018, 1, 90712, 10020882, P4, Head of Global Comm Desk (NY), CHE, GHEDINI,Jon,
10006723, 10000.64
2018, 1, 90712, 10012632, P4, Snr Prjt Dvlpt Officer (PSFR), CHE, KEITH,Eleanora, 10006729, 100056.44 I can send an attached xls file if necessary Best Anthony