Merge Workbooks command not active

S

Stilla

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?
 
D

dq

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top