View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Michaela Michaela is offline
external usenet poster
 
Posts: 14
Default Sort column and take row info with it.

In Exel; is there a way to sort Column A and have the information in each row
follow the change?
For example: A5 has 4567 in Column A, with information about 4567 in
different columns but on the same row.
However, when I enter 3456 in Column A, it sorts by number (which I want it
to do), but it leaves the information about 4567 in that row. I need the
information to correspond with the number in Column A.
Does anyone know how to correct this problem?