Forum Discussion
Solved
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 ...
Hello HansVogelaar
further question if i wanted to Populate that process into a new excel workbook what formula would i use
Let's say the cells A2 and C2 are on a sheet named Data Sheet in a workbook named MyBook.xlsx.
You can use the following formula in a cell on another sheet in the same workbook:
=IF('Data Sheet'!C2="", "", 'Data Sheet'!A2)
And in a cell in a different workbook:
=IF('[MyBook.xlsx]Data Sheet'!C2="", "", '[MyBook.xlsx]Data Sheet'!A2)