cgannm
08-10-2009, 09:42 AM
Hi, I am seeking your assistance with code that would find empty cells in column A based on cell value equal zero then copy/reference the most previous cell with value not equal zero.
For example, A1:A5 has values 1,2,empty cell, empty cell, 3. A3,A4 are empty cells, based on zero value, it then copies A2 in A3 and A4. Result would be: 1,2,2,2,3.
Thanks,
Anna
For example, A1:A5 has values 1,2,empty cell, empty cell, 3. A3,A4 are empty cells, based on zero value, it then copies A2 in A3 and A4. Result would be: 1,2,2,2,3.
Thanks,
Anna