Hi DILIPandey

Thank You very much for your response. Yes you're right in thinking that every time I run the macro I want this new data to be considered in formula. I am currently unable to uploaded a sample at the current time due to restrictions at work. However I will get one uploaded towards the end of the day when I am home.

Thank You

Harry