Macro that generates new work sheet with people and tasks they perform

Hello All,
I have spent many hours on YouTube trying to write a simple macro that would help me with my reports that I have to run and data-manipulate manually every month. I am afraid that this macro exceeds my current knowledge and, as suggested and highly recommended by one of my friends, I am totally dependent on ExcelForum specialists.
What I am looking for is a macro that would generate a separate worksheet and populate all names and tasks people perform. I have attached a spread sheet with my small database example just to give you an idea.
The main source (database) I receive every month is a simple spread sheet containing just several columns:
- Column A - Name of a person
- Column B - Team of that person
- Column C - Task 1 (with "1" if the tasks has been performed at least once or blank if it has not)
- Column D - Task 2 (with "1" if the tasks has been performed at least once or blank if it has not)
- Column E - Task 3 (with "1" if the tasks has been performed at least once or blank if it has not)
Of course some people are involved in more tasks then others and in some months some of them do not perform these identified tasks at all.

What I am looking for is a simple button that would copy all the names into a separate spread sheet that would look like "Result" that I created manually. For every person performing more than one tasks, the macro would populate the name twice, each with different task. If for any reason one of the names has no "1" for any of the tasks, which means none of the three identified tasks have been performed by that person, that person would be skipped. Every month the tasks will be the same but the number of people and tasks they perform may change significantly.
As an extra feature, there could be a radio button that would identify whether all departments or only one of them would be included in the generated tasks list.

If there is anybody who could help me with writing that macro I would be VERY grateful !

I am available any time for additional comments, further explanation and to answer any questions.

I am looking forward to hearing form you soon.

Thank you.

Try

Please Login or Register  to view this content.

Jindon,
thank you for your quick reply. I will give it a go and let you know.

Again, thanks.

Jindon,
the code you wrote works great for 3 tasks. One more think, is there any quick way to increase the number of tasks?
I am unable to amend the code to include 4 tasks. I will eventually need 11 tasks and that seems just impossible!

I would be very grateful if you could share any ideas.
Thank you very much.

Post your workbook with before/after format.

Thanks snb. I will try your code. It looks like something very similar to what Jjindon wrote. Btw, I must have incorrectly entered the original code from Jjindon as now I can manually add any "Tasks" as I want and the macro is automaticaly populating the "result" spread sheet. Such a short but powerful code. Amazing! Thank you Jindon.


Administrator,
I absolutely agree and will comply. It was my first post and to be fair the term "cross-posting" is completely new to me. Nevertheless, I will take it into consideration in the future. Thank you.