Compare 2 columns in seperate workbooks

K

Keenman

I have two workbooks. One named "last.xls" and the other name
"new.xls". Both have one sheet each with a SheetName of "Sheet1"

Both sheets have the same number of columns (A thru K). Here is what
need to do with the data:

I want to compare "Column A" in both workbooks. If a value exists i
"Column A of last.xls", but does not exist in "Column A of new.xls",
want to take that entire row (the one that exists in last.xls, but no
in new.xls) and copy it to a new workbook named tnnew.xls. I need t
copy all of the rows in "last.xls" that do not exist in "new.xls" an
copy them to the new workbook (tnnew.xls)

I need the formating to remain the same in the new workbook as it is i
last.xls. I would also like to copy the header row from "last.xls" t
"tnnew.xls" (The header row is always row 1 Cells A thru K)

I don't really know where to start with this. I've tried some VLOOKU
formulas to no avail. I assume that a VBA module may be the best wa
to go.

Any help is greatly appreciated.


Thank
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two columns in two different workbooks 4
Drop down lists in seperate columns 5
Excel 2013: New row added automatically but first 2 columns Drop down lists not available... 0
Working outlook via vba code with xlsx - error 0
Macro to copy an image (or picture) from one workbook to a new sheetin another workbook 1
Format column widths from one table to a separate table on same page 1
Need Help with a VBA subroutine 0
How To Compare Two Csv Files Mainly Two Columns Containing Time 0

Top