VBA Macro to Copy Data to Another Workbook

This Excel VBA Tutorial explains VBA Code to copy data from one workbook to another. Use Workbook Object and Open Method in VBA to Transfer data from one workbook to another workbook.

[techgalaxy]

Your videos are very helpful and easy to understand brother. Keep up the good work!!

[Jishume]

sir! really nice demonstration, i improvised and expanded avenue on top of this. Best regards!

[renzohisona]

thanks bro, this helps a lot, big thumbs up

[kevincoloso]

Hi thank you for the detailed explanation, I just want to ask one thing, how can i copy the values on the specific cell and not the formula? because the one i want to copy and paste has a formula equal sign to other cell. Thanks!

[luyonjostephen]

Thank you boss... How do I select and paste a range of rows and columns rather then an entire row?

[leynmandreza]

how about vise versa, the destination file is the one have the button copy and I need to get the data to the source that is not open?

[joyrebello]

what is the Vba code for selecting some particular columns and filtered DATA?

[neth-]

Hi what about if i need to paste values not formulas. My cells contain formulas but i need to transfer values

[tusharpatel]

Thank you sir, I have one question if i have 2 nos worksheet in excel file with different header in 2 nos. worksheet and i want to transfer data from one worksheet to another worksheet for specific column. Please Help and give idea about VBA

[jamesmusontong]

hi Sir what about VBA code to copy the the entire data from different sheets in a workbook to a different workbook with the same sheet names from the source data? will kindly appreciate your help

[ruchitamehta]

Really very useful Video - love from Vienna

[satyasadhannag]

Sir, it is excellent, but my query is that while rows to transferred are not always fixed, what code vb will be there. For example, through vlookup I am to fix certain data with many rows having vlookup formulas there from master data, I want to pastevalues mode in the goal worksheet one by one. Now what will be vb code in this case. Please reply as I am in the stage of not achieved still now after many attempts.

[ramahirwar]

Boss.. how can use last row instead of row 12

[romanov]

thank a lot for such great educational video.
Just want to know to paste data from right to left continuously after some specific time interval.

[shubhamdimri]

what if we just want to copy a single column from source to our destination workbook

[visejdoshi]

Hi...I have multiple source workbook range cell to copy in destination file specific range cell. Without opening source workbook. Pls help

[ShivSharma-mkhq]

Sir
Pls tell me how to record macro in the workbook(in which already some formulae present)

[muhammadrizwanisrar]

Thanks for very simple and nice video, there is a small error, once we run the code its always selecting only the Row 12 as given.

[dr.asifali]

can we apply it in macro-enable workbook ?

[JohnS-erjh]

Thanks for the video. I copied a Macro Workbook to another File. But when I run the Macro it opens the original file containing the macro (I have to manually remove the links the source file under File > Info > Edit Links). Does anyone know a method to copy a Macro Workbook to a New Excel file without having a link automatically established. Thanks.