LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 37
Default Reminder that cells are not filled in

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average only if all cells filled chuck72352 Excel Discussion (Misc queries) 4 July 8th 09 10:40 PM
Average only if ALL cells filled. chuck72352[_3_] Excel Worksheet Functions 2 July 8th 09 06:57 PM
adding reminder on worksheets or cells yahya Excel Discussion (Misc queries) 1 November 8th 07 08:15 PM
Filled cells dont appear as filled SMILLS Excel Discussion (Misc queries) 6 October 18th 07 05:28 PM
Percentage of filled cells Carla Bradley Excel Worksheet Functions 1 January 7th 05 05:31 PM


All times are GMT +1. The time now is 10:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"