Macro to copy the contents of a cell based on certain condition
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
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.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
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
Last edited by Newbiee; 11-09-2009 at 12:38 AM. Reason: Updated
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks