News, tips, advice, support for Windows, Office, PCs & more. Tech help. No bull. We're community supported by donations from our Plus Members, and proud of it
Home icon Home icon Home icon Email icon RSS icon
  • Merging data of several sheets into a single sheet using VBA.

    Posted on shazzad.arla Comment on the AskWoody Lounge

    Home Forums AskWoody support Productivity software by function MS Excel and spreadsheet help Merging data of several sheets into a single sheet using VBA.

    This topic contains 6 replies, has 2 voices, and was last updated by  shazzad.arla 1 month, 3 weeks ago.

    • Author
      Posts
    • #1911754 Reply

      shazzad.arla
      AskWoody Lounger

      I have an excel file with several sales data of different months. I am in need of a VBA that will combine or merge the sheets of the single excel file that will allow to see the sales of each months in a single sheet as Summary.

      For better understanding, excel file is attached here.

      Thanks.

      • This topic was modified 2 months, 3 weeks ago by  PKCano.
      • This topic was modified 2 months, 3 weeks ago by  shazzad.arla.
      Attachments:
    • #1911936 Reply

      zeddy
      AskWoody_MVP

      Hi Shazzad

      No need for VBA.

      You could just use Excel’s SUMIF formulas to get the Summary data you want.

      see attached file.Merge-data-in-a-single-sheet-zeddy1

      zeddy

      Excel Extempore Prompt Dept

       

      Attachments:
      1 user thanked author for this post.
      • #1912764 Reply

        shazzad.arla
        AskWoody Lounger

        Hi Zeddy,

        Thanks for your response.

        Fully agreed with your solution. but this was just a sample file. I have some some other file where retailers sale will be accumulated. On that case, I have to handle around 95 to 100 sheets. And applying formula for the each sheet will be too much tough. So I was preferring the VBA that will copy the common column of all sheets in the summary sheet and then quantity of each sheet will be accumulated in one after one so that I can analyze the trend in a single sheet.

        Could you please help me sorting the issue?

        Regards

        Shazzad

         

        • #1913055 Reply

          zeddy
          AskWoody_MVP

          Hi Shazzad

          We can easily use VBA to merge data from many sheets into a single [Merged Data] sheet.
          But we need more information from you.
          For example, do all the data sheets you want to merge into one sheet have the same data layout?
          Are all the data column headings the same?
          Are the data column headings in the same sequence?

          If you have 90-100 sheets to merge are they for the same Year?
          Can we have some more info on the nature of the sheet names.
          Are they Divisions? Regions? Countries? Suppliers? Outlets? Customers?
          It would help us to know so we can work out what your [Summary] sheet needs to look like.

          zeddy
          Excel Senior-Hyphenation-Specialist-In-Charge

    • #1953364 Reply

      shazzad.arla
      AskWoody Lounger

      Hi Shazzad

      No need for VBA.

      You could just use Excel’s SUMIF formulas to get the Summary data you want.

      see attached file.Merge-data-in-a-single-sheet-zeddy1

      zeddy

      Excel Extempore Prompt Dept

       

      Hi Zeddy,

      Thanks. Sorry for late response. I was away from work for some personal issues.

      i have followed your suggested way since it was easy and simple.

      Again Thanks.

       

      Regards

      Shazzad

      1 user thanked author for this post.
    • #1953826 Reply

      zeddy
      AskWoody_MVP

      Hi Shazzad

      Let me be the first to thank you for getting back to us.

      It is always nice to hear we have helped out.

      zeddy

      Excel WiFi Calling Me To Hurry Up

      1 user thanked author for this post.
      • #1953903 Reply

        shazzad.arla
        AskWoody Lounger

        Zeddy,

        I am highly pleased and honored 🙂

         

        Best Regards

        Shazzad

         

    Please follow the -Lounge Rules- no personal attacks, no swearing, and politics/religion are relegated to the Rants forum.

    Reply To: Merging data of several sheets into a single sheet using VBA.

    You can use BBCodes to format your content.
    Your account can't use Advanced BBCodes, they will be stripped before saving.