Excel: I need to copy some cells to a second workbook if "signal cell" is not blank

I have 2 workbooks, each with only 1 sheet.

First workbook, (Houses.xlsx) has details about specific houses, 1 row per house. Column E indicates if/when I need to visit the house. This column is mostly blank; at any time, most homes are not due a visit. When a visit is needed, I usually just enter a planned visit date into into the cell in Column E. I erase it later, after the visit. So: cells in Column E are usually blank. If not, I want to copy some but not all of the cells in that row to a row in another workbook.

This other workbook (CalData.csv) is formatted as a CSV file to ease export to my Google Calendar. This file has only some of the columns from the larger file. Google calendar can usefully be told the name of the property and the address, for example, but has no use for the age of the house, or its size.

How might I enter into a cell in the csv workbook "if cell B3 in workbook Houses.xlsx contains a date, copy that date here"?

Also, how can I then enter in some other cells in the same row "if cell B3 in workbook Houses.xlsx contains a date, copy the contents of cell H3 here"?

It might not matter, but I'll add that the 2 books use different headers for the same data. The "master" sheet might say "Home Address" in cell D1, but the CSV column must, because Google Calendar says so, be headed "Location"

Recent Questions...