+ Reply to Thread
Results 1 to 3 of 3

Macro VBA to copy and paste cells from one open workbook to another open workbook

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Macro VBA to copy and paste cells from one open workbook to another open workbook

    HI All! I'm still learning the ins and outs of VBA code, so I apologize if this is a simple thing to do...

    Everyday I need to copy and paste the information from a few cells in one workbook to the cells of another workbook. The file names of these workbooks will change on a daily basis, however where the information appears on the sheets will be consistent. Also, even though the workbook file names will change on a daily basis, the sheet names in those workbooks will always remain the same. Workbook one (where cell values should be copied from) will be Live Intro and workbook two (where cell values should be pasted to) the sheet name will be ForArtist. Is there a way to determine a set range of cells to copy from one open workbook to another set range of cells on another open workbook? I'd love a code that I could assign to a button to streamline everything. (I'm using Excel 2011 for Mac)

    Any and all help is greatly appreciated! Thanks!!
    Last edited by bloomingcarrot; 10-23-2014 at 06:31 PM. Reason: added more information

  2. #2
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,450

    Re: Macro VBA to copy and paste cells from one open workbook to another open workbook

    Try something like this:-

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Re: Macro VBA to copy and paste cells from one open workbook to another open workbook

    Thanks for your help. I am still really new and not sure how to input this. I tried inserting a new module and pasting this code and that didn't work. I tried adding Sub and End sub and then I got the error message, "Compile error: Expected: expression". Can you guide me on what I may be doing wrong?

    Thank you!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 05-02-2014, 12:19 PM
  2. Replies: 0
    Last Post: 07-12-2013, 05:29 PM
  3. macro to copy cells(Range) from an open Workbook to another open Workbook.
    By jbester in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-22-2013, 09:47 AM
  4. Macro to open a closed workbook and select copy cells into an open workbook
    By helloganesh in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2013, 02:00 PM
  5. [SOLVED] Macro to copy data from open workbook to next open line of new workbook
    By nhtodd in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2012, 09:42 PM

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