Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help collating data from multiple worksheets
Hi, I have a work book. The first sheet is basically a list of names. Each susequent page has severall dropdown boxes using that list. Is it possible that each time a name from that list is selected, a number appears on the first page in the column next to the name (the number being the number of times that name is used?) When I finished compiling the list on the first page, I selecte dthem all and named them. On subsequent sheets i used a data validation to make the drop down box and names available. All the subsuquent sheets have a number of fields that use the list, i'd just like to get the first page to show how often each is selected. Any help much appreciated. -- Mediaid ------------------------------------------------------------------------ Mediaid's Profile: http://www.excelforum.com/member.php...fo&userid=9653 View this thread: http://www.excelforum.com/showthread...hreadid=573751 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
How do I link lots of data in multiple worksheets | Excel Worksheet Functions | |||
Data Validation drop down for multiple worksheets | Excel Worksheet Functions | |||
Finding common Data in multiple worksheets | Excel Discussion (Misc queries) | |||
How to extract data from multiple worksheets.. | Excel Discussion (Misc queries) |