Hello guys,

in the worksheet 'Stock' have a table with many columns , and in one column
the input list has always 4 names of people. (Haris, Chris, Tom, Michael)
Now i want to have 4 different worksheet, one for each person. How can i
gather the data of each speicific person and transfer it automatically to
each person's worksheet? (For example in the 'Haris' worksheet, to search the
columns of the names in the 'Stock' worksheet and show only the ones with
Haris in them).
If i understand if this is possible, then i can do it also for the other
variables in the other columns, and create similar worksheets.

Thank you very very very much in advance,
Haris

The use of autofilter to get Harris's data from "Stock" sheet is a start.

Then copy visible cells to Harris's sheet.

See Ron de Bruin's site for code to copy results to another sheet.

http://www.rondebruin.nl/copy5.htm


Gord Dibben MS Excel MVP


On Sat, 27 Oct 2007 07:26:01 -0700, Haris
wrote:

Hello guys,

in the worksheet 'Stock' have a table with many columns , and in one column
the input list has always 4 names of people. (Haris, Chris, Tom, Michael)
Now i want to have 4 different worksheet, one for each person. How can i
gather the data of each speicific person and transfer it automatically to
each person's worksheet? (For example in the 'Haris' worksheet, to search the
columns of the names in the 'Stock' worksheet and show only the ones with
Haris in them).
If i understand if this is possible, then i can do it also for the other
variables in the other columns, and create similar worksheets.

Thank you very very very much in advance,
Haris