View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jase jase is offline
external usenet poster
 
Posts: 117
Default matching up data

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