VBA Macro to Copy Data to Another Workbook 

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

Life Saver

thanks bro, this helps a lot, big thumbs up

Really very useful Video - love from Vienna

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

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!

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

Thanx

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

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.

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

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?

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.

SIR, HOW CAN WE TRANSFER SELECTIVE DATA FROM ONE SHEET TO SPECIFIC CELL OF OTHER SHEET IN SPECIFIC ROW?

Nice explanation.... 👌

can we apply it in macro-enable workbook ?

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

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

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

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

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

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.

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

Merci

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

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

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.

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

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

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

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

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

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

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

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

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?

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

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

ho to only unique value need to add??

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.

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

How to select a path which is in one drive

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

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

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.

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.

How to select rows one by one using for loop

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

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.

Can you share code

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.

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.

Hi

Hey this code is not working