+ Reply to Thread
Results 1 to 3 of 3

Appending multiple sheets into one excluding header cells

  1. #1
    Registered User
    Join Date
    07-12-2013
    Location
    Ottawa
    MS-Off Ver
    Excel 2010
    Posts
    22

    Lightbulb Appending multiple sheets into one excluding header cells

    Hi,

    I have been having some trouble trying to get this macro to work properly. It does what I want in the sense that it appends multiple sheets together, however it also copy's the header row along with it. I would like to combine the sheets with only header cells (filters) in row 1, not each time a sheet is appended. Below is the code that I have been working with. I believe I am close but am missing the line of code that will make it happen.

    I have attached the workbook which requires combining of 5 sheets to 1 with only top row headers.

    Any help on this would be greatly appreciated.

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,295
    To stop the headers being copied every time you can change A1 to A2 here.
    Please Login or Register  to view this content.
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    09-24-2013
    Location
    Texas
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Appending multiple sheets into one excluding header cells

    This is working perfectly for me, except I need the headers (A1:Q1) from only the first sheet ("130520" in the original code) to be pasted in the new summary sheet. When I try to do this I get headers between the rows of different worCan you help me with that part? Been trying to modify the original code to no avail.

+ 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. Replies: 0
    Last Post: 04-19-2013, 05:50 PM
  2. Appending Multiple Excel Sheets
    By krizbomb in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-02-2013, 04:35 AM
  3. Copy specific cell from multiple sheets to summary - excluding some sheets
    By kabammi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-01-2012, 09:27 AM
  4. Appending student data from multiple sheets in chronological order on another sheet
    By StudentTeacher in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-22-2010, 10:53 AM
  5. Macro for Appending Data without Header to a database with header
    By tiang1209 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-30-2007, 04:38 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