Need how-to or example for data consolidation
 

I have two similar worksheets that I am trying to consolidate based on the
column that represents the date. I just don't know how to use the feature or
how to fomat the formulas. Also,where do you indicate where to put the
resulting consolidated data?

Need how-to or example for data consolidation
 

J --
Start in the target worksheet in the upper left-hand corner of where the
consolidated data will end up. Click DataConsolidation, and a little Window
will open. You'll have to enter the various ranges from which you'll be
consolidating data. (It might be easier to name them first, so you don't
have to switch back to various pages to select the ranges.)
Once you've got all the source ranges entered, it will probably be best for
you to select header column and row. Then just click to do it.

HTH

"jtroper" wrote:

I have two similar worksheets that I am trying to consolidate based on the
column that represents the date. I just don't know how to use the feature or
how to fomat the formulas. Also,where do you indicate where to put the
resulting consolidated data?