Dividing Data of Sheet 1 to List Of Data in Sheet 2

[Silent Observer]

Hi,I have an Excel Workbook (in Shared Mode) which has 3 sheets,Sheet 1 has a list of task represented in each row and in sheet 2 there are names of people who will do that,I want to automate this task of allocation to different people(Names in Sheet2) to a new sheet sheet3 and I want to build an automatic system which will divide the data(sheet1) equally for the names available in sheet 2,so can any one suggest me how can do this task without involving to much complication.thank you in advance.

 

[Hui]

Provided you have a field in Sheet1 including the Names

And a list of names in Sheet2

You can add a cell and use a lookup to populate a list in Sheet3 that just corresponds to that person.

You may want to start here:

http://chandoo.org/wp/2011/11/18/formula-forensics-003/

or

http://chandoo.org/forums/topic/how-can-i-get-only-certain-data-from-one-sheet-to-show-on-another-sheet

or

http://chandoo.org/wp/2012/05/14/vba-move-data-from-one-sheet-to-multiple-sheets/


Also have you thought about using a Filter on the original data

Goto Insert, Table

Then use the filter drop down on the headers