VBA Macro to Copy Data to Another Workbook

[@ruchitamehta2050]

Really very useful Video - love from Vienna

[@ExcelDestination]

Thanks

[@techgalaxy100]

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

[@ExcelDestination]

Glad to hear that!

[@Jishu1987me]

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

[@ExcelDestination]

Excellent

[@srinivasgoudmanthapuri2719]

Nice explanation.... 👌

[@ExcelDestination]

Thanks

[@renzohisona1292]

thanks bro, this helps a lot, big thumbs up

[@romanov5635]

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.

[@ExcelDestination]

some extra code would be required.

[@ramahirwar1459]

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

[@neth-5139]

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

[@kevincoloso5890]

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!

[@tusharpatel9447]

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

[@luyonjostephen8746]

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

[@dr.asifali5616]

can we apply it in macro-enable workbook ?

[@leynmandreza5013]

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?

[@dsp5574]

Very helpful video but can you please help me I wanted to copy the non adjacent cells and paste in another workbook in a single row and every time it needs to be fill in next emty row. Please guide me in this regard Thanks

[@ExcelDestination]

For any Excel VBA Project, you can write to [e-mail]

[@muhammadrizwanisrar1599]

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.

[@อภิญญาพุ่มสุวรรณ-ด8อ]

I have a question about this work . If I need to transfer data form user form to another worksheet . How to do ?

[@ExcelDestination]

For UserForm and Sheet interactivity, you can watch another tutorial at following link : kzbin.info/www/bejne/Z5zTg5Rmj5tgb8k

[@ShivSharma-mk2hq]

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

[@satyasadhannag4004]

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.

[@shahnonu]

Do we still need code further if we save, I mean wb nothing onward?

[@ExcelDestination]

no

[@laughoorlotolol9540]

What is the modification in case i have to copy multiple rows?

[@laughoorlotolol9540]

This was sorted, I did it the same day

[@clorisagillard8671]

Thank you for the tutorial. Can this also be applied to sheets with subtotals?

[@ExcelDestination]

Thanks for watching! I haven't checked. You can give it a try and let me know also.

[@srikantab5247]

@@ExcelDestination Hi, can u plz make a video on copy different cell values from different workbook into a master workbook automatically.? I just need for timesheet for many guys

[@srinivasgoudmanthapuri2719]

I want to copy selected range.... Pl reply.. 🙏

[@ExcelDestination]

Sorry sir Mr. Vimal Kishor Gupta The owner of this channel is no more

[@karinak5531]

Hi! You video is very helpful! Thanks! But I have a doubt. How can I do if: 1) I have multiple workbooks in multiple folders and 2) I need to copy a determined range (F5 to F10) and 3) paste it in sequencial order in a same sheet in this workbook (example: paste data of first workbook to G5 to G10, and next workbook data in H5 to H10 and so on) till there’s no more workbooks? I would appreciate very much if you could help...

[@ExcelDestination]

Thanks for watching. For any Excel VBA Support, you can write to [e-mail]

[@shubhamdimri1328]

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

[@srikantab5247]

Hi, can u plz make a video on copy different cell values from different workbook into a master workbook automatically.? I just need for timesheet for many guys

[@ExcelDestination]

ok. let me try.

[@srikantab5247]

@@ExcelDestination thanks

[@srikantab5247]

@@ExcelDestination my requirement is like I have multiple timesheet workbooks. I just want copy specific cell value from different workbooks to a master timesheet workbooks automatically to different cell of a row. For one timesheet one row and next timesheet next row. Without opening multiple timesheets..thanks

[@JohnS-er7jh]

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.

[@waseemlimbaliya6196]

1-I have sheet named as master data in which It has multiple ledgers for example Bank, Cash, income, furniture expenses liabilities. 2- and i have another sheet named as report. In this section i am able to filter the data in report section and i want to export this specific data or ledger into new excel workbook and this new workbook should be saved based on cell refrence of report sheet. Please guid me for the above code.

[@ExcelDestination]

please share your requirement at [e-mail]

[@waseemlimbaliya6196]

@@ExcelDestination Sir Please Check your email. I have also attached the file. Thanks in advance

[@waseemlimbaliya6196]

Gentle soft reminder !!! Are you able to sort out my problem?

[@vanibaby8313]

Sir pls explain also for instead of select rows explain for selection address method also.

[@nikdrenski3003]

Instead of selecting rows, how would one select a cell with a defined name?

[@safeerahmed4474]

