Transfer data from one Excel worksheet to another automatically

[@vickiejohnson2451]

Thank you so much for your brilliant knowledge. I am working on a worksheet comparable to this same problem and honestly didn't think I would ever find an answer. You are the greatest! Thanks again!

[@Llb890]

I have seen many excel master you are also brilliant as well

[@Exceltrainingvideos]

Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/

[@mlktss245]

Thank you for the upload! It is easy to follow and understand. I also work at a call center trying to improve our data collection system. Thank you!

[@michaelhenderson5098]

Thank you for sharing this video. I used the thinking to copy data from two different sheets to a third for a running record of transactions. I know it has been 7 years, but still works for me.

[@Exceltrainingvideos]

Glad that the video was useful.

[@vikaskumar-nv8jg]

Sir ur videos are most important in my professional life thank for ur time 🙏🙏🙏🙏

[@wizard3117]

Dinesh you make this look easy...absolute genius you are. I've seen other videos on VBA but the way you teach it makes more sense. I will definitely be watching more of your videos...keep up the good work!

[@Exceltrainingvideos]

Thank you!

[@pallove123]

Hello Mr. Dinesh Thanks for all the time you spending to teach VBA (awesome) to people like me.I am a basic learner, your videos was very helpful for me to learn. I do have similar problems on excel in different level needed help.

[@Elchamuco100]

This is a very good video and thank you for posting. Although most users have trouble understanding Excel language (VBA). Why not just show a video recording a macro, that would be a much easier way to understand VBA. A recorded macro showing step by step would be simpler and more useful for most users, that way they can do other things that they may need with excel. Just a thought.... :)

[@james02Perry]

Sir, ur VBA teaching is very good. Thank u 4 sharing.

[@sahirytube]

Wow! I found it. This is the thing I was searching for. I think my problem will be solved. Thanks a lot.

[@Exceltrainingvideos]

You're welcome!

[@nagylaszlo100]

Thank you Sir! After hours spending on help everywhere else, your virtual class helped me with my problem.

[@losvecinos2024]

That was the problem.. I changed the 1 for an L... and did works OK!!!! Thanks!!!!

[@pankajprajapatvella4263]

Thanks You so much Dinesh ji, Your efforts made Our lives Easier... Thanks Alot for Sharing such Knowledges.

[@islamandtheworld8928]

Sir, I like your vedios so much... easy to understand and easy to use..

[@adesholaoluseun8086]

am really see this as great opportunity to acquire more on excel accounting package.God bless all d team o this site......keep it up

[@Exceltrainingvideos]

+adeshola oluseun Thank you!

[@MrPrasenjitbiswas]

Hi Tomichan joseph just few days back i have done the same thing for my organization.one of the easiest way to do this is by using VLOOKUP function. Add a serial number in marksheet format and a serial number in data for the mark list. the VLOOKUP function will pick up the row value corresponding to that serial number in sheet 2. Also add a SPIN BUTTON from developer tab in sheet 1. set the incremental value one and print property as false. On clicking the spin button the serial number on the sheet 1 will increase by one and VlOOKUP will automatically pick up its corrosponding values from sheet 2. Hope this will help you

[@annt2824]

Thank you. Your explanations are easy to follow.

[@jigsangeles2365]

You are really doing great!! I love your tutorials

[@Exceltrainingvideos]

Glad you like them! Please share the Excel VBA tutorial with your friends too.

[@karenmcneil4365]

By the way - this material has been invaluable!!

[@asokanth]

Good and really helpful which is easy to understand.

[@Exceltrainingvideos]

Please have a look at the videos on how to use a list-box on a user-form. Hope that helps.

[@caltory]

Good job! Thanks for the clear help with a common real-world situation.

[@losvecinos2024]

I did place the headers, and it is X1Down (Thanks for the follow up.... really appreciate!!!)

[@rhyanndejuan9250]

Mr. Dinesh your the man thanks for the tutorial.

[@uprphy6904]

