SOLVED

Populate a blank cell with data

Copper Contributor

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 all 

 

Wonder if any knows So I Have job number in A2 and date in C3 which the formaula is there so when date entered as below the row changes from blank to fill the row

 

what i want to ask is that when a date entered is there a way or formula to copy A2 (JobNumber) to say populate in cell A4 

 

AndyK1865_0-1676385943224.png

 

AndyK1865_1-1676386083443.png

 

4 Replies
best response confirmed by AndyK1865 (Copper Contributor)
Solution

@AndyK1865 

In A4:

 

=IF(C2="", "", A2)

thank you

Hello @Hans Vogelaar 

 

further question if i wanted to Populate that process into a new excel workbook what formula would i use 

@AndyK1865 

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)

1 best response

Accepted Solutions
best response confirmed by AndyK1865 (Copper Contributor)
Solution

@AndyK1865 

In A4:

 

=IF(C2="", "", A2)

View solution in original post