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 3 replies, has 2 voices, and was last updated by  zeddy 3 weeks, 4 days ago.

    • Author
    • #1911754 Reply

      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.


      • This topic was modified 3 weeks, 5 days ago by  PKCano.
      • This topic was modified 3 weeks, 5 days ago by  shazzad.arla.
    • #1911936 Reply


      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


      Excel Extempore Prompt Dept


      • #1912764 Reply

        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?




        • #1913055 Reply


          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.

          Excel Senior-Hyphenation-Specialist-In-Charge

    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.