I have a macro that copies data from Column D of Sheet2 and pastes values in Column B of Sheet1.
Sub CommandButton1_Click() Sheets("Sheet2").Columns("D").Copy Sheets("Sheet1").Range("B1") End Sub
However, I want that before pasting the values, the macro should insert a new column so that existing values in Column B of Sheet1 are shifted to the right and values are pasted in the empty Col. B of Sheet1
Alternately, if someone could suggest a different solution to copy values from Cells D1 to D10 of Sheet2 and insert these as a new column B in Sheet1 (after shifting existing columns to the right).
Please note that all the above will happen in background automatically and the Macro will be run from some other sheet so the Active Sheet need not be Sheet1 or Sheet2