Excel VBA to Copy/Move Data Within Sheet, to Another Sheet or Another Workbook

This video demonstrates how to write a VBA Macro to copy or move ranges/cells. You will learn how to:
Copy/move a range within the same worksheet
Copy/move cells to another worksheet
Copy/move a data to another workbook
Copy and transpose data.
------------------------

[@joannaklosowska2017]

Hi Chester. Thank you very much for your videos! I don't know anything about macros and at the same time, I'm writing them. Thanks to you :)

[@sudarshansathyanarayanan3480]

u r teaching awesome so that everybody can understand it easy.

[@imyong7983]

Thank you such simple and easy to follow instruction

[@lisama2538]

omg love the flow and the excellent tutorial, thanks!

[@alekm9446]

Well explained, thank you!

[@augustooviedo8207]

Thanks so much, really

[@FaysalEasyExcel]

thanks it's very helpful and will save my time

[@GeorgeAJululian]

Thank you very useful

[@nicholetam5104]

can you do a video on copy dynamic range from A2 onwards and paste it in a different workbook? thanks

[@fksons4161]

Thank you so much

[@nilsbruhner1983]

Very Nice and useful video. Thank U for education.//Nils

[@eddiemayah5504]

this is very useful

[@user-ih7ot7vl8u]

It is very simple and helpful, very thanks 🌹

[@ChesterTugwell]

You are welcome 😊

[@michellegygax6527]

I am loving this videos, I am having some trouble trying to create an invoice that can be reused, but the data entered remain saved into a log sheet. Can you suggest some tutorials for me to watch to be able to do that. I have NEVER worked with VBA's and have been confused by them until coming across your tutorials--you explain and walk through the steps very well and are easy to follow. UPDATE: I got it...now I am just having trouble with brining the sum over from the other sheet/log--any help will be appreciated.

[@mohammedhussein1592]

Hi Chester, thanks for the video One question, can I copy the Data to a new workbook ?? Like once I run the Macro it should open a new workbook and paste the data inside it Thanks a lot

[@PankajKumar-rx6od]

Thanks

[@barrycomben5386]

Chester, Best vba module creation explanation on the web. I wonder if you could help me write one (from a Button) which transfers all my listed assets that need P.A.T testing to another P.A.T testing sheet. If they need testing cell 7 will indicate 'yes'.?

[@manasimahajan8307]

This Works for me now - Sub CopyToBook() Set y = Workbooks.Open("Path to the file") Workbooks("Book2.xlsm").Worksheets("Sheet1").Range("C22").Copy y.Sheets("Sheet1").Range("B5").PasteSpecial End Sub

[@lazmusic1]

Hi Chester, thank you for an excellent explanation of this topic. I have a question which may need a somewhat long answer and may test your generosity with providing free instructions but I'll ask it anyway! I need a code for copying certain cells from one sheet to a row in another sheet in the same workbook by clicking a button and for each instance of clicking that button (after the completion of the required information) for the new set of data to appear on the subsequent row in the destination sheet, as if one was inputting data in an Access form. Apologies for the long question again and many thanks.

[@revlaxcoordinators4364]

Hi! I am following the exact formula/code you created to move one cell to another cell on a different sheet. However, when it moves, it shows the number 1, when it should be 28. Then when I click the cell it says =COUNTA(#REF). Do you think this is different due to the fact that your tutorial used words and I am using numbers? Thank you!

[@ShikhaSharma-qw4px]

Thank you. I want to copy different ranges (ex- b2:b10 and s2:s10) from one workbook and paste it to another workbook (ex- b2:b10 copied range should paste in aa2 of this workbook and s2:s10 copied range should paste in bb2). Sheet name is dynamic it will change every week. It would be great if you could help me out.

[@MrPakiwarrior]

Hi Chester. I need some help regarding moving data from one sheet to another. I have 6 items in a dropdown menu list. Rice, Beans, Wheat, Corn, Grey, Pasta I also have added a column showing cost on the right side of this dropdown column. I have made 6 Sheets in same workbook. I need the right item to be moved to the item sheet. Can u plz help me?

[@alializadeh8195]

Thanx

[@allahwithme1731]

Thank you dear. One inquiry please, how can I use cut cells but only value not formula

[@wxmyjnsn]

This was VERY useful, thank you! However, I need to cut and paste the active row from one table to another table on a different sheet and then delete the empty row. How do I do that?

[@sahithyaneppala1416]

Can you please let me know if you find that., I'm checking for same. Thanks in advance🙂

[@wxmyjnsn]

@@sahithyaneppala1416 I have it at work. On Monday I will paste it here.

[@sahithyaneppala1416]

@@wxmyjnsn Thankyou so much 🙂

[@syedikramulla3693]

I have a sheet with macro. When copy the sheet, macro is also getting copied in the new sheet. Please let me know how to avoid macro getting copied or disable macro in the new sheets.

[@user-to4hn8wm7d]

I am trying to use this code but it give run time error 9. Code:- Sub Monthly_GST_Sales_Report() Range("A1:W507").Copy Workbooks("Monthly_GST_Sales_Report").Worksheets("Sheet1").Range("A1") End Sub

[@renukavashisth6744]

Sir I have a question I want to copy one date to next date then copy next date until another date in loop Like in A1 I have 01/05/2020 & in A10 I have 02/05/2020 & A12 I have 03/05/2020. Now I want to fill dates in cell A2 to A9 date 01/05/2020 so on dates are not in same position Plz help me

[@manasimahajan8307]

Thank you for the video :) copytobook for some reason does not work Sub CopyToBook() Range("A20").Copy Workbooks("newB").Worksheets("Sheet1").Range("A5") End Sub It gives me Run-time error '9' Subscription out of Subscript Could you please suggest if anything needs to be changed in the code

[@SamStatham294]

I got the exact same thing :(

[@zeshankhan2455]

how to repeated rows X number of time in excel vba

[@Abidaytrader]

Create a Macro to Copy Auto Filtered Dataset to a New Excel Workbook, please provide the VBA code with macro

[@GhostRider-mz1hl]

Morning Chester, I have watched your video, but! the problem for me is this, you don't give the option to paste the text only in the cell or cell range, for example my destination sheet (Main data base) has got set up formatted cells coloured cells, and boarders and formulas in them for example yellow cells, and sheet 2 is my update sheet, which has the same information but! no formatting or formulas in it, and any new data I add in sheet 2 will always go at the top, and the rest of the information will move down as new data gets added, then I will click on my UPDATE MAIN DATABASE button to update my MAIN DATABASE, so in your VBA CODE, please can you tell me what the vba code including the cell range as shown in your video to just paste the text only so that none of the formatting colored cells/boarders and any formulas in my main database does not get pasted over except for the text, PS I am using office 365, thank you, I look forward to hearing from you. With kind regards Steve.

[@chewhouming3386]

How to paste row F4:F5 till last row in column A. LastRow = Cells(Rows.Count, 1).End(xlUp).Row Range("F4:H4").Copy Range("F5:H5" & LastRow)

[@rinupvr3960]

Can you send this work book ore macro code to me