View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Lost in excel Lost in excel is offline
external usenet poster
 
Posts: 9
Default searching and moving text

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!