Copy Range from one sheet, and paste it to the next available column on another sheet

I Have to copy J1:J103 from the "Lists" sheet, and paste it in the next available column in the "DaY" sheet. This needs to be accomplished from a button on the "DaY" sheet. It seems simple but never works quite right. Any ideas.

You don't have a "Lists" Sheet in your workbook
Also the whole range J1:J103 should be copyed? or just some values from that column?

Uploaded an old copy of the book. Yes, the whole range would need to be copied. Also, all the formula's and formating needs to be copied. Thanks for your help.

I still don't know what you mean but try this:

Please Login or Register  to view this content.

Make a button on DaY sheet and asign the Copy_JColumn to it. And try clicking it
If it doesn't work and the error is on the 2nd line then switch it with this:

Please Login or Register  to view this content.

or this:

Please Login or Register  to view this content.

Hope this helps

I am still getting an error message that says, No object selected

My Mistake!!!

Please Login or Register  to view this content.

Forgot the offset part

But you need to determin in which row should it look for the last column!
that is the Range("IV1") <<---the 1 in this formula is the row. change it to a row that is the begining of the copy row
If J1 value goes in next column row 15 then set this number to 15...understand?

Yeah, that makes sense. and that cleaned it up, Except now the third row is showing as invalid use of . I am attaching the current format of the sheet and the row i want is 1 if you could take a look at it and see whats wrong?