Reminder that cells are not filled in

[Jonno]

Hi,

I would like for my work sheet to state that information has not been
entered when i save.

Titles are
A1 = name A2 = number A3 = Address

and the data is in the cell below i.e B1 = John .....etc

I would like a box stating if information has not been filled in the cell
when i save.
There could be 1 or many bits of information missing and i would like a list
showing them all (just the missing parts).

Then if possible a button inside that window which would change all those
cells to 'TBA' if theres no information in the cell.

Are any of these possible???

 

[Jonno]

Hi Smartin,

This works great thank you very much!!!!!!!!!