I need a macro that will check the cell in the avctive row in a specific column agains a cell on another sheet and then if it does not fit the criteria then delete the row. here is what I have right now.
Do Until IsEmpty(ActiveCell)
activerow(b)<= activesheet.sheet1 range("g1")
I have never coded in vb before so I know at least part of my problem is syntax and key words thanks for your help.