editing multiple workbooks

[dmlapins]

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?

 

[Ron de Bruin]

Hi dmlapins

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

 

[Gord Dibben]

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

See Ron's reply.


Gord Dibben MS Excel MVP