Thanks Sir, did learn From your Useful Videos a lot. thanks

[@Exceltrainingvideos]

You are welcome. Please share with your friends also.

[@Exceltrainingvideos]

Sometimes you have to be patient till KZbin starts displaying data clearly based on your internet speed!

[@rangadeva6472]

Not working

[@blanlapa]

you are right that is because the correct is End(xlDown) and not End(x1Down)

[@bernardblumberg803]

Very good video. Well explained, Thanks.

[@onesri]

Own 4 rental properties. what I like to see is how each property is functioning/doing on a single sheet. I have for each property taxes, insurance, maintenance, yearly total rental, management fees. I like to see these on a single sheet with 4 different named properties. In addition, like to see the total loss and profit for all the 4 rentals. I also like to see bar graph next to each property for comparison. Thanks

[@ChristosG]

Thank you for your reply. I managed to test it already right after i wrote that reply. Usually i manage to find the answers when i think about them in clear-mind.

[@adityamal01]

Sir, this works very well for a single cell to copy. However I have a range of cells which i want to copy (e.g. from J9 to J22) then what should be the changes made in the code?

[@pavankumar.hanmandla]

Nice One......, Your detailing was awesome,,,,,,,

[@santoshkumarsethi1785]

Dear Sir thank you for sharing your knowledge. Your ideas have made my works very simple. What I thought about writing a Macro in excel has been made easy by you. But I would like to say that I have used it for the 1st time it worked well. Then I added the ClearContents. But It does not go to a next line in sheet2 & replaces the data in 2nd row. So please kindly comment in this regard. My code is written below: Private Sub CommandButton1_Click() Dim CustomerName As String, CustomerNumber As Double Worksheets("Sheet1").Select CustomerName = Range("B1") CustomerNumber = Range("B2") Worksheets("sheet2").Select Worksheets("Sheet2").Range("A1").Select If Worksheets("Sheet2").Range("A1").Offset(1, 0) "" Then Worksheets("sheet2").Range("A1").End(xlDown).Select End If ActiveCell.Offset(1, 0).Select ActiveCell.Value = CustomerName ActiveCell.Offset(0, 1).Select ActiveCell.Value = CustomerNumber Worksheets("sheet1").Select Range("B1:B2").ClearContents Worksheets("Sheet1").Range("B1").Select End Sub

[@gifts43602]

this was awesome, I have been doing regular roll-ups huge time saver thank you

[@vincysigma]

Thank you Mr.Dinesh.. wonderful tips..

[@Exceltrainingvideos]

Always welcome! Please share the VBA tutorials with your friends.

[@amit3547]

hi dinesh sir This is amit,I work in bpo sector ,we have to show the work which we do daily in our productivity sheet and send it to the person who collate the data ,so I want a button in a productivity sheet that automatically copy the filled cell and past it in another work workbook name "mastersheet" which will be on the desktop,so that the person who collate the data will save a lot of time

[@MrJoybhaumik]

Thanks, I appreciate the knowledge that you have shared. I will try and see more of it.

[@chadnile]

Great. It was clearly explained. Thanks a lot.

[@Exceltrainingvideos]

Click on File. Select Options. Click on Customize Ribbon. On the right-hand side under Main Tabs check Developer.

[@mohamedakram2362]

Hi Dinesh, your videos are very helpfull and have excellent knowledge in Excel, could you please load some more videos for VBA please for beginners like how to code in VBA please.

[@Exceltrainingvideos]

Pooja Patel: When you go back to sheet1, clear the data in the input cells with code.

[@mirzasefer5922]

Dinesh Kumar Takyar

[@SriBrahmavidPrasad]

Can this be done if the sheet you need to pull the data from is constantly changing?

[@karenmcneil4365]

I have a related question - Can I pull entire rows of data from one worksheet into another sheet based on information from one column? I need to feed all data for one department from my master spreadsheet into a separate sheet for just that department. Thank you!

[@nanakweku4111]

Great work Sir and would like to learn more from you Sir

