Jun 22 2020 07:24 AM
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,
Jun 22 2020 07:25 AM
*to do this using VBA
Jun 22 2020 07:56 AM
@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
Jun 22 2020 08:15 AM
Hello Devendra,
Thanks so much for this, I'll watch your video and let you know if I need some help with it :)
Jun 22 2020 08:32 AM
@DevendraJain Hi I've watched your video but it was not the same thing that I'm looking to do..
Thank you anyway!
Jun 22 2020 09:23 AM
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