Dear All
I would normally use PowerQuery to achieve the following but this time I need a solution for Excel 2007 and 2010. Hence I am interested if it can be achieved using VBA (with which I am not familiar).
I have two Workbooks A & B. Each workbook contains a table on Sheet 1. The tables have the same number of columns in the same sequence however the number of rows may differ, Workbook A may have more rows than Workbook B, and sequence of the rows may differ. The first column in both tables contains a unique alphanumeric value.
Working from within Workbook A, I need to compare the tables (based on the unique value in column A) and if the table in Workbook B has any missing rows transfer the missing row(s) to the bottom of the table in Workbook B.
Any advise or guidance would be gratefully received.
DW
Bookmarks