Hello Robert,

It appears you are creating a relational database. You could save
yourself headaches by using Pivot Tables or switch to Access. The
Direction you are heading now will make maintaing the code very
difficult later on. As you know, customers always want the program to
do something else. My choice would be the Pivot Tables.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=488081