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
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
-
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
2776
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
July 26, 2021
465
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!