Any help on this one would be very much appreciated as it’s completely out of my depth and is the final piece of a really big puzzle.

I have a scenario where i need Excel 2008 to compare the contents of each cell in COLUMN E with the cell below it. If that matches then i need to compare the contents of each cell’s COLUMN B data. If the lower cell of the pair’s value is one minute higher than the upper row then i need to move the data from COLUMN J,K,L in the lower row to COLUMN M,N,O in the upper row.

Occasionally there is a THIRD row that needs to have data moved to the first row. in this case the values in CELLs E and E+2 would still match, but the contents of CELLs B & B+2 would be two minutes apart.

in cases like this i have to move the data from COLUMN J,K,L up one row and into COLUMN M,N,O. Worst case scenario, they have a third stop (2 minutes from original time) so i have to move the data from COLUMN J,K,L up two rows and into COLUMN P,Q,R.

EXAMPLE:

With two addresses the relevent fields look like this…

|A0|B000|C0|D0|E00000|F0|G0|H0|I0|J0000|K0000|L0000|M0|N0|O0|P0|Q0|R0|

|A1|7:00|C1|D1|555666|F1|G1|H1|I1|ADDR1|CITY1|UNIT1|M1|N1|O1|P1|Q1|R1|

|A2|7:01|C2|D2|555666|F2|G2|H2|I2|ADDR2|CITY2|UNIT2|M2|N2|O2|P2|Q2|R2|

but needs to look like this…

|A0|B000|C0|D0|E00000|F0|G0|H0|I0|J0000|K0000|L0000|M0000|N0000|O0000|P0|Q0|R0|

|A1|7:00|C1|D1|555666|F1|G1|H1|I1|ADDR1|CITY1|UNIT1|ADDR2|CITY2|UNIT2|P1|Q1|R1|

|A2|7:01|C2|D2|555666|F2|G2|H2|I2|-----|-----|-----|-----|-----|-----|P2|Q2|R2|

With three addresses the relevant fields look like this…

|A0|B000|C0|D0|E00000|F0|G0|H0|I0|J0000|K0000|L0000|M0|N0|O0|P0|Q0|R0|

|A1|7:00|C1|D1|555666|F1|G1|H1|I1|ADDR1|CITY1|UNIT1|M1|N1|O1|P1|Q1|R1|

|A2|7:01|C2|D2|555666|F2|G2|H2|I2|ADDR2|CITY2|UNIT2|M2|N2|O2|P2|Q2|R2|

|A3|7:02|C3|D3|555666|F3|G3|H3|I3|ADDR3|CITY3|UNIT3|M3|N3|O3|P3|Q3|R3|

but need to look like this…

|A0|B000|C0|D0|E00000|F0|G0|H0|I0|J0000|K0000|L0000|M0000|N0000|O0000|P0000|Q0000|R0000|

|A1|7:00|C1|D1|555666|F1|G1|H1|I1|ADDR1|CITY1|UNIT1|ADDR2|CITY2|UNIT2|ADDR3|CITY3|UNIT3|

|A2|7:01|C2|D2|555666|F2|G2|H2|I2|-----|-----|-----|-----|-----|-----|-----|-----|-----|

|A3|7:02|C3|D3|555666|F3|G3|H3|I3|-----|-----|-----|-----|-----|-----|-----|-----|-----|

once those addresses are moved to the appropriate row i’ll need to sort the whole thing by COLUMN J and delete the rows that have no data in COLUMN J.

thanks to anybody who is willing to take a stab at this.