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)

Your going to need a list of the restricted addresses or some identifiable
feature that they all have in common.

"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)

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)