delete rows by looking at the next column if they are equal

		Microsoft Office Forums > Microsoft Excel > Excel Programming
delete rows by looking at the next column if they are equal

FAQ

Thread Tools

Display Modes

03-19-2018, 06:38 AM

Pat.hooybergs Pat.hooybergs is offline

Windows 7 64bit delete rows by looking at the next column if they are equal

Office 2013

Novice

Join Date: Mar 2018

Posts: 1

Pat.hooybergs is on a distinguished road

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

Map1.xlsx (10.6 KB, 15 views)

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro delete table rows if cell in first column = $	Btop	Word VBA	7	02-13-2018 05:36 PM
Delete blank rows between the two rows that contain data	beginner	Excel Programming	5	12-26-2014 12:29 AM
Delete All empty Rows - Print - Undo all Rows deleted	Bathroth	Word VBA	1	10-01-2014 01:40 PM
Huge table needs to link rows and column in a special manner (when not equal to 0)	melieetnala	Excel	1	08-12-2014 05:56 AM
Make row in one sheet equal column of another	hypertyper	Excel	6	01-31-2012 03:48 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:54 PM.