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.
Bookmarks