Feb 14 2023 06:51 AM - edited Feb 15 2023 02:53 AM
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
Feb 14 2023 07:00 AM
SolutionFeb 15 2023 02:50 AM
Hello @Hans Vogelaar
further question if i wanted to Populate that process into a new excel workbook what formula would i use
Feb 15 2023 03:04 AM
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)
Feb 14 2023 07:00 AM
Solution