Macro to find cells with value and replacing with value of adjacent cell : I want to search for all cells in a column that are 0000000000. If a cell is equal to 000000000, I want to replace the cell with the value of the cell to the left (previous column, same row) help please!
