VBA Macro to Copy Data to Another Workbook
Вставка
- Опубліковано 24 сер 2019
- 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.
Your videos are very helpful and easy to understand brother. Keep up the good work!!
Glad to hear that!
thanks bro, this helps a lot, big thumbs up
sir! really nice demonstration, i improvised and expanded avenue on top of this. Best regards!
Excellent
Thank you boss... How do I select and paste a range of rows and columns rather then an entire row?
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!
what is the Vba code for selecting some particular columns and filtered DATA?
Really very useful Video - love from Vienna
Thanks
Hi what about if i need to paste values not formulas. My cells contain formulas but i need to transfer values
can we apply it in macro-enable workbook ?
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?
Boss.. how can use last row instead of row 12
Instead of selecting rows, how would one select a cell with a defined name?
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
what if we just want to copy a single column from source to our destination workbook
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.
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.
some extra code would be required.
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
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.
Sir
Pls tell me how to record macro in the workbook(in which already some formulae present)
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.
Nice explanation.... 👌
Thanks
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...
Thanks for watching. For any Excel VBA Support, you can write to exceldestination@gmail.com
Thank you for the tutorial. Can this also be applied to sheets with subtotals?
Thanks for watching! I haven't checked. You can give it a try and let me know also.
@@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
ho to only unique value need to add??
Hi...I have multiple source workbook range cell to copy in destination file specific range cell. Without opening source workbook. Pls help
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
This can be done with some additional\different code. If you need that code, send email at EXCELDESTINATION@GMAIL.COM
what if i want to copy from a newly extracted file from sap then to another workbook
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
For any Excel VBA Project, you can write to exceldestination@gmail.com
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
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?
yes, you can surely populate MTD data using VBA Programming. For any Excel VBA Automation Project, you can write to exceldestination@gmail.com
is there a way ,where we can copy or paste the data with out opening excel work book
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.
Merci
I have a question about this work . If I need to transfer data form user form to another worksheet . How to do ?
For UserForm and Sheet interactivity, you can watch another tutorial at following link :
ua-cam.com/video/1kpRa0Z6-9g/v-deo.html
What is the modification in case i have to copy multiple rows?
This was sorted, I did it the same day
Sir pls explain also for instead of select rows explain for selection address method also.
good tutorial but how about the destination work book is already open
It gives error I guess
How to transfer multiple rows data in other sheet. As above we hv copied only row12.
You can check another tutorial at ua-cam.com/video/qGZQIl9JJk4/v-deo.html
How to select a path which is in one drive
Do we still need code further if we save, I mean wb nothing onward?
no
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.
you can take help for this task from the below given tutorial :
ua-cam.com/video/JAMG_jcdxZk/v-deo.html
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.
without looking at code, I can not say anything, however, you can watch tutorial for Error 1004. Link is
ua-cam.com/video/-QpqFg6kOPw/v-deo.html
Good one...I need to copy 10 rows of data with 12 columns... every 5 minutes after the updation of data... kindly guide
for any excel vba project, you can write to exceldestination@gmail.com
Life Saver
Thanks
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.
please share your requirement at exceldestination@gmail.com
@@ExcelDestination Sir Please Check your email. I have also attached the file. Thanks in advance
Gentle soft reminder !!! Are you able to sort out my problem?
How to select rows one by one using for loop
for i=1 to 10
rows(i).select
next
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
ok. let me try.
@@ExcelDestination thanks
@@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
Thanx
I want to copy selected range.... Pl reply.. 🙏
Sorry sir
Mr. Vimal Kishor Gupta
The owner of this channel is no more
Can you share code
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.
thanks for your comment. for any excel vba project work, you can write to exceldestination@gmail.com
Hi
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.
You can watch another tutorial to get some more VBA Code \ Code logic at ua-cam.com/video/qGZQIl9JJk4/v-deo.html
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.
Hey this code is not working
send me your code at exceldestination@gmail.com
@@ExcelDestination hey I sent you the mail.. please check & let me know