Applying a Slicer For Data

[Pushppreet]

Hello Excel Gurus!

I need some help with the attached file.
Here in workbook 1 (Name BLR) I have the complete raw data. This includes a computer scenarios details and there are total 11 Classroom scenarios and 6 assessment scenario details.
Now for example Scenario 1 has data for 15 Participants and 1 trainer.
What I want is one worksheet to be created for each participant (15 total) and 1 trainer worksheet with their individual data.
So if you look at the worksheet Participant 1, I want the ticket number and tag number of Auster to get copied here. Similarly for Badal and so on.
Like this I want 16 worksheets to be created with data from worksheet 1 "BLR".

Any leads or help will be highly appreciated.

 

[Pushppreet]

Hello All, can someone please help me with this? Its a little urgent and important for me.
Appreciate your help!

 

[vletm]

Pushppreet​

I've asked same question from many: How many sheets can You see in one time?
If You can see ... one sheet in one time ... as I
Could You test something like this?
The layout is ... a bit different, but the data should be readable.
I'll see soon, what is this for You?

 

[Pushppreet]

Pushppreet​

I've asked same question from many: How many sheets can You see in one time?
If You can see ... one sheet in one time ... as I
Could You test something like this?
The layout is ... a bit different, but the data should be readable.
I'll see soon, what is this for You?

You are amazing. This is exactly what I was looking for.

Can you also teach me how to do it or where is the master information as I need to do this for 7 more files.

I have attached all the files I have with me for which the same needs to be done.

 

[vletm]

You were looking something else ... but that works too.
How to do - some basic steps, which You can do:
1) Select BLR-sheet
2) Adjust the 1st row about 85 height
3) Freeze the 1st row
4) Select one cell from that Table
5) Table > Convert to Range
6) Select columns A ... E
7) Hide ALL borders
8) Select the last cell from E-column
... and select cell A1
9) Insert > Tables
10) Table > Insert Slicer
11) Move Slicer as You want
12) with right click over Slicer
modify Slicer settings > Size and Properties ... and Slicer settings...
13) Where do You need other sheets?
You could find much more information as You would like
Search about ... Tables ... Slicers and so on.

 

[Pushppreet]

You were looking something else ... but that works too.
How to do - some basic steps, which You can do:
1) Select BLR-sheet
2) Adjust the 1st row about 85 height
3) Freeze the 1st row
4) Select one cell from that Table
5) Table > Convert to Range
6) Select columns A ... E
7) Hide ALL borders
8) Select the last cell from E-column
... and select cell A1
9) Insert > Tables
10) Table > Insert Slicer
11) Move Slicer as You want
12) with right click over Slicer
modify Slicer settings > Size and Properties ... and Slicer settings...
13) Where do You need other sheets?
You could find much more information as You would like
Search about ... Tables ... Slicers and so on.

This might sound weird, but I tried twice and was unable to get the same result as you had worked on.
I think it may be because I'm using a corporate PC and some features might be blocked, maybe?

If it's not a lot of work for you and if you can spare some time from your schedule, can you please do the same for these files?
Really appreciate your help.

 

[vletm]

It sounds weird ...
It could do this way.