What code would I use to transfer data between columns in the excel file described below?
I have a very large excel spread sheet where I need to transfer text from Column B to Column D in the case where there is no date (blank cell or Null) in the same row in column D and there is text in column D (same row). Please see the attached excel spread sheet which contains two sheets - Example and desired result. The rows where the text from column B should be copied and pasted in the same row in Column D are highlighted in the sample sheet . Thanks EEtest.xlsx