Jase,

I have uploaded an example to http://www.nofavor.com/spreadsheets/compare.xls
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"Jase" wrote:

I have a 2 sets of data, the newer data has more information then the old. I
want to be able to run a macro that goes through the old data and finds where
its missing info from the newer data and insert a row to make the 2 sets of
data match up.

So it will find that it doesnt match up and insert rows where it needs to.
Any ideas?

data A data B
2 2
6 7
7 10
9 11
10
11