VBA loop that moves data based on conditions

MRDecarte

New Member
Joined
May 24, 2014
Messages
20
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.



<tbody></tbody>


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

<colgroup><col span="9"></colgroup><tbody>
</tbody>
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,108,732
Messages
5,524,513
Members
409,583
Latest member
RedHelp

This Week's Hot Topics

Top