Thread: delete rows by looking at the next column if they are equal
View Single Post
 
Old 03-19-2018, 06:38 AM
Pat.hooybergs Pat.hooybergs is offline Windows 7 64bit Office 2013
Novice
  
Join Date: Mar 2018
Posts: 1
Pat.hooybergs is on a distinguished road
Default delete rows by looking at the next column if they are equal
Hello all

i am a novice but i need to created a vba to delete rows were a certain column is equal to the row above this row. And if it is another value in the cell (column) the same info.

I diid insert an exemple were the rows in yellow has to be kept and thos with no fill has to be deleted.
the column to refer too is "B". (Naam)

thx all
Attached Files
File Type: xlsx Map1.xlsx (10.6 KB, 15 views)
Reply With Quote