Like I said thanks for the suggestion.

I tend to use workspaces to open multiple files all at one time. With
them, you can open one file and it will open all the related files. It
comes in handy when applying macros particularily in this instance
where I am using links that run 4 levels deep accross 60+ files.

I really need to get this out of excel and into a SQL envoirnment w/
reporting services. Now if I can just find where I placed all that
spare time I used to have.


--
charles banks
------------------------------------------------------------------------
charles banks's Profile: http://www.excelforum.com/member.php...o&userid=30517
View this thread: http://www.excelforum.com/showthread...hreadid=501701