| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Data Move
I have gropus of data that are imported.
Heading Phone # Part Name & # etc etc Heading Phone # Part Name & # etc etc Heading Phone # Part Name & # etc etc Pattern continues for over 100 pages. Now I want the cell "Part Name & #" to be selected and moved up to an empty cell to the right of the cell "Heading". What from a code standpoint would that look like in Visual Basic within a macro? I want ALL of the groupings done in this way. They are all imported in the same patterns, so if there is some way to select all cells with "Part Name & #" have them move up two spaces and over 5 or 6 cells then paste, that would work. Make sense??? THANKS!!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I move this data? | New Users to Excel | |||
| Move data | Excel Worksheet Functions | |||
| 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) | |||
| create macro to move label type data to column data | Excel Programming | |||
Threaded Mode
