Results 1 to 3 of 3

Thread: Macro to Create a Combined Sheet from Multiple Sheets

  1. #1
    Junior Member
    Join Date
    Sep 2015
    Posts
    8
    Rep Power
    0

    Macro to Create a Combined Sheet from Multiple Sheets

    I need some assistance building a macro for this scenario:

    I have multiple sheets. All sheets have the same headers from column A1:A7. The first row of data always starts at A8. The last row of data varies for each sheet, but never exceeds 5000 rows. There are 6 columns of data, from column A:F (Fund, Debit, Credit, Debit, Credit, Total).

    I would like a macro to create a "Combined" sheet that creates 7 columns with the following headers: Account #, Fund, Debit, Credit, Debit, Credit, Total. The Account # is not any of the source sheets. The Account # should be created by taking the left 4 characters of the Fund column (column A of the source sheets). Above column 3 (Debit) and 4 (Credit) there should be a header "Pre-Closing" and above column 5 (Debit) and 6 (Credit) there should be a header "Post-Closing." Below each of these headers are the data from each of the source sheets, below one another. The original source sheets should not be changed, all of this should is performed in the "Combined" sheet.
    Last edited by showtyme; 07-13-2017 at 08:48 PM.

  2. #2
    Junior Member
    Join Date
    Sep 2015
    Posts
    8
    Rep Power
    0
    Quote Originally Posted by showtyme View Post
    I need some assistance building a macro for this scenario:

    I have multiple sheets. All sheets have the same headers from column A1:A7. The first row of data always starts at A8. The last row of data varies for each sheet, but never exceeds 5000 rows. There are 6 columns of data, from column A:F (Fund, Debit, Credit, Debit, Credit, Total).

    I would like a macro to create a "Combined" sheet that creates 7 columns with the following headers: Account #, Fund, Debit, Credit, Debit, Credit, Total. The Account # is not any of the source sheets. The Account # should be created by taking the left 4 characters of the Fund column (column A of the source sheets). Above column 3 (Debit) and 4 (Credit) there should be a header "Pre-Closing" and above column 5 (Debit) and 6 (Credit) there should be a header "Post-Closing." Below each of these headers are the data from each of the source sheets, below one another. The original source sheets should not be changed, all of this should is performed in the "Combined" sheet.
    Anyone?

  3. #3
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    Better to post a sample workbook.
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)

Similar Threads

  1. Replies: 2
    Last Post: 02-27-2019, 05:35 PM
  2. Replies: 14
    Last Post: 09-07-2016, 01:24 AM
  3. Replies: 1
    Last Post: 09-21-2013, 11:28 AM
  4. Replies: 3
    Last Post: 05-14-2013, 03:25 PM
  5. Combine Columns From Multiple Sheets To One Sheet
    By Portucale in forum Excel Help
    Replies: 6
    Last Post: 04-24-2013, 09:18 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •