Yes, you may record a macro to do what you want. It probably ends up looking
something like this.

You will find what you have recorded by opening Visual Basic (Tools, Macro,
Visiual Basic Editor) and then look for the recorded macro in Modules and in
Module1 etc

You can also copy my code into one a module if you wish. If you do make sure
that the sheet names in the code correspond to what is in your workbook.

Sub FindData1ReplaceData2()

Sheets("Sheet1").Select
Cells.Replace What:="Data1", Replacement:="Data2", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

Sheets("Sheet2").Select
Cells.Replace What:="Data1", Replacement:="Data2", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

Sheets("Sheet3").Select
Cells.Replace What:="Data1", Replacement:="Data2", LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False

End Sub



--
Regards,

Martin


"Louise" wrote:

Hi all

Can anybody help?

I have created very basic macros in Excel but have no knowledge whatsoever
of Visual Basic. Is it possible to create a macro that will search for a
particular word(s) in the whole of an Excel workbook and replace it with
another? Would I simply go into Record mode and select Edit, Find & Replace
and enter the text? How would this be applied to the whole workbook rather
than the active sheet?

Any help would be appreciated.

Thank you

Louise