Need help with excel vba

Question

xspJody I have two worksheets 1- copy 2- dest
Firstly, I have to delete 1 and 5 column and then copy data from 2nd column to 4 th column and paste in dest sheet next to available column (means next to last column used).

rolf-42 · Answer

Hello&nbsp;Suma_shankarMaybe you have more chances to get your answer in the Excel community here:https://techcommunity.microsoft.com/t5/excel/ct-p/Excel_CatGood luckCheersRolf#MCT #LearnWithRolf #TheCloud42&nbsp;

xspjody · Answer

Suma_shankar&nbsp;&nbsp;If you're still looking for a solution you could try thisSub MySub()
    ActiveCell.Columns("A:E").EntireColumn.Select
    Selection.Copy
    Windows("Book2").Activate
    ActiveCell.Range("A1").Select
    Selection.End(xlToRight).Select
    ActiveCell.Offset(0, 1).Columns("A:A").EntireColumn.Select
    Selection.Insert Shift:=xlToRight
End Sub

Forum Discussion

Need help with excel vba

Share