+ Reply to Thread
Results 1 to 3 of 3

Copy/Paste Macro from two different workbooks

  1. #1
    Registered User
    Join Date
    04-16-2012
    Location
    New England
    MS-Off Ver
    Excel 2007
    Posts
    13

    Copy/Paste Macro from two different workbooks

    Hey Guys,


    I'm still farily new to VBA.

    Was wondering how to do a copy and paste code from 2 different workbooks. situation as follows:

    every month, I have to copy and paste updated ledgers into this workbook that has 30 sheets of different products.

    each sheet within this workbook has monthly expenses( i.e. debits and credits) for the products.

    so the one workbook has has all of the product sheets, and the other workbook has the updated monthly product info.

    so instead of copying and pasting each updated product sheet to each excel product sheet monthly,

    can anyone provide some assistance of how to paste the updated monthly data onto the master worksheet product tab

    by using the last row used. Greatly appreciated, thanks.

    Darell

  2. #2
    Registered User
    Join Date
    04-16-2012
    Location
    New England
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Copy/Paste Macro from two different workbooks

    In addition, I'm trying to combine the last row macro along with a copy/paste macro between 2 workbooks. Any help would be greatly apperciated!

  3. #3
    Registered User
    Join Date
    04-16-2012
    Location
    New England
    MS-Off Ver
    Excel 2007
    Posts
    13

    Re: Copy/Paste Macro from two different workbooks

    Hey Guys, thanks in advance, but I Just solved this myself. Will post resolution soon and thanks again.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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