How to Copy Data From One Worksheet to Another Automatically In Excel

In this tutorial, I’ll show you how to transfer or copy data from one excel worksheet to another automatically in excel. If you select any cell and press the Keyboard Shortcut CTRL + Shift + C, it will copy that entire row and paste it to the next empty row of another worksheet in excel. Remember, this will copy data from one excel sheet to another in excel automatically with the same format.
I’ll be creating a macro in this tutorial and I’ll be doing that using macro recorder. No hard-coded macro. Just let the recorder understand what you need and it’ll write the code automatically. After a little tweak, it’ll be able to pull data or information from one worksheet to another sheet based on criteria. The criteria will be active cell in this occasion.

Before starting let’s watch some related tutorial of this channel:

Now, without further ado, lets learn the process of copying cells from one excel worksheet to another worksheet in excel.

Now let’s go to the code and Tweak it in a way that if we select a cell and run the macro it’ll copy the entire row to the destination worksheet. If you click on the Developer tab - Visual Basic - Module and if you double click on module 1 you’ll find the code. Now if you change the code like I said in the video you’ll be able to tell excel to pull data or information from one sheet to another sheet based on criteria. Here the criteria will be selecting the entire row of the active cell. Now if you select any cell and Press the keyboard shortcut CTRL + Shift + C you’ll be able to command excel to copy cell or value to another sheet.

If you want you can create a button to copy data from one table to another also. Just follow the instructions in the code and it’ll be done. But before learning how to copy data from one excel sheet to another in excel automatically with same format you need to ensure the below prerequisites:
1. The destination sheet must have Row 1 & 2 Pre-occupied.
2. You must ensure the switching part of the macro recorder.
3. You must tweak the code and match it to the video.

So, this is how I tell excel to pull data or information from another sheet based on criteria automatically using VBA code generated with macro recorder.

#CopyData #AnotherSheet #Automatic

Thanks for watching.
-------------------------------------------------------------------------------------------------------------
Support the channel with as low as $5
-------------------------------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial

Here goes the most recent video of the channel:

Playlists:

Social media:

[chandrasharma]

Thanks, This is Made my Day. I was looking this since long to make an estimation of building, wanted to copy row from multiple sheets to final data sheet.

Thankfully!!

[JoseTorres-ellw]

I love this and want to use it a little different. I would like to do this using your same data as example. Copy all data that states “Done” to new sheet.

[chi.kim]

Thanks, exactly what I was looking for..

[sandeshgowdru]

Awesome this was so helpfull
This concept has so much applications and potential
Thanks alot for shareing this knowldge

[younimoon]

thanks Chandra so helpful, but what if we need copy some data has formulas, many Thanks

[YaroslavGorenich]

Is there any possibility to copy all tabs from one spreadsheet to another automatically?

[CookingKhiladi]

What if I want to copy paste 5 - 6 rows at a time to another sheet, if same procedure what I need to change in the code ...

[paragvartak]

Hi thanks for sharing video...I have one query..after copying row, I want to combine 2 cells in one....how will I do that?

[zeus]

Hey can the selection be done automatically for this particular case? I only wanted to select the data for the first update and not for the rest.

[promitasingh]

If we delete data from master sheet , then data from other sheet also delete?

[zanderhuynh]

How do you select many row instead of one?

[brehoffm]

Thank you, I was able to replicate this but the issue I’m having is with multiple worksheets. How can I I tell it to copy data from the worksheet I am on (sheet 3, sheet 4). The code only copies SHEET 2. Thank you!

[marmar]

Sir good night. I got my I.T. SBA to do but giving some problem

[tristanpauljavier]

How to do this on a cell with a formula? Because I tried to copy a cell with the formula and paste it to another sheet using your process, but, the cell where I paste what I copy shows "#REF!". Thank you!

[carljefferson]

ctrl + down brings me in the end of rows, why?

[Loved_evolved]

Hey, I would like to speak to you directly. I have some questions about excel and I was led to your video, can I have an email.