HELP duplicate records
 

Using Excel 2007 - Once a year I receive a large Excel file which contains
student information (name, address, student ID etc.). I use this file to do
several types of Word 2007 merges for our school such as report card labels,
name cards, login id cards, student directory and such.

The problem is that many, not all, children have two records. **I want one
record per child with all the information on one row.** Both records are
identical except one record has the mother's first and last name. The second
record has the father or a grandparent's/guardian's first and last name. Is
there a way to combine this information? Both records have the same address,
phone, etc. Just to clarify that this is not true for all records because
some students only have one parent, thus one record. I have to find a way to
get mom and dad on one record/row. I don't have control over how this
information comes to me.

In the past I have just copied the 2nd record's info, and pasted it into the
last couple columns on the 1st record. Then delete the 2nd record's row.
However, as you can see, this seems like a terrific waste of time, if there
is an easier way.

If there is a way to specify in a Word merge - of which I could post to the
Word forum - then I could do that also.

Thanks to you, in anticipation of your answer.
Becky

HELP duplicate records
 

Excel 2007 Tables
Consolidate
Includes orphans.
http://www.mediafire.com/file/mfnkjgnmalt/09_04_09.xlsm

HELP duplicate records
 

Becky
What you want to do involves VBA programming. I'll try to help you with
that. If you wish, send me your file or a made-up file that shows your
actual layout and a few examples of what you want to happen, showing some
before and after scenarios. My email address is
. Remove the "extra" from this address, Otto
"becder" wrote in message
...
Using Excel 2007 - Once a year I receive a large Excel file which contains
student information (name, address, student ID etc.). I use this file to
do
several types of Word 2007 merges for our school such as report card
labels,
name cards, login id cards, student directory and such.

The problem is that many, not all, children have two records. **I want one
record per child with all the information on one row.** Both records are
identical except one record has the mother's first and last name. The
second
record has the father or a grandparent's/guardian's first and last name.
Is
there a way to combine this information? Both records have the same
address,
phone, etc. Just to clarify that this is not true for all records because
some students only have one parent, thus one record. I have to find a way
to
get mom and dad on one record/row. I don't have control over how this
information comes to me.

In the past I have just copied the 2nd record's info, and pasted it into
the
last couple columns on the 1st record. Then delete the 2nd record's row.
However, as you can see, this seems like a terrific waste of time, if
there
is an easier way.

If there is a way to specify in a Word merge - of which I could post to
the
Word forum - then I could do that also.

Thanks to you, in anticipation of your answer.
Becky

HELP duplicate records
 

This did not post so I'm sending it again. Otto
Becky
What you want to do involves VBA programming. I'll try to help you with
that. If you wish, send me your file or a made-up file that shows your
actual layout and a few examples of what you want to happen, showing some
before and after scenarios. My email address is
. Remove the "extra" from this address, Otto

"becder" wrote in message
...
Using Excel 2007 - Once a year I receive a large Excel file which contains
student information (name, address, student ID etc.). I use this file to
do
several types of Word 2007 merges for our school such as report card
labels,
name cards, login id cards, student directory and such.

The problem is that many, not all, children have two records. **I want one
record per child with all the information on one row.** Both records are
identical except one record has the mother's first and last name. The
second
record has the father or a grandparent's/guardian's first and last name.
Is
there a way to combine this information? Both records have the same
address,
phone, etc. Just to clarify that this is not true for all records because
some students only have one parent, thus one record. I have to find a way
to
get mom and dad on one record/row. I don't have control over how this
information comes to me.

In the past I have just copied the 2nd record's info, and pasted it into
the
last couple columns on the 1st record. Then delete the 2nd record's row.
However, as you can see, this seems like a terrific waste of time, if
there
is an easier way.

If there is a way to specify in a Word merge - of which I could post to
the
Word forum - then I could do that also.

Thanks to you, in anticipation of your answer.
Becky