Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert column, move data with VBA
Ok here is what I have:
Columns with several rows of names followed by several rows of numbers, I need to cut the numbers out, insert a new column and paste them in the new column. I have tried several things but can't quite get it. I have many columns to do this with so I need to loop through a range thanks!! Fred BEFO A B --------------------- Fred Amy Dave Jan Sam Bev Doug Carol 1 1 2 2 3 3 4 4 5 5 6 6 AFTER: A B C D ------------------------------------------ Fred 1 Amy 1 Dave 2 Jan 2 Sam 3 Bev 3 Doug 4 Carol 4 5 5 6 6 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to move the cursor to column A after entering data column F | New Users to Excel | |||
How can I cut data from one column and move it to another. | New Users to Excel | |||
Insert sheet, move to end, rename with cell data. | Excel Discussion (Misc queries) | |||
insert column move object | Excel Discussion (Misc queries) | |||
create macro to move label type data to column data | Excel Programming |