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.
------------------------

[lisama]

omg love the flow and the excellent tutorial, thanks!

[imyong]

Thank you such simple and easy to follow instruction

[joannaklosowska]

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 :)

[sudarshansathyanarayanan]

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

[FaysalEasyExcel]

thanks it's very helpful and will save my time

[nicholetam]

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

[manasimahajan]

This Works for me now -
Sub CopyToBook()

Set y = Workbooks.Open("Path to the file")



End Sub

[nilsbruhner]

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

[barrycomben]

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'.?

[ihotvlu]

It is very simple and helpful, very thanks 🌹

[mohammedhussein]

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

[lazmusic]

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.

[ShikhaSharma-qwpx]

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.

[michellegygax]

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.

[revlaxcoordinators]

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!

[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?

[allahwithme]

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?

[syedikramulla]

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.

[tohnwmd]

I am trying to use this code but it give run time error 9.
Code:-
Sub Monthly_GST_Sales_Report()

Range("A1:W507").Copy

End Sub