In worksheet1 I have
Last First Month
Doe John Sept
smith Jan Oct


In worksheet2 I have
Last First Date Year
Doe John 7 1912
smith Jan 3 1953


I want to consolidate this into one worksheet like this
Last First Month Date Year
Doe John Sept 7 1912
Jones Amy Oct 3 1953


but when I use the consolidate function (sum function) I get this
Last First Month Date Year
7 1912
3 1953


My text fields are empty. What am I missing? Should I be using a different
feature of excel to combine this data?

The easiest way that I can think of doing this is copying the column that has
the months in it and paste it in the other. This will work as long as the
information is organized in the exact same way ei sort by last, first and
year on each sheet before you copy and paste.

--
:)


"Enrique" wrote:

In worksheet1 I have
Last First Month
Doe John Sept
smith Jan Oct


In worksheet2 I have
Last First Date Year
Doe John 7 1912
smith Jan 3 1953


I want to consolidate this into one worksheet like this
Last First Month Date Year
Doe John Sept 7 1912
Jones Amy Oct 3 1953


but when I use the consolidate function (sum function) I get this
Last First Month Date Year
7 1912
3 1953


My text fields are empty. What am I missing? Should I be using a different
feature of excel to combine this data?

Unfortunately it is not completely in the same order, plus other gramatical
errors exist in this 2000 row document.

"Ruth" wrote in message
...
The easiest way that I can think of doing this is copying the column that
has
the months in it and paste it in the other. This will work as long as the
information is organized in the exact same way ei sort by last, first and
year on each sheet before you copy and paste.

--
:)


"Enrique" wrote:

In worksheet1 I have
Last First Month
Doe John Sept
smith Jan Oct


In worksheet2 I have
Last First Date Year
Doe John 7 1912
smith Jan 3 1953


I want to consolidate this into one worksheet like this
Last First Month Date Year
Doe John Sept 7 1912
Jones Amy Oct 3 1953


but when I use the consolidate function (sum function) I get this
Last First Month Date Year
7 1912
3 1953


My text fields are empty. What am I missing? Should I be using a
different
feature of excel to combine this data?

Sorry Enrique
I don't know how to if the information doesn't match exactly.
--
:)


"Enrique" wrote:

Unfortunately it is not completely in the same order, plus other gramatical
errors exist in this 2000 row document.

"Ruth" wrote in message
...
The easiest way that I can think of doing this is copying the column that
has
the months in it and paste it in the other. This will work as long as the
information is organized in the exact same way ei sort by last, first and
year on each sheet before you copy and paste.

--
:)


"Enrique" wrote:

In worksheet1 I have
Last First Month
Doe John Sept
smith Jan Oct


In worksheet2 I have
Last First Date Year
Doe John 7 1912
smith Jan 3 1953


I want to consolidate this into one worksheet like this
Last First Month Date Year
Doe John Sept 7 1912
Jones Amy Oct 3 1953


but when I use the consolidate function (sum function) I get this
Last First Month Date Year
7 1912
3 1953


My text fields are empty. What am I missing? Should I be using a
different
feature of excel to combine this data?

Thanks for the effort. I'll keep searching.

"Ruth" wrote in message
...
Sorry Enrique
I don't know how to if the information doesn't match exactly.
--
:)


"Enrique" wrote:

Unfortunately it is not completely in the same order, plus other
gramatical
errors exist in this 2000 row document.

"Ruth" wrote in message
...
The easiest way that I can think of doing this is copying the column
that
has
the months in it and paste it in the other. This will work as long as
the
information is organized in the exact same way ei sort by last, first
and
year on each sheet before you copy and paste.

--
:)


"Enrique" wrote:

In worksheet1 I have
Last First Month
Doe John Sept
smith Jan Oct


In worksheet2 I have
Last First Date Year
Doe John 7 1912
smith Jan 3 1953


I want to consolidate this into one worksheet like this
Last First Month Date Year
Doe John Sept 7 1912
Jones Amy Oct 3 1953


but when I use the consolidate function (sum function) I get this
Last First Month Date Year
7 1912
3 1953


My text fields are empty. What am I missing? Should I be using a
different
feature of excel to combine this data?

Hi,

Just check whether the "Troubleshoot data consolidation of multiple
worksheets" in the on-line help is of any assistance to you.

Challa Prabhu

"Enrique" wrote:

In worksheet1 I have
Last First Month
Doe John Sept
smith Jan Oct


In worksheet2 I have
Last First Date Year
Doe John 7 1912
smith Jan 3 1953


I want to consolidate this into one worksheet like this
Last First Month Date Year
Doe John Sept 7 1912
Jones Amy Oct 3 1953


but when I use the consolidate function (sum function) I get this
Last First Month Date Year
7 1912
3 1953


My text fields are empty. What am I missing? Should I be using a different
feature of excel to combine this data?