Hi I have a very long table and many identical sheets of the same.
Col A is ID's
I have a list of ID's which I want to remove from these table (the whole row)
Has anyone ever written a macro which looks at cell A1 and checks to see if that ID is in my to remove list and if so removes row and moves to next cell.
Hope this is clear at all.