What I meant is: If you print your data from C1 and C2, let the user input it in A1 and A2. In C1, use this formula:

=A1

In C2, use this formula:

=IF(A2="",A1,A2)


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JKeef" wrote in message ...
| That is how my statements are set up, they auto populate from the customer
| bill to address into the customer site address- but if the address is
| different, they type in the same box over my function. In your scenario below
| it would be A2.
|
| Is there a way to enter for example cell c2 enter formula:
| =IF(a2<"",b2=a2,"") this way the actual cell for input (being b2) has no
| formula to type over.
|
| "Niek Otten" wrote:
|
| Use another cell for input. In the cell where it should be, enter a formula like
|
| =IF(A2="",A1,A2)
|
| With addresses in A1 and A2.
|
| --
| Kind regards,
|
| Niek Otten
| Microsoft MVP - Excel
|
| "JKeef" wrote in message ...
| |I have a document set up with IF statements to auto populate redundant
| | information. For example: the customer bill to address and the customer ship
| | to address. If the information is different they can type over my function-
| | but then it is gone. Is there a way to keep the function there without doing
| | save as each time?
|
|
|