+ Reply to Thread
Results 1 to 3 of 3

Code to Extract data from multiple workbooks and Multiple sheet

  1. #1
    Forum Contributor
    Join Date
    12-11-2014
    Location
    dubai
    MS-Off Ver
    2010
    Posts
    139

    Code to Extract data from multiple workbooks and Multiple sheet

    Hi Guys

    I have 5 Excel workbooks having 3 sheets each.All book containing same format and sheet name.
    I need to compile all the 5 sheets in one master sheet of all matching sheet names between master and source sheets.

    All my source sheet is linked to another file, what i need in master sheet is only formats and values and not the formulas.

    Ex; Source 1 sheet1 has rows 4 to 10, source 2 sheet 1 has rows 4 to 15.
    Expected Result: master woprkbook sheet 1should have rows 4 to 10 from sheet 1 of source 1 and rows 11 to 25 from source 2 of sheet 1 and so on..

    Is it possible?

    Thanks for any help

  2. #2
    Valued Forum Contributor Parth007's Avatar
    Join Date
    12-01-2014
    Location
    Banglore
    MS-Off Ver
    2010
    Posts
    879

    Re: Code to Extract data from multiple workbooks and Multiple sheet

    Regards
    Parth

    I appreciate your feedback. Hit * if u Like.
    Rules - http://www.excelforum.com/forum-rule...rum-rules.html

  3. #3
    Forum Contributor
    Join Date
    12-11-2014
    Location
    dubai
    MS-Off Ver
    2010
    Posts
    139

    Re: Code to Extract data from multiple workbooks and Multiple sheet

    Hi Parth

    I did go thru this before, none matches my requirement

+ 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. Vba code to Extract data from multiple sheet
    By Masa1989 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-05-2015, 01:51 AM
  2. Extract Data from Multiple Workbooks and insert in New Sheet
    By LondonSmudge in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2014, 05:06 AM
  3. Macro To Extract Data From Multiple Workbooks To A Single Sheet - Excel
    By Joshdm0716 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2013, 12:12 PM
  4. [SOLVED] How to code a macro to extract data from multiple sheets into one sheet?
    By likeabottle in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-21-2013, 04:51 PM
  5. Replies: 3
    Last Post: 01-05-2013, 02:20 AM
  6. Extract Data from Multiple Workbooks to One Sheet
    By jketcher in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-01-2012, 04:41 PM
  7. Macro to extract data from multiple workbooks to a single sheet
    By Phil73 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-23-2011, 05:15 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1