007juk
11-08-2007, 01:28 PM
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
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