Ok i want to send all information without use copy and paste, because i want
to do automatic. i don't if can do that.

"AFSSkier" wrote:

> If I understand correctly, Goto Sheet1, click Select All button (located in
> the top left corner), Copy the Values from Sheet1. Goto Sheet2, right click,
> Paste Special. Then
> you can delete Sheet1. If this is not what you are looking for, please be
> more specific with your question.
>
> "Francisco" wrote:
>
> > 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?
> > > >
> > > >