Retaining addresses from sheet 2 in main sheet after deleting sheet 2

[xtremekyter]

My goal is to have 1 sheet in a spreadsheet that contains all my information so I can import it into postal software.
The problem is there are a series of columns in sheet 2 that have a formula that brings them into the main sheet.
When I delete sheet 2 all the addresses that were brought from sheet 2 into the main sheet disappear.
I have added another column in sheet 1 with the intention of copying and pasting the info as values but as soon as I add a column the information I need disappears.
Ideas? Thanks, Jeff

 

[Joe4]

I have added another column in sheet 1 with the intention of copying and pasting the info as values but as soon as I add a column the information I need disappears.

Why do you need another column?
You can Copy/Paste Special/Values the data over top of itself, to convert all formulas to hard-coded values.

 

[xtremekyter]

Why do you need another column?
You can Copy/Paste Special/Values the data over top of itself, to convert all formulas to hard-coded values.

I did not know that. Thanks.

 

[Joe4]

You are welcome!
Glad I was able to help.