Results 1 to 13 of 13

Extracting Data from Closed workbook

Threaded View

  1. 07-19-2016, 04:33 AM #1
    ueranda
    ueranda is offline
    Registered User
    Join Date
    07-19-2016
    Location
    Colombo
    MS-Off Ver
    2016
    Posts
    10

    Extracting Data from Closed workbook

    Dear All,

    I have master workbook and lot of data workbooks. I want to copy cell values from data workbooks to my master workbook. In master workbook I have 4 columns for file path, file name, sheet name and cell name and I want value in next column

    Untitled.png

    Please someone kindly help me to write formula for this. Thanks in advance

    Ueranda
    Last edited by ueranda; 07-20-2016 at 12:04 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Extracting values from latest closed workbook into current workbook?
    By biznez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2015, 09:34 PM
  2. extracting data from closed workbook
    By sark in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-20-2014, 01:18 AM
  3. Import data from closed workbook, export data to closed workbook - rename current workbook
    By UnreadSix in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2014, 12:38 PM
  4. [SOLVED] Copying data from a closed workbook into an open workbook ignoring excel filter?
    By reach78 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-17-2013, 12:31 AM
  5. Extracting data - vlookups with closed Sheets
    By Libster78 in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 03-16-2010, 12:02 PM
  6. Extracting Data - Open vs Closed
    By VBA Noob in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-14-2006, 04:09 PM
  7. [SOLVED] Extracting data from a closed workbook
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-07-2006, 10:50 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1