Thanks Spencer, However

I require it go down then right. What would i need to look up for this?
also a problem i have found when finding blank cells ect. is that alot of the tutorials out there start with A:A were as my Sheet has lots of tables table headers in Cols N-T Rows 6-7 and Blank Cells in N-T Rows 1-5 therefor alot of the tutorials i find dont work Because they are based on an empty sheet of a table Based in Cols A-C (for example).

Any chance of some sample code with explanation? Sorry im just fairly new only been using VBA for like 20 Hours :D

Thanks For taking the time to reply to this and for your patients :)

Chris