comparing two rows in dynamic cell range

[3MMM]

Ok, greetings all this is my first post (certainly not my last since I'm the only person working on this project). I have very VERY little VBA experience so what you see is kinda similar to my "hello world".

to make a long story short.. i would like to compare two rows in a dynamic ranged sheet (gets updated from access database upon opening)
and find a row that matches exactly for the 1st 4 columns(see code), then comparing the 7th column for the highest value out of the two compared
,then after all these criteria have been met, throw away the lowest and keep the highest. FOR ALL ROWS (in other words a while loop).

heres my worthless code

Please Login or Register  to view this content.

basically this does absolutely nothing but make my excel sheet take foreveer to open.
any help would be appreciated, especially since i tried asking one of my college professors for help and he had no idea how to help me out :/

[3MMM]

here's the other parts of the workbook
sorry for replying to my own thread but, i had exceeded the maximum char limit on the OP

Please Login or Register  to view this content.

want to help me out but not with this problem? (http://www.excelforum.com/excel-programming-vba-macros/991060-finding-matching-cell-in-another-sheet-in-same-book.html

[3MMM]

bump... any sign of life would be appreciated