+ Reply to Thread
Results 1 to 2 of 2

Transfer data fron one workbook to another using macro

  1. #1
    Registered User
    Join Date
    06-10-2010
    Location
    Atlanta, GA
    MS-Off Ver
    Excel 2007
    Posts
    70

    Transfer data fron one workbook to another using macro

    ok so I have 2 excel workbooks. WB1 and WB2 with 10 sheets each. WB1 is a report that comes in every month with new information about sales.
    1st report will contain info about january
    2nd one will contain info from january and february
    3rd one will contain info from january,february and march and so on...
    What I want to do is transfer Information from WB 1 to WB 2. The thing is that WB 1 is updated every month, so thats one problem. WB 1 and WB 2 have the same structure, so WB2 is a workbook with the variables but no numbers. One way to do it is maybe pick a variable in column 1 of WB1 and somehow take whole row and transfer it to WB2, but i dont know how to do that. I NEED TO DO IT WITH MACRO.
    I hope someone can help me.
    Thanks.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Transfer data fron one workbook to another using macro

    Nachousa, please take a few minutes to read the forum rules before posting again. I've closed your duplicate posts in two other forums.
    Entia non sunt multiplicanda sine necessitate

+ 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