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: 30
Default prevent a cell from having data add with out another celled filled

Hello, I am using Excel 2003, I have two cells that require information, one
is the "item number" and the other one is "quanity" I don't want to be able
to add anything to the quanity cell until the "item number" cell is filled
out. Is there a way to prevent this, I looked in validations and wasn't sure
if any of the choose would work.

Thank you in advance.
 
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
How do I prevent data from being entered into a particular cell? Bryan Excel Discussion (Misc queries) 1 April 7th 07 01:24 AM
MACRO: Catching only filled cell data sumit Excel Discussion (Misc queries) 1 November 24th 06 12:28 PM
prevent data entry into cell? keif Excel Worksheet Functions 3 April 3rd 06 08:37 PM
Checking if a cell is filled up with data xpucto Excel Discussion (Misc queries) 1 May 26th 05 10:17 AM
How to prevent cursor from moving behind filled cells Spreadsheet Slave Excel Discussion (Misc queries) 1 April 4th 05 01:43 PM


All times are GMT +1. The time now is 12:39 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"