row selection and cut + copy

T

Taner Kalkay

I am new at this forum. I do not know if my problem displayed here o
not.

While programing in excel, I find a value with vlookup, I want to th
further than this. I want to move the whole line to a an other page.
can do this in a long way carrying every cell individually. What
really want to do is to cut the row where I found with vlookup.

If any body have any sugestion this will be great.

Thankyo
 
M

Mike Fogleman

I suggest you use Find method instead of VLookUp. The Find will actually
select the cell where it is found. From there you can cut/paste the entire
row to somewhere else.
Mike F
 
T

Taner Kalkay

Thank you for your kind sugession, but it did not work. May be becaus
the cell that I try to find is numeric
 
Top