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@excelforum-nospam.com> wrote in
message news:gregory.barrett.25i3dy_1143752400.9062@excelforum-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
>