Copy rows with specific data to another sheet automaticaly

Closed
Sasha70 Posts 1 Registration date Thursday September 19, 2013 Status Member Last seen September 19, 2013 - Sep 19, 2013 at 03:33 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Sep 23, 2013 at 11:19 AM
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 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Sep 23, 2013 at 11:19 AM
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