Copying and pasting data on specific sheets with VBA

Copper Contributor

Hello, 

 

I'm trying to work out how to copy specific areas of data within a spreadsheet so say for example cells H2:R20 and paste it within the same spreadsheet into cells B2:L20. And to make a loop so that this would happen on various different spreadsheets within the same workbook that I would specify. 

 

Does anyone have any advice on how to do this? 

Thanks,

5 Replies

*to do this using VBA

@Jolly_Skie Hey Friend I can Help you out with this .

 

I have recently solved a similar issue by using a VBA code and I have also created a macro for that and explained in a video on Youtube

 

https://www.youtube.com/watch?v=Y6V8GYAZwdQ

 

You can watch it and I can explain it in more detail or also can help you out with this problem

 

you just contact me 

Hello Devendra, 

 

Thanks so much for this, I'll watch your video and let you know if I need some help with it :) 

 

 

@DevendraJain Hi I've watched your video but it was not the same thing that I'm looking to do.. 

 

Thank you anyway!

In the description of My video I have given my mail id please mail me actual requirement with some data and I will surely solve the issue dont worry

@Jolly_Skie