View Single Post
  #2   Report Post  
Old January 27th 06, 02:51 AM posted to microsoft.public.excel.misc
Posts: n/a
Default how do i set up a list of names on a sheet frm various sheets in e

Send your info to:


for excel demos
- -mark

"mcvities_69" wrote:

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



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....