+ Reply to Thread
Results 1 to 5 of 5

extracting rows including data from another workbook

Hybrid View

  1. 08-12-2013, 04:09 AM #1
    roofi
    roofi is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    167

    extracting rows including data from another workbook

    Hello experts,
    I always gained much guidance from this forum. its a great forum.
    now i have a problem. I have two workbooks
    1.Master 2.Extract.
    Master contains my data sheets and extract is a report based on data extractd from Master file.
    please suggest a vba/macro if i want to generate extract.

    sample files attached for prusal.
    note: extract file includes detailed question.
    regards
    Attached Files Attached Files
    Last edited by roofi; 08-12-2013 at 04:15 AM.
    Abdul Rouf Roofi
    Reply With QuoteRegister To Reply
  2. 08-12-2013, 05:48 AM #2
    lotuxel
    lotuxel is offline
    Registered User
    Join Date
    11-14-2010
    Location
    Macau
    MS-Off Ver
    Excel 2003
    Posts
    66

    Re: extracting rows including data from another workbook

    Hi,
    I put the code in extract file as attached.

    open 2 files and click the button at extract file
    good luck!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 08-12-2013, 06:34 AM #3
    roofi
    roofi is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    167

    Re: extracting rows including data from another workbook

    Dear Lotuxel
    Thank you for response.
    but your function is not working. please review it.

    thanks
    regards
    Reply With QuoteRegister To Reply
  4. 08-13-2013, 02:44 AM #4
    lotuxel
    lotuxel is offline
    Registered User
    Join Date
    11-14-2010
    Location
    Macau
    MS-Off Ver
    Excel 2003
    Posts
    66

    Re: extracting rows including data from another workbook

    Hi,
    sorry the file saved without macro.
    Pleae find the attached.
    You should opened both file run button from extract file
    good luck!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 08-15-2013, 06:04 AM #5
    roofi
    roofi is offline
    Forum Contributor
    Join Date
    06-07-2013
    Location
    Pakistan
    MS-Off Ver
    Excel 2013
    Posts
    167

    Re: extracting rows including data from another workbook

    Dear Lotuxel
    Thanks for correction. it is working now. i need serial number in column A. please review.
    regards
    Last edited by roofi; 08-16-2013 at 05:56 AM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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] how to insert rows including data from another sheet in same workbook
    By roofi in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-05-2013, 04:10 AM
  2. How to convert duplicated rows into single rows extracting some data from deleted rows
    By darvin in forum Excel General
    Replies: 6
    Last Post: 08-18-2012, 05:00 AM
  3. Extracting data from multiple workbook in folder into main workbook
    By Julesdude in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2010, 11:25 AM
  4. [SOLVED] Get number of rows that data uses, including blank rows
    By Denham Coote in forum Excel General
    Replies: 5
    Last Post: 08-22-2006, 09:10 AM
  5. [SOLVED] Get number of rows that data takes up, including blank rows
    By Denham Coote in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2006, 04:20 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