Thread: Grouping Rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Justin Philips Justin Philips is offline
external usenet poster
 
Posts: 32
Default Grouping Rows

Here is my situation:

I have a list of entries that i need to group according to their choice

so i get a list of people

Justin "choice1"
Sharon "choice2"
Marisa "choice3"
Joe "choice2"
John "choice3"
etc...

I have another sheet set up like this

choice1
choice2
choice3
choice4
....

i need to copy the cells from sheet 1 to sheet to so it ends up like
this
choice1
Justin
choice2
Sharon
Joe
choice3
Marisa
John
choice4
....
5
....

Can anyone help in this. I can post code but there is more to my
current code than what i am asking for here...i just need a place to
start.

Thanks,

Justin