Windows("Feedmaster##.xls").Activate
Sheets("Sheet2").Select
Range("C5:D5").Select
Application.CutCopyMode = False
Selection.Copy
Windows("Feedmaster##.xls").Activate
Sheets("Sheet1").Select
Cells(Rows.Count, "C").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
Hy Guys
In my data the column B in sheet1, i want to make it still fill with certain date. but when the column C fill with macro. I want to change the date in column B same with the data in Sheet2. How I manage the macro?
i change the macro from C5:D5 to D5:C5, but the data still paste from colomn C in Sheet1.
Thanks
Bookmarks