View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cheekyaardvark Cheekyaardvark is offline
external usenet poster
 
Posts: 10
Default Merging excel tables & more, countif, macro line insert etc

So if we go with the above example & say that it was a static 2 way
split how would we get the merge to happen?

0300809 01 03 00006707 015
0300809 01 03 00008116 085

0300809 00012043
0300809 00012077

to get this
0300809 00012043 01 03 00006707 015
0300809 00012043 01 03 00008116 085
0300809 00012077 01 03 00006707 015
0300809 00012077 01 03 00008116 085

Is that now relatively straightforward

Thanks for all the help BTW