If you tell excel what to do in a macro, it'll do it.

Try recording a macro when you do it once manually and you'll see the code.
Then post back with more specific questions.

gjpcoach wrote:

Thanks Dave.

I was hoping for something more automated that didn't require me to
copy and past by hand. Am I wanting something beyond Excel's
capabilities?

thanks
Gillian

--
gjpcoach
------------------------------------------------------------------------
gjpcoach's Profile: http://www.excelforum.com/member.php...o&userid=31900
View this thread: http://www.excelforum.com/showthread...hreadid=516279

--

Dave Peterson