I use a "Mapping" sheet in my budget workbook that needs to be update
on a regular basis. I have over 100 workbooks and all of them have th
sheet called "Mapping".

The 100 files are in one Folder but under different sub-folders.

Is there an easy way to update the "Mapping" sheet in all th file
rather than copying one by one.

Thanks a lot for your help

Jij

--
jij
-----------------------------------------------------------------------
jijy's Profile: http://www.excelforum.com/member.php...fo&userid=1504
View this thread: http://www.excelforum.com/showthread.php?threadid=55568