Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving XL Data over By one Column (*Same Row)
Hello
We have some data currently in Range("D:L") on a spreadsheet We are trying to move the data over by one column to Range("E:N") via macro We have tried everything. XL does delete to the right A B C D E.... 1 x x x x x 'Befor 2 x x x x x 'Afte This should really be simple...but it is just not clicking for us. Please help Sub CutpasteOneRow( For each cell in selectio cell.cut cell. offset (0,1 nex End Su o activesheet.range("D2:D200" if cell.value = "X" the with selectio ..cut destiation:=.offset(0,1 end wit end i Thanks Roz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving XL Data over By one Column (*Same Row)
Columns(4).Insert
-- Vasant "rozb" wrote in message ... Hello, We have some data currently in Range("D:L") on a spreadsheet. We are trying to move the data over by one column to Range("E:N") via macro. We have tried everything. XL does delete to the right. A B C D E..... 1 x x x x x 'Before 2 x x x x x 'After This should really be simple...but it is just not clicking for us. Please help. Sub CutpasteOneRow() For each cell in selection cell.cut cell. offset (0,1) next End Sub or activesheet.range("D2:D200") if cell.value = "X" then with selection .cut destiation:=.offset(0,1) end with end if Thanks, Rozb |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving XL Data over By one Column (*Same Row)
Thank you.
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving XL Data over By one Column (*Same Row)
The easiest way would be to insert a new column at D
Columns("D:D").Inser -- Message posted from http://www.ExcelForum.com |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving XL Data over By one Column (*Same Row)
ub InsertExtraBlankCell(
ActiveSheet.Range("d2:d200").Selec rng = Selection.Rows.Coun ActiveCell.Offset(0, 0).Selec Application.ScreenUpdating = Fals For i = 1 To rn If ActiveCell.Value = "Reg:" The Selection.Insert Shift:=xlToRigh Els ActiveCell.Offset(1, 0).Selec End I Next Application.ScreenUpdating = Tru End Su We were working backwards..so we inserted instead. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Moving XL Data over By one Column (*Same Row)
Thank you.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Column data formula | Excel Worksheet Functions | |||
Moving data from one column to another | Excel Discussion (Misc queries) | |||
Moving scattered cell data to new column? | Excel Worksheet Functions | |||
Moving data from multiple cells to one column | Excel Discussion (Misc queries) | |||
moving data within a column | Excel Worksheet Functions |