I will assume that a "page" is a "worksheet".

See Ron de Bruin's site for VBA code that filters for Fred and and will copy
Fred's rows to a new worksheet.

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


Gord Dibben MS Excel MVP

On Tue, 19 Feb 2008 08:07:01 -0800, Lost in Excel <Lost in
wrote:

Hello,

I have a spreadsheet text in column A with repeating names and I need to
display the data found in column B on another "page 2" in Excel. The problem
I'm having is that "page 2" needs to display the information for that person
only with no other data. Here is an example.

1 2
A Fred 5155551111
B Steve 8085552222
C Fred 7025555555
D Fred 9095554444

On "page 2", I want it to just include the Fred information only and on
"page 3" I want the Steve information only. I'm not very experienced and
would appreciate any help at all in moving the data. Thanks!