sorry - not at work at the moment.
recipient information is in pairs ( login name & name that appears on the spreadsheet eg for me its
'Paul Cooper' & 'COOP'
'Harry Hussain' & 'HUS'
recipient is a cell that head the lists
the code does an offset lookup (not a range so that I can add to the list without redefining the range)
it extracts all the relevant information for 'COOP' and then writes it to the 'Paul Cooper' calendar then the next loop (recipient offset =2 ) the same for 'HUS' and should put it in the Harry Hussain calendar
do until the cell it looks in is blank.