Results 1 to 3 of 3

Copy certain data from closed workbook

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Copy certain data from closed workbook

    Hello:

    Please refer to attached files.
    i have uploaded 2 files, Master.xls and ABC.xls

    I would like a VB Macro in Master.xls (Sheet1).
    I need to import certain data from closed file name in Cell A2 and directory in cell D2.

    (ABC.xls is closed worked book attached).

    I need to copy data AM2:AN30 from ABC.xls and paste at F2 of Master.xls
    Then i need to copy data AW2:AW 30 from ABC.xls and paste at J2 of Master.xls

    Let me know if you have any questions.
    Thanks.
    Riz
    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. Replies: 0
    Last Post: 03-27-2014, 12:38 PM
  2. [SOLVED] Code to copy data from a closed workbook and paste in active workbook using named range.
    By paullie1912 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-28-2014, 02:38 AM
  3. Copy Data from Closed workbook (bbb.xls) to Open workbook (aaa.xls) (Part 2)
    By alexnkc in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2013, 02:06 AM
  4. Copy data from closed workbook to open workbook
    By amandeepsharma89 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-27-2012, 11:20 AM
  5. VBA to copy data from closed workbook to open workbook
    By Anil2007 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-27-2011, 12:30 PM

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