compare and arrange two sets of datta.
 

I have two similar lists I have them each sorted by a value field.
I need to arrange the two sets to match the value.
There could be values in one set without a corresponding value in the second
in whihc case insert a blank line in the second and also vice versa.
I used to do this sort of thing all the time in Lotus macros but am at a
loss to in excel VBA