Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
row selection and cut + copy
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 -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
row selection and cut + copy
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 "Taner Kalkay " wrote in message ... I am new at this forum. I do not know if my problem displayed here or not. While programing in excel, I find a value with vlookup, I want to the further than this. I want to move the whole line to a an other page. I can do this in a long way carrying every cell individually. What I really want to do is to cut the row where I found with vlookup. If any body have any sugestion this will be great. Thankyou --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
row selection and cut + copy
Thank you for your kind sugession, but it did not work. May be becaus
the cell that I try to find is numeric -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
How to 'copy' a drop down box selection? | Excel Discussion (Misc queries) | |||
Copy Selection | Excel Discussion (Misc queries) | |||
Copy Selection to new sheet | Excel Programming | |||
Selection.Copy Destination:= | Excel Programming |