Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find and Move Data
I've got column A with a data type of text. I'm trying to create a macro
that will find certain text ("Open Time") within column A then cut and paste the row where "Open Time" exists into a new row. For example, let's say "Open Time" is in cell A27. I want to find row 27 and cut and paste this row of information into say row 49. The trouble is "Open Time" can appear in different rows each time. Many thanks if you can help with the writing of this macro! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find Matching Text In Col A move to Col B | Excel Worksheet Functions | |||
Find text and copy and move row containing it | Excel Discussion (Misc queries) | |||
Macro - Find a value and then move down | Excel Discussion (Misc queries) | |||
Macro to move data to different column based on data in another co | Excel Discussion (Misc queries) | |||
enter data in cell which will start macro to move data to sheet2 | Excel Discussion (Misc queries) |