Populate a blank cell with data

Thank you for the replies on the =IF(C2="", "", A2) further question to the excel world what formula would i need if i want to transfer the outcome to a seperate worksheet ( new worksheet )   Hi ...