+ Reply to Thread
Results 1 to 4 of 4

VBA Macro Code to Amalgamate Row Data from multiple Worksheets into Single Worksheet ?

  1. 10-14-2015, 08:40 AM #1
    stefan27
    stefan27 is offline
    Registered User
    Join Date
    10-03-2015
    Location
    Perth
    MS-Off Ver
    2013
    Posts
    13

    VBA Macro Code to Amalgamate Row Data from multiple Worksheets into Single Worksheet ?

    Scenario
    • I have Multiple worksheets with Row Data on ColA upto Col H

    Anyone care to share a VBA Macro Code to "Amalgamate" the ROW Data from Multiple Sheets into a Single Worksheet named "Complete' ?

    Thanks in Advance.
    Reply With QuoteRegister To Reply
  2. 10-14-2015, 09:20 AM #2
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: VBA Macro Code to Amalgamate Row Data from multiple Worksheets into Single Worksheet ?

    Perhaps this link may help.

    Consolidating Data from Multiple Worksheets into a Summary Worksheet in Excel
    Surround your VBA code with CODE tags e.g.;
    [CODE]your VBA code here[/CODE]
    The # button in the forum editor will apply CODE tags around your selected text.
    Reply With QuoteRegister To Reply
  3. 10-14-2015, 09:36 AM #3
    stefan27
    stefan27 is offline
    Registered User
    Join Date
    10-03-2015
    Location
    Perth
    MS-Off Ver
    2013
    Posts
    13

    Re: VBA Macro Code to Amalgamate Row Data from multiple Worksheets into Single Worksheet ?

    Great - the code is working fine !!

    Thanks for sharing !!
    Reply With QuoteRegister To Reply
  4. 10-14-2015, 09:44 AM #4
    AlphaFrog
    AlphaFrog is offline
    Forum Guru
    Join Date
    07-25-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9,653

    Re: VBA Macro Code to Amalgamate Row Data from multiple Worksheets into Single Worksheet ?

    You're welcome. Thanks for the feedback.
    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. Macro to copy data from multiple worksheet cells in to a single Master worksheet
    By thunt13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2015, 03:24 PM
  2. [SOLVED] Copy column data from multiple worksheets to single worksheet based on header criteria
    By nateaskins in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 03-21-2014, 10:42 AM
  3. [SOLVED] Pull data if there is any from a single column in multiple worksheets into a single sheet
    By bcas77 in forum Excel Programming / VBA / Macros
    Replies: 29
    Last Post: 07-11-2013, 01:22 PM
  4. VBA Code to amalgamate data from separate workbooks into a master workbook
    By scousemouse in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-16-2012, 05:35 AM
  5. How to import data from multiple worksheets to a single worksheet?
    By Darren80 in forum Excel General
    Replies: 3
    Last Post: 11-27-2011, 03:10 AM
  6. Combining and rearranging data records from multiple worksheets to a single worksheet
    By danb1985 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-14-2009, 09:57 PM
  7. Amalgamate Several Worksheets into one file thru Data import
    By M Imran Buhary in forum Excel General
    Replies: 0
    Last Post: 05-28-2006, 06:35 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