View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
musicman musicman is offline
external usenet poster
 
Posts: 11
Default 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