[@Exceltrainingvideos]

In sheet2 did you add the headers Name and Customer Problem?

[@Exceltrainingvideos]

You have to learn Excel VBA in a structured manner. The complete structure has been described on my website familycomputerclub-dot-com under VBA - Microsoft Excel 2003 and VBA - Microsoft Excel 2007 on the home-page. I don't conduct classes for individual students at present.

[@anandar140]

Dear sir,m Thank you so much for wonderful VBA Video

[@weisseadler]

Superb! it can also be done much simpler by using the record macro and assign the macro to a shape object (button).

[@Exceltrainingvideos]

Check this video out: kzbin.info/www/bejne/joXHoJuNq7ekm7s

[@maryamjanahi333]

wow i was looking for a long time for this ! thanks alot

[@Exceltrainingvideos]

You first access the workbook, then the appropriate worksheet and then copy the relevant data into your template file.

[@vivekpagey1782]

Many thanks sir nice vedio ot helps every one allot

[@Exceltrainingvideos]

Did you place the headers in sheet2? Did you write xONEDown or XLONDONDown? x1 or xl?

[@bauer1969olivish]

Thank you for your time and thank you for sharing .. Many thanks

[@navagation]

Thank you very much, this was a big for my project!

[@mdanwarfaizi6590]

an outstanding video sir Thank you very much.

[@isaiaspablo2918]

hanks lot Sir.. You helping us..

[@chethangowda784]

Like that way you explained! Can have more video

[@jane4you1]

Thank you for your tutorial

[@Exceltrainingvideos]

Thanks for the feedback.

[@ehteshamshah]

Excellent Method of teaching.

[@Exceltrainingvideos]

xl = XL and NOT x1 = XONE

[@mervynmenezes1400]

Excellent Tutorial. Thank you.

[@goyaltraders3265]

Sir thanks aapko maine data send kar diya ha happy diwali

[@Exceltrainingvideos]

Happy Diwali!

[@narvill1888]

best tutorial sir

[@debashishchatterjee6412]

Thanks a lot. you saved my day.

[@angeladasilva6838]

hi Dinesh, giving it a look, many thanks.

[@195aditi]

The code works very well. How to extend this code to multiple entries? i.e., data in multiple cells to be transferred with one click of a button.

[@mustaffabinhassan8225]

Thanks a lot Sir. It was very useful indeed!

[@JuNi3001]

Thank you kindly Dinesh. A most helpful video indeed. I am currently looking for your code to refresh Sheet 1.

[@Exceltrainingvideos]

At 1.7 to 1.8 minutes of the video I've indicated that you can add more details.

[@ayeshasahiba]

great lessons thanks

[@yerbolsyzdykov4424]

Thank you, Sir! Very-very helpful!

[@Exceltrainingvideos]

Appreciate your feedback.

[@miongoloid]

awesome video! thank you so much for sharing.

[@shradhasharma8803]

Hello Mr Dinesh, your tip is really good to apply. I am also to apply this formula in my worksheets and it works fine. However, i am facing one issue rather than customer problem in number I have employee scores which should be in percentage. Please let me know the code for the same. Thank you so much.

[@Exceltrainingvideos]

Did you check your sheet names? You're using sheet1 and your sheet name may be totally different!

[@Exceltrainingvideos]

You're right! I've mentioned this in many videos and also commented. But where did you get 'downl'. It's just 'down'.

[@Exceltrainingvideos]

Yes. Watch the latest videos.

[@naveenrawat1535]

Easily to implement above code. Thanks!!

[@Achiko55]

a great presentation. Thank you

[@mjsalazar917]

Dinesh, Thank you Sir for the video. Your presentations are to the point and well presented. MSalazar - Centreville Virginia

[@Exceltrainingvideos]

mjsalazar917 Thanks for watching!

[@Exceltrainingvideos]

Did you place headers in sheet2 as I've shown in the video?

[@Exceltrainingvideos]

