View Single Post
  #1   Report Post  
Old January 25th 06, 07:58 PM posted to microsoft.public.excel.misc
mcvities_69
 
Posts: n/a
Default how do i set up a list of names on a sheet frm various sheets in e

Help!!
in Excel i am trying to create a list of total name to be generated
automatically, basically i have 5 sheets the first 4 have dates and names in
columns id like to end up with a total list of the names on the 5th
sheet....for example

1st sheet mark 2nd sheet anne 3rd sheet mark
dave paul dave
john matt john

anne

paul

matt
id like the third sheet in example to automatically enter the data from the
other sheets in a column together under each other even though i could enter
more or less names than aticipated?

Thanks for any help....