Hi sir I have 2 work books one which is always closed and the other file all the team members uses.. The workbook which is closed gets updated all the time using user form and I want to transfer data from closed workbook to an other active workbook and the command button is on active work book which copies data from closed to active... I need to know the code.

[@ExcelDestination]

you can take help for this task from the below given tutorial : kzbin.info/www/bejne/gHKweJKgmMmrkM0

[@joyrebello9513]

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

[@akshaytapadiya2239]

What if i want to copy each row of fix range (e.g. A1 to D1, A2 to D2, A3 to D3....) till row has data and i dont have destination workbook, for every row new workbook should be created with the same headings and one workbook name should be one cell of the copied row

[@ExcelDestination]

This can be done with some additional\different code. If you need that code, send email at [e-mail]

[@rahulwagh1678]

ho to only unique value need to add??

[@visejdoshi]

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

[@saymundandre4815]

good tutorial but how about the destination work book is already open

[@sanketnarkhede2585]

It gives error I guess

[@rvas1966]

Good one...I need to copy 10 rows of data with 12 columns... every 5 minutes after the updation of data... kindly guide

[@ExcelDestination]

for any excel vba project, you can write to [e-mail]

[@jamesmusontong2134]

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

[@loucruz5906]

what if i want to copy from a newly extracted file from sap then to another workbook

[@ashishkarkera-c8h]

If destination file is password protected, then do we need to share it with source file owners? Possible step to have my "destination file" password protected so "source file" owners will not update old data in my "destination file", but can only add new data in my "destination file" through your VBA code

[@sanketnarkhede2585]

How to select rows one by one using for loop

[@ExcelDestination]

for i=1 to 10 rows(i).select next

[@calvintai1210]

I have a report that I need to run on a daily basis, on the one tab I have the daily kpis, on another tab I have the MTD data. Can I use VBA to populate the MTD data?

[@ExcelDestination]

yes, you can surely populate MTD data using VBA Programming. For any Excel VBA Automation Project, you can write to [e-mail]

[@guruvenkatavamsi1482]

is there a way ,where we can copy or paste the data with out opening excel work book

[@ExcelDestination]

using code , you can copy and then close workbook. But, I feel without opening excel work book it is not possible in vba. Let me research. using formula, you can give reference in any workbook with another and data will be updated automatically.

[@Girirajansjc]

Life Saver

[@ExcelDestination]

Thanks

[@salmankhan-ql8tl]

How to select a path which is in one drive

[@shabarilucky5]

How to transfer multiple rows data in other sheet. As above we hv copied only row12.

[@ExcelDestination]

You can check another tutorial at kzbin.info/www/bejne/p3i9gnyibq99oZY

[@abhiabrahamthomas2993]

I got an error saying " Paste method of worksheet class failed" run time error '1004'. Could you please advise how to get rid of this error and proceed to pasting the values.

[@ExcelDestination]

without looking at code, I can not say anything, however, you can watch tutorial for Error 1004. Link is kzbin.info/www/bejne/Y4LTonmda9CChtk

[@qamruddinmohammedi7665]

Dear Sir, Want transfer data from one workbook to another. Workbook - A 1. Receipt No. 2. Date 3. Name 4. Amount To Workbook - B in two different Sheets can you please help to write correct VBA code.

[@ExcelDestination]

thanks for your comment. for any excel vba project work, you can write to [e-mail]

[@alializadeh8195]

Thanx

[@bassisessaidexcel]

Merci

[@funways746]

Can you share code

[@lakshman8208]

video was helpful but at the time of writing code, Please explain the function and use of command used so that we can also learn how to use codes.

[@shravankalva]

I have data in sheet one in column A i have item numbers and column B I have item names. I have 1000 rows. Out of these 1000 rows, If an item name example Apple is repeated 15 times, then in sheet 2 i need that apple name and randomly only one item number of that 15apples. If an item name example chocolate is repeated more than 16 and less than 25 times, then I need choclate twice and randomly two item numbers of chocolates. If the item name example computer is more than 25 and less than 35 I need in sheet 2 that computer 3 times and three computer numbers randomly. Please help me with macros on this.

[@ExcelDestination]

You can watch another tutorial to get some more VBA Code \ Code logic at kzbin.info/www/bejne/p3i9gnyibq99oZY

[@HarishKumar-xk6zy]

Hi

[@audhuttatkare3072]

Hey this code is not working

[@ExcelDestination]

send me your code at [e-mail]

[@audhuttatkare3072]

@@ExcelDestination hey I sent you the mail.. please check & let me know