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
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'.?
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?
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.
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.
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
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
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.
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.
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!
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?
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
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.
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
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
can you do a video on copy dynamic range from A2 onwards and paste it in a different workbook? thanks
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 :)
u r teaching awesome so that everybody can understand it easy.
thanks it's very helpful and will save my time
Thank you such simple and easy to follow instruction
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'.?
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?
Can you please let me know if you find that., I'm checking for same. Thanks in advance🙂
@@sahithyaneppala1416 I have it at work. On Monday I will paste it here.
@@wxmyjnsn Thankyou so much 🙂
Did you forget? @@wxmyjnsn
omg love the flow and the excellent tutorial, thanks!
Thank you dear.
One inquiry please, how can I use cut cells but only value not formula
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.
It is very simple and helpful, very thanks 🌹
You are welcome 😊
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.
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
Well explained, thank you!
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
I got the exact same thing :(
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.
Do we have anything like we can move whole sheet to other workbook
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.
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!
Thank you very useful
Very Nice and useful video. Thank U for education.//Nils
this is very useful
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?
Thank you so much
Thanks so much, really
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
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)
Thanks
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.
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
Thanx
how to repeated rows X number of time in excel vba
Can you send this work book ore macro code to me
Create a Macro to Copy Auto Filtered Dataset to a New Excel Workbook, please provide the VBA code with macro