View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ILoveMyCorgi ILoveMyCorgi is offline
external usenet poster
 
Posts: 55
Default if cell text repeats, move the adjacent column to the same row

In the first column I have a student number, the second column the book
title. In the next row the same student number, with a different title, and
so on until I get to the next student number and a new set of book titles the
student has checked out. Is there a way using visual basic where the one
unique student number displays with all of the titles for that student in the
same row?