Macro needed for multiple Find and Replace in Excel 2010

[litwinj]

NEW to the writing of a macro in excel. I need a macro to find all instances of 05000 in Column G and replace the current number zero (all instances of it) in Column H with .015. thanks

[gsnidow]

Are you saying that you want to replace all instances of 0 with .015 where the cell value = 05000? So, in all cells in column H where the value = 05000, your proposed value would be .0155.015.015.015? That's how I'm reading your description of what you want.

Greg

[litwinj]

No. There is a value of 0 in a cell in column H where 05000 is in a cell in column G. so column H should read .015 instead of 0 when 05000 is in column G.

example

10358053 12.02
1004426 5.96
05000 0 **** this needs to be .015 instead of 0
0623 0.078
10358053 12.02
10358536 9.11
05000 0 **** this needs to be .015 instead of 0

Thanks

[gsnidow]

Try this. Note, the code only changes values of 0 to .015. So, for example, you could have 05000 in G, and 1 in H, and the code will not change the 1 to .015.

Please Login or Register  to view this content.

Greg

[JOHN H. DAVIS]

Another:

Please Login or Register  to view this content.

[litwinj]

thank you Greg that worked