Merging and combining two reports
 

I have two sets of data with some duplication between them and want to
combine the two to generate one report.

Eg
In Dept 1 they use Product 1, 2, and 4
In Dept 2 they use product 2, 3 and 4

I want to combine thes to show Depts 1 and 2's usage of all products. Can
it be done?

Merging and combining two reports
 

try using the Consolidate function in Excel
Post back if you need further assisatnce

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis









"Matthew G" wrote:

I have two sets of data with some duplication between them and want to
combine the two to generate one report.

Eg
In Dept 1 they use Product 1, 2, and 4
In Dept 2 they use product 2, 3 and 4

I want to combine thes to show Depts 1 and 2's usage of all products. Can
it be done?

Merging and combining two reports
 

I have tried the consolidate function but it consolidates the same row from
each sheet regardless of the product description.

"xlm" wrote:

try using the Consolidate function in Excel
Post back if you need further assisatnce

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis









"Matthew G" wrote:

I have two sets of data with some duplication between them and want to
combine the two to generate one report.

Eg
In Dept 1 they use Product 1, 2, and 4
In Dept 2 they use product 2, 3 and 4

I want to combine thes to show Depts 1 and 2's usage of all products. Can
it be done?

Merging and combining two reports
 

would you post your samples and the expected result.
or can you post your files to a free file hosting and let me know
where to pick it up.

I will see what I can do.

--
Appreciate that you click on the Yes button below if this posting was
helpful.

Thank You

cheers, francis









"Matthew G" wrote:

I have tried the consolidate function but it consolidates the same row from
each sheet regardless of the product description.

"xlm" wrote:

try using the Consolidate function in Excel
Post back if you need further assisatnce

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis









"Matthew G" wrote:

I have two sets of data with some duplication between them and want to
combine the two to generate one report.

Eg
In Dept 1 they use Product 1, 2, and 4
In Dept 2 they use product 2, 3 and 4

I want to combine thes to show Depts 1 and 2's usage of all products. Can
it be done?