Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a Row and cut and copy
I was not able to solve my problem yet. I am trying to find a ro
carrying certain data in a page and I want to cut this row and paste t another page. VLOOKUP finds any data at the search column and and copies the indexe value found at the place where the VLOOKUP required. With this I can copy all the row that found data exist. But my proble is also to delete the contents of the copied row or indidually th cells at their original place. When I use FIND Function it behaves similar to VLOOKUP and finds an copies the data where it is required, When I use the Search under th File Tab in Excell it finds and shows the row that I want to operate This is cool but it requires the search data to be typed (no cut an paste allowed). But I dont want to type it because I want to use thi operation, finding, cutting and pasting in a macro. Do I want something impossible ? If anyone can help I will be greatfull. Taner Kalka -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a Row and cut and copy
Using Find
If you copy the data, then you have its original location and you can then clear it as a separate step. -- Regards, Tom Ogilvy "Taner Kalkay " wrote in message ... I was not able to solve my problem yet. I am trying to find a row carrying certain data in a page and I want to cut this row and paste to another page. VLOOKUP finds any data at the search column and and copies the indexed value found at the place where the VLOOKUP required. With this I can copy all the row that found data exist. But my problem is also to delete the contents of the copied row or indidually the cells at their original place. When I use FIND Function it behaves similar to VLOOKUP and finds and copies the data where it is required, When I use the Search under the File Tab in Excell it finds and shows the row that I want to operate. This is cool but it requires the search data to be typed (no cut and paste allowed). But I dont want to type it because I want to use this operation, finding, cutting and pasting in a macro. Do I want something impossible ? If anyone can help I will be greatfull. Taner Kalkay --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a Row and cut and copy
See additional replies to your other post.
"Taner Kalkay <" wrote: I was not able to solve my problem yet. I am trying to find a row carrying certain data in a page and I want to cut this row and paste to another page. VLOOKUP finds any data at the search column and and copies the indexed value found at the place where the VLOOKUP required. With this I can copy all the row that found data exist. But my problem is also to delete the contents of the copied row or indidually the cells at their original place. When I use FIND Function it behaves similar to VLOOKUP and finds and copies the data where it is required, When I use the Search under the File Tab in Excell it finds and shows the row that I want to operate. This is cool but it requires the search data to be typed (no cut and paste allowed). But I dont want to type it because I want to use this operation, finding, cutting and pasting in a macro. Do I want something impossible ? If anyone can help I will be greatfull. Taner Kalkay --- Message posted from http://www.ExcelForum.com/ -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 Macro - Finding rows with data to copy | Excel Worksheet Functions | |||
copy-pasting a cell and finding lows and highs | Excel Discussion (Misc queries) | |||
Finding row, then copy paste (macro) | Excel Discussion (Misc queries) | |||
Finding Text To Copy To Another Worksheet | Excel Worksheet Functions | |||
EXCEL FILE a copy/a copy/a copy ....filename | New Users to Excel |