Results 1 to 3 of 3

Copy Paste using Macro

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-20-2022
    Location
    Indonesia
    MS-Off Ver
    Excel 2016
    Posts
    118

    Lightbulb Copy Paste using Macro

    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
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Copy/Paste via a Macro - How do I get it to paste into next empy cell?
    By RecordMan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-12-2021, 11:06 PM
  2. Convert Copy/Paste VBA to Macro without Copy/Paste
    By NewYears1978 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 08-22-2018, 01:21 PM
  3. Replies: 0
    Last Post: 01-13-2016, 08:50 PM
  4. [SOLVED] Simple copy and paste macro- Paste special help needed.
    By hernancrespo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2012, 07:02 AM
  5. 2 Macro's: only vertical copy/paste action and copy-paste 14 columns to the right.
    By vdongen in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-08-2010, 10:34 AM
  6. [SOLVED] Copy and Paste macro needs to paste to a changing cell reference
    By loulou in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-24-2005, 07:06 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1