How to Return Result to a Different Cell

[BarbDenver]

I'm creating a demographic questionnaire. Client # 1 will have already input their address into a cell (D7). I want Client # 2 (the Partner of Client #1) to be able to simply type "Yes" into a cell (C21) if their address is the same as their partner's address. I want this address (from D7) to populate into E21.

But here's the problem: I can't put the formula into E21, because some Partners may want to input a different address into E21, which would overwrite the formula, thus making the whole scenario not work for the next user of the questionnaire.

I understand that VBA may be necessary, but I have NO CLUE how to write that. Please keep the directions simple and step-by-step.

I'd also appreciate any direction on the simplest-to-learn training on VBA for Dummies. Lol
Thank You!!

 

[braindiesel]

Put a formula in the cell and save it as a template... everytime someone opens it the formula is there but it can be written over if different

If that wont work for you make a change to where people put the Other address.

In your destination cell.
=If(<targetcell for same as> = "Yes", Cell with first address, cell with manually entered address)

 

[BarbDenver]

That was a much simpler solution, and looks just fine in the form. Thank you!
I'd still like a good resource for beginners to learn VBA.

 

[braindiesel]

Happy to help. Thanks for letting me know