Sorting in Excel, from table to sheet

[fanch72]

Hi,
I guess this is a bit tricky:
I have a table, and I want to move all lines into separate sheets.
For example
A B C
1 name1 data1 value1
2 name2 data2 value2
3 name3 data3 value3
4 name4 data4 value4
sheet1

becomes
A B C
1 name1 data1 value1
name1

A B C
1 name2 data2 value2
name2

A B C
1 name3 data3 value3
name3

I hope that someone can help...

Thanks

 

[SkipVought]

Hi,

I'd avoid destroying your table. Generally, this is not a good design.

What's the purpose of putting one row on each sheet?

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]

 

[fanch72]

each row contains sensitive data about a specific employee. I want one sheet per employee to be able to hide other employees data while reporting

 

[SkipVought]

{...hide other employees data while reporting"

Check out the AutoFilter. One Table to report from is the way to go.

Skip,
[sub]
When a group touring the Crest Toothpaste factory got caught in a large cooler, headlines read...
Tooth Company Freeze a Crowd! and
Many are Cold, but Few are Frozen![/sub]