AB33,

again thank you.. I have tested this with more data and it is working great! I am not too worried about the resizing of the one sheet, as in teh final code this will just be a placeholder for the temporary information and cleared when all the results have been aquired.. (a lot more data to manipulate still but this gives me a start).

I will mark this thread as "solved" as your suggestion has done the task.

thank you!!