View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Trying to Merge 2 Workbooks

Anne

The "compare and merge" feature is for copies of shared workbooks only.

Both copies must be open each with a unique name.


Gord Dibben MS Excel MVP

On Tue, 18 Jul 2006 12:03:02 -0700, Anne wrote:

I am trying to merge 2 workbooks, again something I do on a daily basis
almost. I have followed the directions given by Excel Help, but I can not
click on the Compare and Merge Workbooks option on the Tools menu. Is there
another way that I can do this without having to move back and forth between
the 2 workbooks?