Hi,
I've got two excel workbooks that I need to merge.
The first book has the majority of the data and consists of multiple colomns and about 700 rows of data. For example lets say it has "Apple" in colomn G, row 241
The second book, has some data, some of which is the same, but not on the same row. for example, it may also have "Apple" in colomn G, but on row 248.
Is there a way to take data from colomn G, find the exact wording in Colomn G of the second workbook and paste/insert the entire row from the first workbook?
I've got two excel workbooks that I need to merge.
The first book has the majority of the data and consists of multiple colomns and about 700 rows of data. For example lets say it has "Apple" in colomn G, row 241
The second book, has some data, some of which is the same, but not on the same row. for example, it may also have "Apple" in colomn G, but on row 248.
Is there a way to take data from colomn G, find the exact wording in Colomn G of the second workbook and paste/insert the entire row from the first workbook?