Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version


Just for information, you can also get the result without macro or formula, using the DataConsolidate menu.

image description

  • Choose the function (here Product)
  • Select and successively add the ranges to be added to the consolidation
  • Set the "target"
  • Options: set the basis on which consolidation is done (here names in the rows)

The only constraint is that the column headers must be identical between all the sheets to be consolidated. I have renamed Name1 to Name in Sheet2.