Well i tried but couldnt integrate your functions it must be something
im missing, when the functions have performed their task i would like
the groups to be copied and pasted in to a seperate sheet each group
titled Group n where n would be the number of the group i.e group1,
group2 etc.....so if there were 3 groups of 4 and 2 groups of 3, the
first group of 4 would be copied and pasted and titled group 1 and then
the second group and so on....Anyone any ideas?

Simon.


--
Simon Lloyd
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.excelforum.com/member.php...fo&userid=6708
View this thread: http://www.excelforum.com/showthread...hreadid=535463