Copy rows with specific data to another sheet automaticaly

Closed
Report
Posts
1
Registration date
Thursday September 19, 2013
Status
Member
Last seen
September 19, 2013
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
Hello,

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

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi Sasha,

Since formula's can't copy/paste you will need to use VBA.
Provide more details if further assistance is needed.

Best regards,
Trowa
0