VBA Looping Data n' Deleting Duplicates

[Pinaceous]

Hi All,

I have three separate data tables, where I'd like to loop values for specific row values for columns G & I and delete its duplicate.

Where;

Data 1: is between Rows (2-172)

Data 2: is between Rows (173-273)

Data 3: is between Rows (274-573)


Here;

Data 1 - This is the 2nd place where the loop goes and takes the values for Columns G & I.

Data 2 - This is the Last Place where the loop goes and takes the values for Columns G & I.

Data 3 - This is the First Place where the loop begins and takes the values for Columns G & I.



Example:


So if all three duplicates are present;

Data 1:

Column C	D	E	F	G	H	I
XY 155	WWW	XY	155	1659	WWW	259

<tbody>
</tbody>

Data 2:

Column C	D	E	F	G	H	I
XY 155	WWW	XY	155	1459	WWW	559

<tbody>
</tbody>

Data 3:

Column C	D	E	F	G	H	I
XY 155	WWW	XY	155	1759	WWW	359

<tbody>
</tbody>

Where after deleting a duplicate it takes the values of Data 2 producing;

Column C	D	E	F	G	H	I
XY 155	WWW	XY	155	1459	WWW	559

<tbody>
</tbody>

Let me know what you can come up with.

Thank you,
Pinaceous