I want to Copy value from Sheet 1 (A1) to the Remaining Cells of Column D in Sheet 2
Macro recording is not working. Appreciate if someone helps me to write proper code
Sheets("Sheet1").Select Range("A1").Select Selection.Copy Sheets("Sheet2").Select ActiveCell.Offset(0, -1).Range("A1").Select Selection.End(xlDown).Select ActiveCell.Offset(0, 1).Range("A1").Select Range(Selection, Selection.End(xlUp)).Select ActiveCell.Offset(-1, 0).Range("A1:A2").Select ActiveCell.Activate ActiveSheet.Paste Application.CutCopyMode = False
Bookmarks