ExcelBanter - Autofill data in specific blank cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Autofill data in specific blank cells (https://www.excelbanter.com/excel-worksheet-functions/23272-autofill-data-specific-blank-cells.html)

Mr. G.

Autofill data in specific blank cells

It it possible to have specific empty cell(s) display data until it is
populated? For example, I would like the words "Other Trans", "Other LME",
and "Other Ent" to always appear in cells F27, F35 & F43, respectively,
while empty and revert back to this data when emptied.

All times are GMT +1. The time now is 12:23 PM.