match and sort two different tables
 

Column A has customer name, columns B,C,D has corresponding sales data for
that month. Column E is blank. Column F has has customer name. Column
G,H,I has the same corresponding sales data for the next month.

Although Column A and F both have customer names, there are many changes
month over month with the addition and deletion of certain customers so the
rows do not match up exactly. Is there a quick way to have the rows match up
according to customer names in column A and F and then sort them
alpabetically?

match and sort two different tables
 

Maybe I'm missing something, but if customers are added/deleted from month
to month, how can the 2 lists match up? Maybe some examples would help.
HTH Otto

"yowzers" wrote in message
...
Column A has customer name, columns B,C,D has corresponding sales data for
that month. Column E is blank. Column F has has customer name. Column
G,H,I has the same corresponding sales data for the next month.

Although Column A and F both have customer names, there are many changes
month over month with the addition and deletion of certain customers so
the
rows do not match up exactly. Is there a quick way to have the rows match
up
according to customer names in column A and F and then sort them
alpabetically?

match and sort two different tables
 

Thanks for the response. I hope the example below will clarify.

Currently my list looks like this:
Jan Feb
A A
B C
D D
F E
H F
L G
M H

I would like it to look like this:
Jan Feb
A A
B
C
D D
E
F F
G
H H
L
M

"Otto Moehrbach" wrote:

Maybe I'm missing something, but if customers are added/deleted from month
to month, how can the 2 lists match up? Maybe some examples would help.
HTH Otto

"yowzers" wrote in message
...
Column A has customer name, columns B,C,D has corresponding sales data for
that month. Column E is blank. Column F has has customer name. Column
G,H,I has the same corresponding sales data for the next month.

Although Column A and F both have customer names, there are many changes
month over month with the addition and deletion of certain customers so
the
rows do not match up exactly. Is there a quick way to have the rows match
up
according to customer names in column A and F and then sort them
alpabetically?

.