Desire that is made automaticamente because I have much information in sheet1
can you help me?

"AFSSkier" wrote:

Copy the Value from Sheet1. Goto Sheet2, right click, Paste Special. Then
you can delete Sheet1. or If the Value in Sheet2 is a VLOOKUP Value of
Sheet1. Copy the Cell Value in Sheet2, right click, Paste Special back into
the same Cell.

"Francisco" wrote:

I have a value in a cell in first sheet i try to put the value in another
sheet by reference if i delete the value in the first sheet i lost the value
of the cell. How can keep the value in the new sheet?