+ Reply to Thread
Results 1 to 5 of 5

Combining info (prbably easy to fix - i'm just rubbish)

  1. #1
    Registered User
    Join Date
    09-28-2008
    Location
    UK
    MS-Off Ver
    MS 365 Apps for Enterprise
    Posts
    64

    Combining info (prbably easy to fix - i'm just rubbish)

    Hi all,

    I have a spreadsheet with data in a number of sheets in columns A-P. I'm looking to combine all of the data into 1 sheet (the data may change on a daily basis). The headings within each sheet are identical and so this should not cause an issue, but the number of rows in the inititial sheets may change; with my lack of skills this means a combined set of columns which have empty rows [I would be doing a simple =sheet1...], but empty rows are not any use to me!

    I hope someone can point me in the right direction to fix this.

  2. #2
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Combining info (prbably easy to fix - i'm just rubbish)

    Is it that you want to combine those sheets into a SUMMARY sheet or something?
    If so, best way to go would be with a VBA macro.
    Let us know if this is acceptable for you.
    Regards
    Pierre Leclerc
    _______________________________________________________

    If you like the help you got,
    Click on the STAR "Add reputation" icon at the bottom.

  3. #3
    Registered User
    Join Date
    09-28-2008
    Location
    UK
    MS-Off Ver
    MS 365 Apps for Enterprise
    Posts
    64

    Re: Combining info (prbably easy to fix - i'm just rubbish)

    VBA is fine with me. Essentially the resultant sheet would have the same contents as the data sheets, just combined. The issue is sometimes sheet 1 will have 200 rows and other times 327 rows, as with the other sheets.

    I considered using iferror and vlookup combinations but I think the nested ifs are too limited.

    Thanks for looking.

  4. #4
    Forum Expert p24leclerc's Avatar
    Join Date
    07-05-2010
    Location
    Québec
    MS-Off Ver
    Excel 2021
    Posts
    2,081

    Re: Combining info (prbably easy to fix - i'm just rubbish)

    Try this macro which will copy data from any sheet not having the word "Master" in its name into the "Master" sheet. It copies columns A to P and it checks how many rows are used in each sheet and copy only those ones.

    I have also attached a working workbook for you.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-28-2008
    Location
    UK
    MS-Off Ver
    MS 365 Apps for Enterprise
    Posts
    64

    Re: Combining info (prbably easy to fix - i'm just rubbish)

    Great p24leclerc,

    Thanks for taking the time to do that for me, much appreciated.

+ 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. [SOLVED] Formula to access info on sheet 2 (EASY)
    By floydian in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-27-2013, 12:50 PM
  2. Rubbish HTML
    By Kyle123 in forum Suggestions for Improvement
    Replies: 2
    Last Post: 09-14-2012, 07:24 AM
  3. Combining multiple formulas. I think it is easy.
    By Janstoop in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-05-2011, 07:04 AM
  4. Stripping The Rubbish
    By Programmin'Pete in forum Excel General
    Replies: 4
    Last Post: 11-04-2009, 01:11 AM
  5. combining rows and deleting easy for u experts
    By bamamike in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-19-2005, 10:05 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