Remove rows where value is not between two dates

[tbourne]

Hi Guys,

I have an spreadsheet where I would like to run an macro that will delete rows where the dates are not between to dates (WHS Dashboard C3) and (WHS Dashboard H3).

The table of data is stored in an WB called Open Incidents and the dates are stored in Coll C

Thanks for your help

[patel45]

attach please a sample file with data and desired result

[tbourne]

The file can be found at

All incidents between the to dates (WHS Dashboard C3) and (WHS Dashboard H3) should be removed...

[Solus Rankin]

tbourne,

If you click the 'Go Advance' button below, and then the paper clip in the toolbar you can attached your work to your posts here.

No need to use a cloud.

[Solus Rankin]

Your ws has July 1st in both cells. No dates fall between July 1st and july 1st.

[tbourne]

Thanks for that XeRo... I will me more then happy if you change the dates 01 June 2013 - 01 July 13

[Solus Rankin]

so you want to remove all rows in sheet 2 if the date in column b falls in between the dates in cells c3 and h3 on sheet 1?

[tbourne]

Hi XeRo... that's Correct

[Solus Rankin]

try

Please Login or Register  to view this content.

[tbourne]

Hi,

That does nothing... Could you maybe place this in the work book and then upload that?

[Solus Rankin]

It works on your example spreadsheet if you change the dates.

Make sure you add data to your worksheet and that the dates fall between your dates on cover sheet.WHS Reporting Dashboard.xlsm