Linking numeric data to another spreadsheet

Without automating this in VB, you could use something like a second column that tested for a street name, something like:

=IF(OR(A1="",SheetA!B1<>""),"","Please enter address details in SheetA Row "& ROW())

and Protect this column from update.

You can also use Conditional Format to test if B1 now has text to colour A1 and B1 Red etc.

hth
---

Originally Posted by Jeda_zelda

I have a spreadsheet with several tab, the first tab consisting of the numberic data for example. One of the field requires # of building. When the user enters the number of building in this field I would like them to be prompted to enter a stree #, Street Address associated with that job # on another sheet. Please help!!!!