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)