Creating and printing task lists per person

[Chilik]

Hi,

First I want to thank all of you for posting and answering questions, it really helps especially for a new comer as myself.
I have this task I'd like to get help on:
We are using Excel to monitor projects and assign tasks to persons, on the active sheet we will write the details of the task to be done and assign it to john or jack and so on ( usually not more than 5 persons). Every task that is finished is marked as "Done" and we don't need to print it. We'd like to have a button that after we finish updating all the finished tasks we will have tasks lists per person appearing on separate sheets and printed out to our default printer.

Thank you so much for your help!

Chilik

 

[dermie_72]

you could create your own macro, recording if need be,
Where you filter the sheet, to <> Done and 1 persons name, print to the selected printer. Select the next persons name, print...repeat until you have all the names printed.
Save the macro, and then assign a button to it, so you can click on the button to re-run the macro.
You could also click on view/macros/view macros and select the macro that way too.