Hi,
I've been trying to write a macro for this but can't figure out the proper way to go about accomplishing this correctly.
I have one workbook open (Important to note that the name of this workbook can vary) with a table called "Invoices". Lets call this workbook WorkBook A.
I have another workbook open named "Backup 1" with the same table called "Invoices", except that table might have one or more invoices that are not on the WorkBook A.
I want this macro to Find the rows in "Backup 1" with Invoice numbers (Column A) that dont exist on Workbook A, and copy those rows to Workbook A.
I'm kind of stuck and not sure how to do this between two different open workbooks.
I've been trying to write a macro for this but can't figure out the proper way to go about accomplishing this correctly.
I have one workbook open (Important to note that the name of this workbook can vary) with a table called "Invoices". Lets call this workbook WorkBook A.
I have another workbook open named "Backup 1" with the same table called "Invoices", except that table might have one or more invoices that are not on the WorkBook A.
I want this macro to Find the rows in "Backup 1" with Invoice numbers (Column A) that dont exist on Workbook A, and copy those rows to Workbook A.
I'm kind of stuck and not sure how to do this between two different open workbooks.
