One last issue has cropped up - the numbers that are pulling through are rounded to the nearest whole number. Is there any way you can suggest tweaking the VBA code so that the SUM adds to several decimal points?
Thanks again for your help, I really appreciate it.