Consolidating data with same headers from multiple worksheets into master worksheet

[moonstex]

Hi Guys,

PLease help me out. I need a VBA code or any other solution to produce the following.

Basically, I have two datasets where the same information is stored for different countries, and I need to merge them into one quite often.


Dataset 1 example

	A	B	C	D
1	Country	Type	Sub-type	Amount
2	USA	Fruit	Apple	3
3	Canada	Fruit	Orange	5
4	Sweden	Vegetable	Tomato	1
5	Norway	fruit	Pear	4
6	0	0	0	0
7	0	0	0	0
8	0	0	0	0
9	0	0	0	0
10	0	0	0	0
11	0	0	0	0

<tbody>
</tbody>

For every row where there is no data there is a 0

Dataset 2 example

	A	B	C	D
1	Country	Type	Sub-type	Amount
2	Azerbaijan	Vegetable	Cucumber	4
3	India	Fruit	Orange	1
4	Thailand	Vegetable	Tomato	1
5	Bangladesh	Fruit	Apple	2
6	0	0	0	0
7	0	0	0	0
8	0	0	0	0

<tbody>
</tbody>

Exactly same headers and same data but for different set of countries


Consolidated Dataset (this is what I'm trying to automate)

	A	B	C	D
1	Country	Type	Sub-Type	Amount
2	USA	Fruit	Apple	3
3	Canada	Fruit	Orange	5
4	Sweden	Vegetable	Tomato	1
5	Norway	Fruit	Pear	4
6	Azerbaijan	Vegetable	Cucumber	4
7	India	Fruit	Orange	1
8	Thailand	VEgetable	Tomato	1
9	Bangladesh	Fruit	Apple	2

<tbody>
</tbody>

Basically, I want to copy paste all data from 2 datasets, right after each other without taking into account 0's. Zeros are basically blanks


Please help!

Thanks. S

 

[vanthinh3101]

Thank you, but I do not have permissions to post attachments.

You can give me via email.
My mail is vanthinhnguyenneu310188@gmail.com

 

[mbpressley]

Thank you!

 

[oldbrewer]

Be sure to publish ultimate solution on here as going offline is not allowed - this rule is applied vigorously.

 

[mbpressley]

Hello,

I am new to this. Is it ok to email and then publish what I receive, or not?

Thanks!

 

[oldbrewer]

Mods - please help mbpressley