Macro to copy the contents of a cell based on certain condition

**Newbiee** · 11-05-2009, 10:59 PM

Hi guys,
i am trying to create a macro which will copy the contents of a column if the corresponding cell in the another column is filled.
For example: if A1 is non empty and C1 is empty, the contents of the cell C1 should be copied to P1. This condition has to be applied to the entire sheet and all the column A contents should be listed in the column P.
[I have enclosed the excel describing the condition]

I will remain grateful if some one could help.
Thanks in advance,
Preeths

**mewingkitty** · 11-05-2009, 11:04 PM

Your stated conditions do not match your provided workbook. Makes it difficult to go from there...

A1 is non empty and C1 is NON empty, and yet you have it copied to P1.

mew.

**Newbiee** · 11-09-2009, 01:29 AM

Hi,
I am sorry about that

. Please check the updated sample excel sheet.

The condition is as following.
if A1 is non empty and C1 is empty, the contents of the cell A1 should be copied to P1. This condition has to be applied to the entire sheet and all the column A contents should be listed in the column P.

Thanks a lot in advance,
Preeths