+ Reply to Thread
Results 1 to 6 of 6

Vba code to Extract data from multiple sheet

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

    Vba code to Extract data from multiple sheet

    Hi Guys

    I have this code which extract the data from multiple sheet and compiles it onto master sheet.
    It checks for matching sheet names between source and destination and accordingly copies it in compiled sheet.
    This code copies everything as it is..how do i modify this code to copy the source sheet and paste only format and values and not the formulas?

    Please Login or Register  to view this content.
    Thanks for any assistance

  2. #2
    Forum Expert
    Join Date
    02-22-2013
    Location
    London, UK
    MS-Off Ver
    Office 365
    Posts
    1,218

    Re: Vba code to Extract data from multiple sheet

    Replace the line,
    Please Login or Register  to view this content.
    with
    Please Login or Register  to view this content.

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

    Re: Vba code to Extract data from multiple sheet

    Thanks berlan...

    Its copying only values and not cell formats.
    I have 8 source files, all the source files are linked to another files.whenever i run the macro, it keeps asking to update the links and after some time excel crashes and reopens.
    Whenever i have only two files it copies only cell value without format..what could be the problem?

    All source files has 500 rows of data with formula linked to another file...following is my code
    Please Login or Register  to view this content.
    Thanks for your help

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

    Re: Vba code to Extract data from multiple sheet

    Has any one come across the same problem?Can this code be modified?
    Last edited by Masa1989; 08-04-2015 at 01:20 AM.

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

    Re: Vba code to Extract data from multiple sheet

    Hi
    How to modify this to get formats and values ..this code doesnt get me the format of the cells (like cell color , borders etc)..

    Please Login or Register  to view this content.
    Thanks for any help.

  6. #6
    Valued Forum Contributor
    Join Date
    11-15-2008
    Location
    ph
    MS-Off Ver
    2007/2010/2016
    Posts
    479

    Re: Vba code to Extract data from multiple sheet

    Hi -

    try
    Please Login or Register  to view this content.
    event

+ 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. Code/formula to extract data from one cell that has multiple selections
    By benjy99 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-30-2015, 06:33 AM
  2. Replies: 3
    Last Post: 12-18-2014, 10:27 AM
  3. 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
  4. [SOLVED] Extract multiple sheets data into one sheet
    By jun22 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-20-2014, 09:58 AM
  5. VBA code to extract data from multiple webpages to excel
    By satishphalke in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2014, 02:16 AM
  6. [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
  7. 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

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