B
beetski
HELP !!I have two large but seperate workbooks (2000 rows
each) that both have two common columns that contains the
same misc numbers and text (such as premise number and
street name). Other columns contain differenct data, such
as name, or community in one workbook and date of hire and
salary in the other workbook. I want to blend the two
workbooks into one workbook combining the common data and
then adding the remaining columns so that I end up with a
single row that I could sort by premise number and or
street name, but can't find a solution within "help"
each) that both have two common columns that contains the
same misc numbers and text (such as premise number and
street name). Other columns contain differenct data, such
as name, or community in one workbook and date of hire and
salary in the other workbook. I want to blend the two
workbooks into one workbook combining the common data and
then adding the remaining columns so that I end up with a
single row that I could sort by premise number and or
street name, but can't find a solution within "help"