Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copying information and calculations from one sheet to another she | Excel Worksheet Functions | |||
How do I display list of tab names used in a workbook on a sheet | Excel Worksheet Functions | |||
Creating seperate sheet lists from larger list | Excel Discussion (Misc queries) | |||
Function to List an Excel Workbook's Sheet Names | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |