Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make a list of names and then break it down into smaller li
i am trying to build a worksheet for my sons cubscout group. I want to put
all the names on the first sheet with some of the achevements. I want to be able to link them with the individual ranks. there are about 20 kids in each class. the main page has abaout 100 names on it. Is there a way I can link the cells by the childs name and not by the cell number? I am not wanting to link down the list to the point that every time we have a new member i have to add the lodgic and formulas to each cell,sheet, and achevement. i would like to link everything to the childs name if that is posible. i hope i have giving enough info for someone to answer what im am looking for. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to make a list of names and then break it down into smaller li
would you provide example and the result you want?
wouldn't Vlookup or Index and Match do what you want? try the Excel Help to get the idea of these works -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis Am not a greek but an ordinary user trying to assist another "mysticmike13" wrote: i am trying to build a worksheet for my sons cubscout group. I want to put all the names on the first sheet with some of the achevements. I want to be able to link them with the individual ranks. there are about 20 kids in each class. the main page has abaout 100 names on it. Is there a way I can link the cells by the childs name and not by the cell number? I am not wanting to link down the list to the point that every time we have a new member i have to add the lodgic and formulas to each cell,sheet, and achevement. i would like to link everything to the childs name if that is posible. i hope i have giving enough info for someone to answer what im am looking for. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET | Excel Discussion (Misc queries) | |||
how do I make a list of the names of worksheets in an excel workb | Excel Discussion (Misc queries) | |||
how do i make a drop down list of selected names no repeatition | Excel Worksheet Functions | |||
How do I break a csv file into smaller size for export? | New Users to Excel | |||
How to make a chart from a list of names? | Charts and Charting in Excel |