| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Editing Data in Multiple Worksheets/Workbooks | Excel Discussion (Misc queries) | |||
| Shared Workbooks display 'locked for editing' when they are not | Excel Discussion (Misc queries) | |||
| Updating Workbooks from multiple links Workbooks | Excel Worksheet Functions | |||
| editing and analysis of cells in multiple worksheets AND workbooks | Excel Discussion (Misc queries) | |||
| multiple cell editing | Excel Worksheet Functions | |||
Linear Mode
