Excel - cond. copy data from tab to tab

Closed
tuman84 - May 27, 2010 at 10:08 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 27, 2010 at 04:55 PM
Hello,


I was hoping someone could help me out with a code for Excel.

What I require is a macro or a workaround for Excel to copy a row from one sheet to another once a column in that row reads "0" (as in the amount of days I have left)

What I was working on is to have two sheets. One with the tasks to do, and days left to do them. Another sheet with the tasks rendered complete once the days to do reaches 0. All tasks (in real life) get done on the 0 day.

Could someone please advise?

Thanks.

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 27, 2010 at 04:55 PM
0