Hi all,

I need what I think will be a pretty simple macro:

I have two columns with email addresses (home and work), in column D and column G. (4 and 7, numerically)

If the cell in column D is empty, can I copy the value from the same row in column G?

Original:

| | | home@aol.com | | | work@aol.com |
| | | | | | work2@cox.com |

Result:
| | | home@aol.com | | | work@aol.com |
| | | work@cox.com | | | work@cox.com |

Thanks.