editing multiple workbooks
 

I have about 100 workbooks that I need to "find and replace" the same
information on each one. Does Excel 2003 have a function to do that all at
once?

editing multiple workbooks
 

Hi dmlapins

With a macro you can do this
http://www.rondebruin.nl/copy4.htm


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm




"dmlapins" wrote in message ...
I have about 100 workbooks that I need to "find and replace" the same
information on each one. Does Excel 2003 have a function to do that all at
once?

editing multiple workbooks
 

Agent Ransack will do that but you can use VBA in Excel.

See Ron's reply.


Gord Dibben MS Excel MVP

On Sun, 31 May 2009 19:41:13 -0700, dmlapins
wrote:

I have about 100 workbooks that I need to "find and replace" the same
information on each one. Does Excel 2003 have a function to do that all at
once?