Merge Workbooks command not active
 

Hi and thanks in advance. In anticipation of having to merge a couple of
worksheets (I will have a choice about whether these will be in different
workbooks), I created two "TEST" worksheets in two diff. workbooks..filling
in just a few cells, but naming the columns the same.

I looked under the tools menu. The "Compare and Merge Workbooks" command is
not active... any ideas?

Merge Workbooks command not active
 

Depends on what you exactly mean with consolidating. You could copy/
paste the data and use a pivot to get your report. Otherwise look up
the Data/Consolidate function in Help. It might be the answer to your
problem

DQ