ok, thats not what i want....

forget doing it that way then...

is there a way of doing it with the layout in testforsite.xlsx that i posted earlier...i realise that it will be a more complicated code but because of other factors in the final workbook it will be alot simpler doing it that way in the end.

Can it be done? If so will you help me ammend the code I have tried?