Help collating data from multiple worksheets

M

Mediaid

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 i
possible that each time a name from that list is selected, a numbe
appears on the first page in the column next to the name (the numbe
being the number of times that name is used?)

When I finished compiling the list on the first page, I selecte dthe
all and named them.

On subsequent sheets i used a data validation to make the drop down bo
and names available. All the subsuquent sheets have a number of field
that use the list, i'd just like to get the first page to show ho
often each is selected.

Any help much appreciated
 
Top