Excel Tutorial: How to automatically copy data from one Excel worksheet to another

Excel Tutorial - How to automatically copy data from one Excel worksheet to another without using visual basic with usemybox

Remember to subscribe to Usemybox for computer how to videos in Excel, Word, Powerpoint, Windows, internet browsers and more.

Subscribe for More IT & Software How To Videos:

[wayando]

Thanks alot. I have been copy pasting manually data from one week to another fro like 5yrs now!

[starcruiserr]

Thank you so much for this. This is brilliant and going to make a huge difference to how I do things. Up to now all i used to do was copy and paste.

[InformationTechnologyZM]

Great tutorial - learned something - wonderful sharing

[nemanjapoluga]

Thank you so much! I lost two days to find this solution. God bless man!

[alexseyf]

I’m commenting just for the reply. Love the vid!

[BoostAndRedline]

Awesome help bro! Thank you so much for sharing

[nitishkumarzzzznitish]

Thanks... sddenly i required this formula and typed on youtube, , , , and whatsoever was in my mind I typed... your video was exactly what I required.. Thanks

[mowe]

How can we do this on a larger scale ? For example if I want to select a whole column to do this, or can it only be done individually cell by cell ?

[ujjwalsinghal]

Thanks buddy I was searching it and you gave me thanks a lot😍😍😍

[dan.d]

Great tutorial. What if I want the color format to also go to the cell on the other sheet as well as the data?

[aaronmapp]

How do I copy a formula across multiple cell while maintaining the 'Column' reference by having the 'Row' reference change? I tried using the $ sign in from of ONLY the Column letter (not the Row #), but it still locks BOTH the column and the Row.

[debaroondasgupta]

Hi,

Great video and Thanks a lot. But I have a question is there a way to automatically copy data from a raw sheet to distinct individual sheets?

For example: I have data with names and their age and I have 10 individual sheets for those names and I want to automatically send data to those page when I fill in information in the raw page with the concerned names?

Would appreciate any help!

Thanks and Regards,
Debaroon DasGupta

[saadshahab]

My workbook is getting very bulky,
what if i use this connection in second workbook to get the data as pivot table/chart in second one, will that help?
I won't mind if my second one slows down but it shouldn't be the case with my original/first workbook

[MrLOLJKZ]

How do you get the cell to remember the entry? Is that possible? So that a cell will remember every entry, despite deleting an entry and entering a new one in the first cell.

[soulfulart]

Thanks for this tutorial. Is there a way to automatically copy data from one workbook to another workbook?

[Sunnilocs]

Thanks for this! Is there a way to get this formula to copy down consecutive rows in the destination workbook? I want to be able to enter the text once in one workbook and have the formula populate the other one for me.

[rhomfhilaumiegalvez]

how about I enter a letter in sheet 1 then I want to pop up background color on column in sheet 2..please help
me on this matter..thank you

[PercentOS]

Be nice if you were copying and pasting multiple cells instead of using just one cell for your demonstration. That is maybe 4 cells across and 4 cells down for instance? Also what about copying these cells to an Excel spread sheet with a brand new title? How do I open Excel with 2 different titles where both sheets show?

[harisrafiq]

Hi I have tried moving cell containing B.yuei which gives error that it contains unrecognized data can i move the "." too?

[TheRiyazSaiyed]

i am copying through arrayformula to new sheet but sorting the source data changes destination lineup. How can i stop this from happening?