Copy and Paste Cells to Next empty cell in range

Hello, hope this is a simple problem to solve:

I have data in cells J7:J11.

I would like to copy and paste this data into the next empty cell in the range E7:I11

easy way to do this?

Thanks

Please Login or Register  to view this content.

Hi where do i enter this?

I would need to use VBA to copy J7:J11 and then paste it in the first empty cell in the E7:i11 range I believe

thanks but how does this determine where the first empty cell in the e7:i12 range?

This will put the copy range in to next empty cell in column E

Please Login or Register  to view this content.

Thanks, maybe I should clarify. there is data above beside and below the range E7:I12. If I use this code then the data will be pasted below all of this and outside of the desired range.

How can I code so that excel looks at cell e7 and if it is not blank then looks to F7 etc until it goes to I7

In that case, you need to set a loop.

Maybe?

Please Login or Register  to view this content.

thanks so much - this worked! just a question - how can i enter the code for paste special instead of just paste in the line right before the END SUB

Tks
Mark

Maybe:

Please Login or Register  to view this content.

thank you - that works perfectly!

You're welcome. Glad to help out and thanks for the feedback and the rep. Don't forget to comply with Forum Rule No. 9.


mark your thread as Solved: Click Thread Tools above your first post, select "Mark your thread as Solved". Or click the Edit button on your first post in the thread, Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes.