Comparing two dates

  • Thread starter Thread starter minimoi
  • Start date Start date
M

minimoi

I have an required date in colmn E and a confirmed delivery date in column H.

I need code to delete the line if colmn E date is before Colmn H date. This
needs to run through a worksheet that varies in size daily.

All help very much appreciated.
 
minimoi said:
I have an required date in colmn E and a confirmed delivery date in column H.

I need code to delete the line if colmn E date is before Colmn H date. This
needs to run through a worksheet that varies in size daily.

All help very much appreciated.
Click to expand...

Forgot to mention that if the date in colmn H, has it's cell highlighted in
red then I do not want it deleted.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare dates 2
Using lookup to find todays data and display in different worksheet 4
Multiple Worksheets, Date 3
Find Values and Update 2
vba problem lookup in a matrix 1
Adding date to a column in Excel 5
Help with difference in time macro 6
Compare worksheets to copy and paste data based on matching criter 1

Back
Top