Just try out your code by adding a message box like: MsgBox "Sheet " & Worksheet(ws) & "selected!" You'll need to assign 'ws' a string value.

[@ladyprintboss]

thanks for always doing such great videos. how would i transfer specific data from cells in a workbook to 3 sheets instead of 2 . using a button?

[@jasoncalaycay304]

thanks for the tutorial ...

[@maheshsinhara]

i will check and btw you are superb

[@manish_chandra]

Very detailed video and more of teaching how to do than just show how itz done. :) I was looking for this but I have more than 1 cell to capture at the same time. ex in this scenario would be.. capturing 10 customers name at once and putting them int he other sheet. Trying to figure out how to do that. But thanks for this vid. Appreciate it.

[@Exceltrainingvideos]

You can capture as much data as is in your worksheet and transfer it to another worksheet to a relevant address. You just need to define the range! Also, please do a search on my channel to find the topic or solution of your interest. You may also like to visit my website: www.exceltrainingvideos.com Thanks.

[@manish_chandra]

Dinesh Kumar Takyar Thanks for the quick response. I'm tried changing the Range ("C4") to lets say Range ("C4:C14") but somehow it doesn't capture all. Lame way would be to copy paste the same forumula multiple times and just change the cell name. One more thing I need to do is make that Update click button automatic. Like it should click automatically every 2 mins instead of me clicking Update. Thanks for the website link. Very interesting and browsing through right now. :)

[@Exceltrainingvideos]

Have a look here: www.exceltrainingvideos.com/transfer-specific-excel-worksheet-data-range-from-one-worksheet-to-another/

[@Exceltrainingvideos]

Check your VBA code line by line and word by word especially any code like xlUP. It is XL and not x1.

[@Exceltrainingvideos]

That shouldn't matter as long as you have headers in the correct cells according your code.

[@ozziegarcia1]

Great video.

[@josylimabansag]

Thanks for the very informative video. :)

[@Jakhongir84]

Hello sir, this is amazing. Thank you very much for your video. It was very useful and very easy to u derstand. Could you please show us how to clear the cell automatically after we hit UPDATE button? I enter the data, then hit Update, but the old data is still there. Is it possible to have an empty cell after i hit update butto . Please let me know when you can. We are watching you all the ways from US. Thank you, Jack.

[@aatifkhan7628]

Best Tutorial !!!

[@EmalAmiri]

Great work

[@KoolGuyism]

Hello Sir, I want to transfer the data from one excel to the other excel in the below mentioned case. How would it be.? In "Excel Sheet 1" I am inserting a data in a cell for 1st Nov 2015. So, this data should be updated in the "Excel Sheet 2" in front of the date 1st Nov 2015. Now in "Excel Sheet 1" when i change the date to 2nd Nov 2015, then, in "Excel Sheet 2" data should be updated in front of the date 2nd Nov 2015, and so on.

[@ChristosG]

For anyone who would like to have the code for this is: Dim x As String x = Sheets("Sheet1").Range("Cell") 'Cell = Name of sheet - Reference

[@psreekarreddyp]

very good teach

[@essakhan1000]

Hi Dr, i appreciate the hard work you put in for this video. I under stood the whole programming but i want to do it using Range reference. Could you please help me on this Thanks in advance.... Regards, Essa khan

[@programminghub5964]

good job for learning

[@ShreeRamaHanuman]

Hi i am using Mac and Excel2011 can you help me how to do this .I tried to use the same VBA script but didnot work errors

[@sobhraj3670]

It is really helpfull.

[@MrRegcheeseman]

Thank you very much.

[@geraldinerichardson8747]

I find this very informative. How ever I am trying to solve this delima. I have a workbook with multiple worksheets. Each sheet is setup to display information for each individual. I would like each individual to see/read only their sheet. Example sheet 1 Mary. Sheet 2 Ann sheet 3 Betty Can I send the workbook to all of the, but how can I make so they can only see their sheet?

[@jamesperry3837]

*THANK YOU!*