I am new to this forum and appreciate worth of all who want to help and share knowledge.
I would like to extract or copy rows from one sheet with dates which are 3 or less days distant from today.
Foe example, in column E - I have a deadline dates. In column F - based on formula, =(E2-TODAY())) I got days to deadline.
I want to know is there any formula to extract rows which contain values 3 or less than 3 in cells in column F, and paste that rows in another sheet as list of deadlines with condition values between 0 to 3. It would be nice to get comment if values are less than 0 (negative values) that deadlines are missed.
Can this be done with formulas or it must be macro or VBA ?
Thanks in advance
Copy rows with specific data to another sheet automaticaly