Deleting rows when date within cell expires

[007juk]

Hi,

Sheet2 of my workbook contains 10 columns the last column is titled 'expired' and when that cell contains a date that is expired I would like it to automatically delete row and maybe cut to another sheet if possible.

Column 6 of Sheet2 has a date, column 9 has a time limit date so that I can select expiry period and column 10 has a formula to generate an expired date.

formula in column 10 reads - =DATE(YEAR(F2),MONTH(F2)+LEFT(I2,FIND(" ",I2,1)),DAY(F2))

Thanks

[unmarkedhelicopter]

So what work have you done on this ?

[007juk]

I've set-up sheet2 with my column headers and I have code ready for my data entry userform. Once I obtain delete formula/code I can then start to input my data.

[unmarkedhelicopter]

Well, let's see you worksheet.
Where did you get your userform from ?