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