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

Hi Chris,

I've been using VBA a little longer than that, but not by much! ;)

Any chance of a sample workbook?

If you don't want to post it here, feel free to email it to me on pubnut @ gmail . com (without the spaces obviously).

S.

Added Below

So I need the Buttons to Paste in Weigh in sheet from Meal Calculator :) free to use it as well if ya go on a diet :)

Have a looksy any Questions dont hessitate to ask :)


cheers for looking
chris