I have 15000 rows and two columns, A and B. If a cell anywhere in column B matches a cell anywhere in column A, I want to delete that record in column A. I'm not sure if there is a formula for this and i don't understand references to DIM and SUb in various macro posts. I am very familiar with =() etc in a formula but not this macro coding. If it helps to put things in context I need to allocate postcodes (column A) to new salespeople as they come on board - one per salesperson. Each week I want to paste a list of the previous week's allocations (column B) and remove these from column A so they don't get reallocated. Any help much appreciated. Thanks, Richard.
Bookmarks