View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
crs crs is offline
external usenet poster
 
Posts: 8
Default another combine lists question

I have another question about combining 2 excel lists into 1 list

scenario: I have a workbook with 3 sheets
Sheet 1 has a list of students in column A
Sheet 2 has a list of some more students in column A
(completely different from that of

Sheet 1)

Question: I want to combine the 2 lists into 1 single list of all
students onto Sheet 3 without just
copying and pasting because the lists will continually change and may
increase or decrease in size.

Any solutions.....

Thanks in advance!

CRS