Envision two rows, one up top and one below it. The cell up top is blank but the one below has 9/24/12. How can I create a function that will make the top one copy the value of the cell below it if it is empty?
P.S. I'm not great with scripts.
|
Envision two rows, one up top and one below it. The cell up top is blank but the one below has 9/24/12. How can I create a function that will make the top one copy the value of the cell below it if it is empty? P.S. I'm not great with scripts. |
||||
|
|
|
Assuming that cell A1 is the top row and A2 is the next row, put the following formula in cell A1.
|
|||
|
|