| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macro for replacing data
Hi
If I want to replace 0 with a name above zero, is there a way to do it? I have about 350 names to replace, where the zero is under the name row. I got the zero when tried to get a sub total of hours and amount columns (not shown). thank you and Happy New Year. 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 SANTIAGO 8 Total 0 14 LECOURS 14 LECOURS 14 LECOURS 14 LECOURS 14 LECOURS 14 LECOURS 14 LECOURS 14 LECOURS 14 LECOURS 14 Total 0 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 BRUNO 25 Total 0 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help replacing dropped zeros | Excel Discussion (Misc queries) | |||
| Macro replacing links | Excel Discussion (Misc queries) | |||
| replacing macro? | Excel Discussion (Misc queries) | |||
| Macro help:replacing figures | Excel Discussion (Misc queries) | |||
| In a Macro replacing $x with ($x + i) gives x+1 not $x+1 as expe. | New Users to Excel | |||
Threaded Mode
