Combine Tabs into One Master Sheet

  • I have the following code; however, I need it to be tweaked.


    1. I would like the unique tab names to appear in Column A (currently unused).
    2. Paste ALL rows, even blank from b2:q61.


    All sheets are the same with the exception of the code


  • Re: Combine Tabs into One Master Sheet


    Hi zxox


    Welcome to Ozgrid :)


    You can't do this the way you are attempting. You are copying the entire row which means it has to be pasted in Col A of your summary tab. What is the shape of each of your Input tabs. I would suggest you set the sheet out the way the attached workbook is created. No need to test for row 3 either. Just use a simple tool called a header. The following code goes with the attached file.



    Take care


    Smallman

  • Re: Combine Tabs into One Master Sheet


    Alternative way


  • Re: Combine Tabs into One Master Sheet


    Thank you for the warm welcome and the replies. Neither of these worked for my data. :(


    I am essentially trying to copy and paste all data rows from B11:Q61 into one sheet. I have about 100 files (each with at least 5 tabs) that are in this same format and would like to get them into one master file.


    Maybe you have a better way to accomplish this? Thanks again for your help! :)

  • Re: Combine Tabs into One Master Sheet


    Quote

    ...Neither of these worked for my data


    Then please upload a sample workbook that contains a small sample of your data, suitably anonymised if necessary. You've had 2 possible solutions based on your description of your data, now it's time to actually see what your data actually looks like.

  • Re: Combine Tabs into One Master Sheet


    I can't see any point in doing this.


    This code will copy each sheet into the summary sheet, howver you need to make each sheet's form uniform, i.e. use the same range for the form


  • Re: Combine Tabs into One Master Sheet


    Quote from royUK;658351

    I can't see any point in doing this.

    I completely understand this statement! HA! :) But, trust me this helps immensely! A MILLION THANK YOUS FOR WORKING CODE! :yourock:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!