Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

copy paste in a blank cell with micro

0

Can someone PLease tell me how to Run micro to copy a value and paste in a column in blank cells.

 eg: copy from a2,b2,c3 and past to d2,e2,f2, and again from a2,b2c2 and past to d3,e3,f3 and so on to till d29,e29,f29. in an interval of 15 min??? 

please tell me anyone 

Thank you if you can help me

Answer
Discuss

Discussion

Have you tried to do this at all? You really just need to view 2 tutorials on this site.... Copy and Paste Data using Macro VBA in Excel and Find the Next Blank Row with VBA Macros in Excel. In the last link just replace .Select with .Row and you can use it with the Cells() property or Range() property to put the data there. At least try something and then edit your question post your attempt there.
don (rep: 1989) Jun 3, '20 at 11:39 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login