VBA - Delete row based on cell above (date) and cells left (number)

Status
Not open for further replies.

marshy3300

Board Regular
Joined
Aug 17, 2014
Messages
54
Hi - I have in A some order numbers and D has dates. A will populate blanks below row 1 until a new order begins and then enter a new order number followed by blanks dependent on how many lines on the order. D has 2 different dates.

I want to be able auto fill the blanks in A (already solved) and delete the whole row based on the date above not matching and the order numbers matching as well.
Where the order number is listed as default (before auto fill) the corresponding date will always be the one to keep

Sorry i cant post attachements!

1 order number code description date <result>
2 66644 Item1 Descr 1 13/06 Keep
3 blank item2 descr 2 13/06 keep
4 blank item 3 descr 3 07/06 delete
5 blank item 4 descr 4 13/06 keep
6 66687 Item1 Descr 1 20/06 Keep
7 blank item5 descr 5 13/06 delete
8 blank item 6 descr 6 20/06 keep
9 blank item 7 descr 7 13/06 delete
10 67015 item 3 descr 3 19/09 keep
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,099,316
Messages
5,467,882
Members
406,558
Latest member
MattJC7

This Week's Hot Topics

Top