D
DiscoJason
A gentleman has called me with a question on how to do something which
have not been able to figure out, so I figured I would try to find som
help here. Here is the scenario:
He wants to join two workbooks which have some similarities i
information, but are not identical in format. For example, let's say
have one worksheet with the following columns: Name, Age, Telephone.
I then have another workbook with the following columns: Name
Address, Zip Code.
One thing of note is that the Name column has some identical name
between the two, but not all names are identical.
So, I need to combine these two workbooks so that I have one table wit
Name, Age, Telephone, Address, Zip Code. For names which are not i
both tables, the row would have some blanks in it which would be fille
in later and for those names which were in both workbooks, the whol
row would be filled in.
The question is, is this doable with some basic function of Excel, o
would it require macro programming or some other complicated method
have not been able to figure out, so I figured I would try to find som
help here. Here is the scenario:
He wants to join two workbooks which have some similarities i
information, but are not identical in format. For example, let's say
have one worksheet with the following columns: Name, Age, Telephone.
I then have another workbook with the following columns: Name
Address, Zip Code.
One thing of note is that the Name column has some identical name
between the two, but not all names are identical.
So, I need to combine these two workbooks so that I have one table wit
Name, Age, Telephone, Address, Zip Code. For names which are not i
both tables, the row would have some blanks in it which would be fille
in later and for those names which were in both workbooks, the whol
row would be filled in.
The question is, is this doable with some basic function of Excel, o
would it require macro programming or some other complicated method