+ Reply to Thread
Results 1 to 6 of 6

Open spreadsheet and copy certain information into another spreadsheet.

  1. #1
    Registered User
    Join Date
    12-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    51

    Question Open spreadsheet and copy certain information into another spreadsheet.

    Hi all,

    I am trying to write a macro that opens a spreadsheet and copies certain information to another spreadsheet. However its a little more complex in that I would like my macro to copy certain cells based on what I have in my second spreadsheet. For example, I would like to copy the value of the cell next to the cell labeled 'number of orders' & paste it into the cell next to the cell that says 'number of orders' in my second spreadsheet. I would like to do this for about 80 items.

    Thanks in advance


  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,777

    Re: Open spreadsheet and copy certain information into another spreadsheet.

    Not only confusedaboutVBA but also lacking information!!!!
    Could you attach a workbook with before and after explained?
    It should be the same layout but without sensitive info.

  3. #3
    Registered User
    Join Date
    12-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Open spreadsheet and copy certain information into another spreadsheet.

    Ok.

    Please find attached working examples.

    Basically I want to copy data from Book1 to Book2. So for example, I would like my macro to look up the 'number of cars' in Book1 & paste the value into Book2 in the cell next to the cell that contains 'number of cars'. So to illustrate that example, the macro will copy '12' from B2 in Book1 and paste it into B2 of Book2.Book1 Example.xlsxBook2.xlsx

  4. #4
    Registered User
    Join Date
    07-10-2013
    Location
    Mumbai, India
    MS-Off Ver
    Excel 2007
    Posts
    40

    Re: Open spreadsheet and copy certain information into another spreadsheet.

    try this code,

    Please Login or Register  to view this content.

  5. #5
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,777

    Re: Open spreadsheet and copy certain information into another spreadsheet.

    See if this works.
    You have to have both workbooks open and run the macro from the example workbook.
    Attached Files Attached Files

  6. #6
    Registered User
    Join Date
    12-02-2012
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    51

    Re: Open spreadsheet and copy certain information into another spreadsheet.

    Thanks guys
    Last edited by ConfusedaboutVBA; 07-23-2013 at 11:08 PM.

+ 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: 2
    Last Post: 08-29-2012, 11:00 AM
  2. Replies: 0
    Last Post: 07-25-2012, 02:54 PM
  3. Open all xls Files in folder & Copy To 1 Spreadsheet
    By Tyler_Durden in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 04-12-2011, 05:46 AM
  4. Importing Information From Spreadsheet To Spreadsheet
    By Jon Thurston in forum Excel General
    Replies: 11
    Last Post: 08-27-2010, 01:46 PM
  5. Replies: 2
    Last Post: 05-19-2010, 09:25 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