I see you've cross-posted this at:
http://answers.microsoft.com/en-us/o...c-68b599b31bf5
where you've already been pointed to a tutorial I wrote on the use of field coding for this. That may or may not meet your needs - which is why I asked for further info before pointing you in that direction.
For cross-posting etiquette, please see:
http://www.excelguru.ca/node/7