ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i set up a list of names on a sheet frm various sheets in e (https://www.excelbanter.com/excel-discussion-misc-queries/67397-how-do-i-set-up-list-names-sheet-frm-various-sheets-e.html)

mcvities_69 January 25th 06 07:58 PM

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

exceluserforeman January 27th 06 02:51 AM

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



All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
ExcelBanter.com