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

Do we have anything like we can move whole sheet to other workbook

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

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

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

Thank you very useful

how to repeated rows X number of time in excel vba

Thank you so much

hello, I have a code like below, the code is working in the same page. My aim is to write the data in page 1 on the lines a2: a500 on page 2. I would appreciate your help.

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
If Target.Column > 1 Then Exit Sub
If Target.Row > 35 Then Exit Sub
For Each a In Range("a2:a" & Range("a65536").End(3).Row)
If a.Value Like Target.Value & "*" Then
Target.Value = a.Value
Exit Sub
End If
Next
End Sub

Thanx

omg love the flow and the excellent tutorial, thanks!

Can you send this work book ore macro code to me

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.

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)

Thank you such simple and easy to follow instruction

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.

Well explained, thank you!

It is very simple and helpful, very thanks 🌹

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.

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

thanks it's very helpful and will save my time

Thanks

this is very useful

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?

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

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

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.

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.

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

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

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

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

Thanks so much, really

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?

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

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