Sheet 2 as Subset of records in Sheet 1

I have 2 identically laid out sheets, Sheet1 and Sheet2. Sheet1 contains all records.

Other than VBA, is there some function I can use that will make Sheet2 contain only selected records from Sheet1 based on criteria?

For example, if there are 5 records in Sheet1:
Col1 Col2 Col3
A 59 Bill
B 44 Suzy
C 33 John
C 67 James
D 12 Robert

Without using VBA, is there a function or method I can use such that Sheet2 contains only:
Col1 Col2 Col3
C 33 John
C 67 James
...(based on the value "C" in Col1 of Sheet1)?

Use a filter on sheet 1 and select on the KEY "C".

Or with an pivot table on sheet 1.

If you had added an excel example, i could have showed it to you.

Now I made one myself.

Thanks for the reply.

Glad i could help.

If the question is solved, will you mark it as solved?