Looking to overwrite in a cell that contains formula and retain the formula

[Mar20bro]

I am creating an automated data-capture sheet for a forth coming exhibition.
All has gone well to the point now that there needs to be an option where an alternative address for a customer may be needed.
I have already written the coding for reading the initial input of customer data from one sheet, so that if the delivery and billing address are the same, a box is ticked and the form will auto-populate.

I now need to look to if the delivery and billing address are not the same as the initial address and be able to capture those details on the same form manually. I want to do this without overwriting the formula already in place.
Is there any way that this may be done.?

Many thanks in advance.

Martin

[PaulSP8]

It's hard to answer without knowing a bit more about it, but it sounds as though you might be able to use an IF somewhere.

Please Login or Register  to view this content.

If you can't get that to work for you then post back with a Sample Workbook - Use Anonymised / Sample data - And no doubt someone will try to help