Copying and pasting data on specific sheets with VBA

%3CLINGO-SUB%20id%3D%22lingo-sub-1481038%22%20slang%3D%22en-US%22%3ECopying%20and%20pasting%20data%20on%20specific%20sheets%20with%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481038%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20trying%20to%20work%20out%20how%20to%20copy%20specific%20areas%20of%20data%20within%20a%20spreadsheet%20so%20say%20for%20example%20cells%20H2%3AR20%20and%20paste%20it%20within%20the%20same%20spreadsheet%20into%20cells%20B2%3AL20.%20And%20to%20make%20a%20loop%20so%20that%20this%20would%20happen%20on%20various%20different%20spreadsheets%20within%20the%20same%20workbook%20that%20I%20would%20specify.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20advice%20on%20how%20to%20do%20this%3F%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1481038%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481040%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20and%20pasting%20data%20on%20specific%20sheets%20with%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481040%22%20slang%3D%22en-US%22%3E%3CP%3E*to%20do%20this%20using%20VBA%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481101%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20and%20pasting%20data%20on%20specific%20sheets%20with%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481101%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706515%22%20target%3D%22_blank%22%3E%40Jolly_Skie%3C%2FA%3E%26nbsp%3BHey%20Friend%20I%20can%20Help%20you%20out%20with%20this%20.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20recently%20solved%20a%20similar%20issue%20by%20using%20a%20VBA%20code%20and%20I%20have%20also%20created%20a%20macro%20for%20that%20and%20explained%20in%20a%20video%20on%20Youtube%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DY6V8GYAZwdQ%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DY6V8GYAZwdQ%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20watch%20it%20and%20I%20can%20explain%20it%20in%20more%20detail%20or%20also%20can%20help%20you%20out%20with%20this%20problem%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eyou%20just%20contact%20me%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481159%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20and%20pasting%20data%20on%20specific%20sheets%20with%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481159%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Devendra%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20so%20much%20for%20this%2C%20I'll%20watch%20your%20video%20and%20let%20you%20know%20if%20I%20need%20some%20help%20with%20it%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481227%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20and%20pasting%20data%20on%20specific%20sheets%20with%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481227%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699938%22%20target%3D%22_blank%22%3E%40DevendraJain%3C%2FA%3E%26nbsp%3BHi%20I've%20watched%20your%20video%20but%20it%20was%20not%20the%20same%20thing%20that%20I'm%20looking%20to%20do..%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20anyway!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481367%22%20slang%3D%22en-US%22%3ERe%3A%20Copying%20and%20pasting%20data%20on%20specific%20sheets%20with%20VBA%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481367%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20the%20description%20of%20My%20video%20I%20have%20given%20my%20mail%20id%20please%20mail%20me%20actual%20requirement%20with%20some%20data%20and%20I%20will%20surely%20solve%20the%20issue%20dont%20worry%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706515%22%20target%3D%22_blank%22%3E%40Jolly_Skie%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional 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
Highlighted

*to do this using VBA

Highlighted

@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 

Hiii Guys, Thank You so much for the overwhelming response for my First youtube Video. Here is my 2nd Video on How to Record a history of a strike price from...
Highlighted

Hello Devendra, 

 

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

 

 

Highlighted

@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