I need to do a find and replace

[splendidmonkey]

Basically I have an excel sheet with 10 columns one column is called Closure Status with the Values 0 and 1. 1 needs to be changed to Closed and 0 to Open I also have two other columns that are called Closure Date and Verify Date these columns contain dates however on open rows they contain “NULL” this needs to be blank could anyone help me with a Macro

 

[beniez]

Unless I'm missing something, these are basically find and replace activities (highlight the relevant column and find "1", replace with "Closed" etc). If you need to do this repeatedly, then record your actions as a macro.

Ben

 

[splendidmonkey]

It would be however A Macro would be nice seeing as updates are received over 20 times a day

 

[MadForIt]

Try the following

Sub Test()
Range("a:a&quot.Replace 1, "Closed", lookat:=xlWhole
Range("a:a&quot.Replace 0, "Open", lookat:=xlWhole
Range("c:c&quot.Replace "NULL", "", lookat:=xlWhole
End Sub

 

[splendidmonkey]

You got it cheers