VBA dynamic loop

[akramer08]

I have a spreadsheet with 6 columns, A:F. A - order number, B - origin, C - destination, E - movement origin, F - movement destination. It shows what routing the order will take to reach the destination.

For each order there is an origin and destination, and a movement for the flight. The first movement will have to begin at the origin, so col B. The next movement(located on the next row), will have to begin at the destination of the first movement. Examples

1 movement

ID7

CVG

LAX

TT63

CVG

LAX

movement 1

<tbody>
</tbody>

2 movements

ID12	LAX	JFK	TT34	LAX	CVG	movement 1
				CVG	JFK	movement 2

<tbody>
</tbody>

3 movements

ID8	CLT	LAX	TT36	CLT	GSO	movement 1
				GSO	CVG	movement 2
				CVG	LAX	movement 3

<tbody>
</tbody>

There is no set number of rows for each of the orders which is why it will need to recognize how many rows it uses. I need a macro to see if the movements match up. If they dont, then list the ID number on Sheet 2.

 

[akramer08]

Any suggestions?

 

[patel45]

please upload a sample file (with current data and desired result) on a sharing site, then paste the link here

 

[akramer08]

Im not sure how to do that, never done it before. Would a table in the post be sufficient?

 

[akramer08]

Well here is a table of the data and the desired results

Order <tbody> </tbody>	ORG <tbody> </tbody>	DST <tbody> </tbody>	# <tbody> </tbody>	A Org <tbody> </tbody>	A Dst <tbody> </tbody>
99222201421 <tbody> </tbody>	CVG <tbody> </tbody>	SFO <tbody> </tbody>	TTW1 <tbody> </tbody>	CVG <tbody> </tbody>	SFO <tbody> </tbody>
99222201185 <tbody> </tbody>	LAX <tbody> </tbody>	CVG <tbody> </tbody>	TYH6 <tbody> </tbody>	LAX <tbody> </tbody>	PDX <tbody> </tbody>
99222201421 <tbody> </tbody>	PDX <tbody> </tbody>	SFO <tbody> </tbody>	TRWS <tbody> </tbody>	PDX <tbody> </tbody>	CVG <tbody> </tbody>
			556G <tbody> </tbody>	CVG <tbody> </tbody>	SFO <tbody> </tbody>
99222201185 <tbody> </tbody>	LAX <tbody> </tbody>	BOS <tbody> </tbody>	PLM3 <tbody> </tbody>	LAX <tbody> </tbody>	CVG <tbody> </tbody>
			76TT <tbody> </tbody>	DFW <tbody> </tbody>	BOS <tbody> </tbody>
99222208314 <tbody> </tbody>	DFW <tbody> </tbody>	PDX <tbody> </tbody>	HF89 <tbody> </tbody>	DFW <tbody> </tbody>	CVG <tbody> </tbody>
			0SMD <tbody> </tbody>	CVG <tbody> </tbody>	BFI <tbody> </tbody>
			NJV9 <tbody> </tbody>	BFI <tbody> </tbody>	PDX <tbody> </tbody>
99222207953 <tbody> </tbody>	ORD <tbody> </tbody>	SJU <tbody> </tbody>	HBF9 <tbody> </tbody>	ORD <tbody> </tbody>	CVG <tbody> </tbody>
			KD8I3 <tbody> </tbody>	CVG <tbody> </tbody>	GSO <tbody> </tbody>
			01KD <tbody> </tbody>	BOS <tbody> </tbody>	SJU <tbody> </tbody>

<tbody>
</tbody>

RESULTS

99222201185 <tbody> </tbody>	Loading Error <tbody> </tbody>
99222201185 <tbody> </tbody>	Loading Error <tbody> </tbody>
99222201185 <tbody> </tbody>	Loading Error <tbody> </tbody>
99222207953 <tbody> </tbody>	Loading Error <tbody> </tbody>

<tbody>
</tbody>

 

[akramer08]

Any ideas?