Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #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....

  #2   Report Post  
Old January 27th 06, 02:51 AM posted to microsoft.public.excel.misc
exceluserforeman
 
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:


see
http://www.geocities.com/excelmarksway

for excel demos
- -mark


"mcvities_69" wrote:

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying information and calculations from one sheet to another she HawksNest Excel Worksheet Functions 3 December 12th 05 05:17 PM
How do I display list of tab names used in a workbook on a sheet tmottur Excel Worksheet Functions 2 December 1st 05 09:42 PM
Creating seperate sheet lists from larger list macquarl Excel Discussion (Misc queries) 1 October 19th 05 10:17 PM
Function to List an Excel Workbook's Sheet Names KymY Excel Discussion (Misc queries) 1 April 1st 05 10:47 AM
linking multiple sheets to a summary sheet greg g Excel Discussion (Misc queries) 1 December 16th 04 07:43 AM


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017