ok lol

Let me start again.

We use a spreadsheet to collect information from customers who require us to
attend to a property to do repairs. Occasionally we may come across a
property that our workers won't want to go back too for a specific reason
such as the property was messy or the customer was abusive. What i wanted was
somewhere we could put these addresses and the reason why we won't go back.
Then if the customer rings again and someone tries to put the address in then
a warning or an error will come up saying that the property is blacklisted
and why.

Is this possible?

James

"Atishoo" wrote:

Sorry am getting confused the addresses you are refferring to are house
addresses not web addresses? and you are wanting to allert the end user if
the address they enter is beyond 20miles of a base address?
If this is correct then you could use a sub to calculate distance to address
by post code / zip code!
Alternatively if you are creating a list of addresses you could check for
these using "find" when data is entered!
Is data entered by user form or directly into the cells of a worksheet?

"Bunnyboy" wrote:

The thing is there are no definate sites for us. We can go to any property
within 20 miles. I basically wanted a seperate sheet we could add these
addresses with the name and a reason why and a warning if any of those
addresses were entered on the main sheet.

"Lee Diggins" wrote:

Hi James

Would you want the record added even if you don't cover that site? If not,
you could do this using Data Validation using the List option, pointing to a
named range stored in a hidden worksheet containing the allowed sites.

Maybe have a read about Data Validation and post back if you need any
further clarification or if you don't feel it does not acheiev what you're
after.

Regards,

Lee

"Bunnyboy" wrote:

Hey

We currently use a spreadsheet on office 2003 to store a large amount of
personal information regarding property work. This spreadsheet is populated
by opertives who answer phone calls and enter the information onto it,
Recently we have found some sites that are no longer covered by us.

I was thinking if we could put a restriction on the spreadsheet so when an
operative tries to enter an address that is restricted then it will bring up
a warning to say that its restricted and a reason why.

Can this be done?

Hope to hear from you soon.

James
(Technology Officer)