View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default setting up spreadsheet

If you have one row for each contact simply sort by contact.

Select all columns before sorting.

Not sure what you mean by "add to" etc.


Gord Dibben MS Excel MVP

On Tue, 1 Sep 2009 08:12:01 -0700, Michelle
wrote:

using excel for sales contact log. i have row for each contact. I have
several columns for each contact (name, co, address, phone ... date of
contact, type of contact, notes. how do i format so i can add to the "date of
contact" "type of contact" "notes" columns AND keep related info with same
contact for sorting? I apologize, not sure how to even ask what i'm trying to
accomplish. thanks in advance!