There are several ways of solving the problem:
1. Write a macro. It would ask "Ship to same as bill to?" If yes, then fill
in the ship to address.

2. Have the data entry person copy and paste the bill to address.

3. Create a second set of fields for the Ship to address. Use the formula:
=if(a1="yes",b1,c1)
A1 is the "Same as bill to?" response.
B1 is the Bill to address
C1 is the data entered Ship to address

Regards,
Fred.

"callmark1" wrote in message
...
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