View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stilla
 
Posts: n/a
Default Merging Excel Files - Option "grayed out"

I'm experimenting with merging files in preparation for a potentially big
merging project.
I set up 4 test files. One is the "merge into" file. I've entered data into
4 rows and 3 columns in each of the other three files. The columns are
identically named in all 4 files. All four files are in one folder.

I can't find the "merge" command!! Under tools, there is an option to
"Compare & Merge Workbooks" but it's greyed out and cannot be selected!

What am I doing wrong?

Thanks so much.