Thank you. I am not sure that is the solution. I just realized that this
issue is very similar to a "ship-to" address vs. "bill-to" address issue. If
my data entry person types in a 'ship-to" address, it seems there should be
some way to automatically enter the same date in the event that the "bill-to"
address is the same (75% of the time) by inserting a collumn along the way
that simply asks for Same? "Yes" or "No".

Or to NOT enter the same info but rather be allowed to enter different info
when the "bill-to" address is different. I hope that clarifies and thanks
again.

"Steven" wrote:

I am not sure that I understand your question, but this may help
If your data is in column A, then enter the following formula in
column B
=IF(COUNTIF(a:a,a1)1,"yes","no")
and drag down