+ Reply to Thread
Results 1 to 2 of 2

How can i improve this code? Looping to merge multiple documents into one sheet.

  1. #1
    Registered User
    Join Date
    04-15-2016
    Location
    England
    MS-Off Ver
    2010
    Posts
    14

    How can i improve this code? Looping to merge multiple documents into one sheet.

    Hey,

    I would say i'm still a beginner moving into intermediate skill level. I was hoping someone could show me where i could improve this code i have written that grabs data from 4 different sheets and pastes it into one sheet:

    Please Login or Register  to view this content.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: How can i improve this code? Looping to merge multiple documents into one sheet.

    You could improve it by using Power Query instead. Faster performance and easier to modify / audit.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

+ 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. Mail Merge Excel Info into Multiple Different Word Documents
    By hilarymorton2003 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2016, 12:28 AM
  2. Improve code for sending info to multiple sheet
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-19-2015, 03:12 AM
  3. [SOLVED] VBA code to merge multiple sheet with multiple tabs into one workbook in different tabs
    By Jagdev in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-06-2015, 07:42 AM
  4. Merge data from different files - how to improve code
    By Masun in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-22-2014, 03:20 AM
  5. How to improve the performance of a looping UDF
    By johnnycanuck in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-03-2011, 01:39 PM
  6. Error with VBA code Copying cells to a closed workbook, template sheet, documents and
    By Libster78 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-30-2010, 12:31 PM
  7. Merge data in multiple documents
    By danjones in forum Excel General
    Replies: 0
    Last Post: 10-15-2007, 03:04 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