How to copy from the next Row when I Run Code again

Hi,
I want that Code should copy this Range Q10:T10. And Paste into this Range Q7:T7 as simple Numbers. If i run this code again then it should copy this Range Q11:T11. And Paste into this Range Q7:T7 as simple Numbers. If i Run this Code again then it should copy this Range Q12:T12. And Paste into this Range Q7:T7 as simple Numbers. And so on. But when it reaches blank cells below to Q10:T10. And i run this code again then it should show a message saying "Task has been Completed"

Please see attached file for more clarification

Hello A1256,

A double click event code would suit this scenario:-

Please Login or Register  to view this content.

Double click on any cell in the range Q10:Q34 and the four columns of data in the relevant row will be copied to Q7 and so on.

To implement this code:-

- Right click on the sheet tab.
- Select "View Code" from the menu that appears.
- In the big white code field that then appears, paste the above code.

I hope that this helps.

Cheerio,
vcoolio.

Hi vcoolio,

Thank you for this. But I need a Code that would work without Double Click on Cell. I only want to press F5, and code should do this task.

Hi Please anybody solve my issue. Thank you so much

Hi Please anybody solve my issue. Thank you so much

Hi aworfolk,

Thank you for this. But i could not use it. I am getting "Run-time error 13". This may be a mistake from my side as i have zero knowledge about vba coding. Please put this code in the attached excel file. And share withe me the attached file. I will be really very thankful to you.

Here is the File with the code built into it.

Hi aworfolk,

Can you please share excel file of format .xlsx‎ instead of .xlsb‎?

I can change it to a .xlsm but for there to be stored code in the file it can not be a .xlsx. Sorry but that is the best I can do.

Hi aworfolk,

Thank you so much for your time and efforts. It worked perfectly as i wanted. Thanks again.

Originally Posted by A1256

Can you please share excel file of format .xlsx‎ instead of .xlsb‎?

The xlsx extension books cannot operate macros, so the xlsm or xlsb extension books are used.