software

I'm experimenting with merging files in preparation for a potentially big
merging project.
I set up 4 test files. One is the quot;merge intoquot; 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 quot;mergequot; command!! Under tools, there is an option to
quot;Compare amp; Merge Workbooksquot; but it's greyed out and cannot be selected!

What am I doing wrong?

Thanks so much.From Excel Help:

Requirements for merging Both workbooks must meet the following
requirements:

a.. Be copies of the same workbook, which must have been a shared
workbook.
b.. Have different file names.
c.. Either not have passwords, or both have the same password.
d.. Have change tracking in effect continuously from when the copies were
made.
e.. Keep change history back at least as far as the date when the copies
were made.
For example, if the change history is being kept in the workbooks for 30
days, and the copies were made 45 days ago, you can no longer merge the
workbooks.

Plan ahead for later merging When you turn on change tracking but aren't
sure when you'll merge the workbooks, set a large number of days for the
history, up to the maximum of 32,767 days.

Merge changes manually If the workbooks still won't merge, you can
incorporate the information from one workbook into another manually, by
copying and pasting from one workbook to another.quot;Stillaquot; gt; wrote in message
...
gt; I'm experimenting with merging files in preparation for a potentially big
gt; merging project.
gt; I set up 4 test files. One is the quot;merge intoquot; file. I've entered data
into
gt; 4 rows and 3 columns in each of the other three files. The columns are
gt; identically named in all 4 files. All four files are in one folder.
gt;
gt; I can't find the quot;mergequot; command!! Under tools, there is an option to
gt; quot;Compare amp; Merge Workbooksquot; but it's greyed out and cannot be selected!
gt;
gt; What am I doing wrong?
gt;
gt; Thanks so much.
gt;
gt;
gt;
gt;
Carlos - Thank You!
I tried it and it worked. I also discovered that this is no what I want to
do after all. The merge function quot;replacesquot; data in the same rows. I need
to quot;joinquot;.

If one file has 2 rows filled in, the other file has 5 rows filled in. My
masterfile should have 7 rows filled in. I know it's easy to do this
manually, but there will be 30 of these individual files to open.

1) is there a way to automate this?
2) after the first quot;joiningquot; of data - is there a way of subsequently only
quot;bringing inquot; newly added data from the source files

Thank You - I really appreciate the help.

quot;CarlosAntennaquot; wrote:

gt; From Excel Help:
gt;
gt; Requirements for merging Both workbooks must meet the following
gt; requirements:
gt;
gt; a.. Be copies of the same workbook, which must have been a shared
gt; workbook.
gt; b.. Have different file names.
gt; c.. Either not have passwords, or both have the same password.
gt; d.. Have change tracking in effect continuously from when the copies were
gt; made.
gt; e.. Keep change history back at least as far as the date when the copies
gt; were made.
gt; For example, if the change history is being kept in the workbooks for 30
gt; days, and the copies were made 45 days ago, you can no longer merge the
gt; workbooks.
gt;
gt; Plan ahead for later merging When you turn on change tracking but aren't
gt; sure when you'll merge the workbooks, set a large number of days for the
gt; history, up to the maximum of 32,767 days.
gt;
gt; Merge changes manually If the workbooks still won't merge, you can
gt; incorporate the information from one workbook into another manually, by
gt; copying and pasting from one workbook to another.
gt;
gt;
gt;
gt;
gt;
gt; quot;Stillaquot; gt; wrote in message
gt; ...
gt; gt; I'm experimenting with merging files in preparation for a potentially big
gt; gt; merging project.
gt; gt; I set up 4 test files. One is the quot;merge intoquot; file. I've entered data
gt; into
gt; gt; 4 rows and 3 columns in each of the other three files. The columns are
gt; gt; identically named in all 4 files. All four files are in one folder.
gt; gt;
gt; gt; I can't find the quot;mergequot; command!! Under tools, there is an option to
gt; gt; quot;Compare amp; Merge Workbooksquot; but it's greyed out and cannot be selected!
gt; gt;
gt; gt; What am I doing wrong?
gt; gt;
gt; gt; Thanks so much.
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt;
gt;
gt;

This topic comes up often. I'm certain one of the MVPs in this forum has a
web page that covers what you want to do.
Can anyone provide a link?

--
Carlos

quot;Stillaquot; gt; wrote in message
...
gt; Carlos - Thank You!
gt; I tried it and it worked. I also discovered that this is no what I want
to
gt; do after all. The merge function quot;replacesquot; data in the same rows. I
need
gt; to quot;joinquot;.
gt;
gt; If one file has 2 rows filled in, the other file has 5 rows filled in. My
gt; masterfile should have 7 rows filled in. I know it's easy to do this
gt; manually, but there will be 30 of these individual files to open.
gt;
gt; 1) is there a way to automate this?
gt; 2) after the first quot;joiningquot; of data - is there a way of subsequently only
gt; quot;bringing inquot; newly added data from the source files
gt;
gt; Thank You - I really appreciate the help.
gt;
gt; quot;CarlosAntennaquot; wrote:
gt;
gt; gt; From Excel Help:
gt; gt;
gt; gt; Requirements for merging Both workbooks must meet the following
gt; gt; requirements:
gt; gt;
gt; gt; a.. Be copies of the same workbook, which must have been a shared
gt; gt; workbook.
gt; gt; b.. Have different file names.
gt; gt; c.. Either not have passwords, or both have the same password.
gt; gt; d.. Have change tracking in effect continuously from when the copies
were
gt; gt; made.
gt; gt; e.. Keep change history back at least as far as the date when the
copies
gt; gt; were made.
gt; gt; For example, if the change history is being kept in the workbooks for
30
gt; gt; days, and the copies were made 45 days ago, you can no longer merge the
gt; gt; workbooks.
gt; gt;
gt; gt; Plan ahead for later merging When you turn on change tracking but
aren't
gt; gt; sure when you'll merge the workbooks, set a large number of days for the
gt; gt; history, up to the maximum of 32,767 days.
gt; gt;
gt; gt; Merge changes manually If the workbooks still won't merge, you can
gt; gt; incorporate the information from one workbook into another manually, by
gt; gt; copying and pasting from one workbook to another.
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Stillaquot; gt; wrote in message
gt; gt; ...
gt; gt; gt; I'm experimenting with merging files in preparation for a potentially
big
gt; gt; gt; merging project.
gt; gt; gt; I set up 4 test files. One is the quot;merge intoquot; file. I've entered
data
gt; gt; into
gt; gt; gt; 4 rows and 3 columns in each of the other three files. The columns
are
gt; gt; gt; identically named in all 4 files. All four files are in one folder.
gt; gt; gt;
gt; gt; gt; I can't find the quot;mergequot; command!! Under tools, there is an option to
gt; gt; gt; quot;Compare amp; Merge Workbooksquot; but it's greyed out and cannot be
selected!
gt; gt; gt;
gt; gt; gt; What am I doing wrong?
gt; gt; gt;
gt; gt; gt; Thanks so much.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt; gt;
gt; gt;
gt; gt;
gt; gt;