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 way t
go.

Any help is greatly appreciated.


Thank

--
Message posted from http://www.ExcelForum.com