You have to write the code manually first to automate it, there is nothing
built in that will do this. If you look at the link there are instructions
for VBA there


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"gregory.barrett"
<gregory.barrett.25i3dy_1143752400.9062@excelfor um-nospam.com wrote in
message news:gregory.barrett.25i3dy_1143752400.9062@excelf orum-nospam.com...

I'm not to sure you understand what I'm trying to say. Although the 1st
link you gave me does help a bit. I don't want to do any of this
manually, it needs to be fully automatic.


--
gregory.barrett
------------------------------------------------------------------------
gregory.barrett's Profile:
http://www.excelforum.com/member.php...o&userid=32421
View this thread: http://www.excelforum.com/showthread...hreadid=527763