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

Topic

New Reply

[PKCano]

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 5 years, 9 months ago by PKCano.
• This topic was modified 5 years, 9 months ago by shazzad.arla.

Reply | Quote

Replies

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

 

1 user thanked author for this post.

shazzad.arla

Reply | Quote

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

 

Reply | Quote

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

Reply | Quote

zeddy wrote:

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.

zeddy

Reply | Quote