Hi Anne:

Thanks for the fast reply and for the ideas. The example that you
supplied seems to go the other way, that is, to take data from one
sheet and distribute it to others. I'm not sure how I could modify the
code to do the opposite.

You're probably right about Access being the answer, but I've never
used it and wouldn't even know where to begin. Perhaps its time for me
to take an Access basics class so that I have some new tools to use :)


Thanks Again,
Chris


--
pilotdata
------------------------------------------------------------------------
pilotdata's Profile: http://www.excelforum.com/member.php...o&userid=28664
View this thread: http://www.excelforum.com/showthread...hreadid=483371