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!
@Llb8905 жыл бұрын
I have seen many excel master you are also brilliant as well
@Exceltrainingvideos4 жыл бұрын
Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/
@mlktss2456 жыл бұрын
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!
@michaelhenderson50985 жыл бұрын
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.
@Exceltrainingvideos5 жыл бұрын
Glad that the video was useful.
@vikaskumar-nv8jg5 жыл бұрын
Sir ur videos are most important in my professional life thank for ur time 🙏🙏🙏🙏
@wizard311710 жыл бұрын
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!
@Exceltrainingvideos10 жыл бұрын
Thank you!
@pallove1236 жыл бұрын
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.
@Elchamuco10010 жыл бұрын
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.... :)
@james02Perry11 жыл бұрын
Sir, ur VBA teaching is very good. Thank u 4 sharing.
@sahirytube2 жыл бұрын
Wow! I found it. This is the thing I was searching for. I think my problem will be solved. Thanks a lot.
@Exceltrainingvideos2 жыл бұрын
You're welcome!
@nagylaszlo1006 жыл бұрын
Thank you Sir! After hours spending on help everywhere else, your virtual class helped me with my problem.
@losvecinos202411 жыл бұрын
That was the problem.. I changed the 1 for an L... and did works OK!!!! Thanks!!!!
@pankajprajapatvella42639 жыл бұрын
Thanks You so much Dinesh ji, Your efforts made Our lives Easier... Thanks Alot for Sharing such Knowledges.
@islamandtheworld89285 жыл бұрын
Sir, I like your vedios so much... easy to understand and easy to use..
@adesholaoluseun80868 жыл бұрын
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
@Exceltrainingvideos8 жыл бұрын
+adeshola oluseun Thank you!
@MrPrasenjitbiswas10 жыл бұрын
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
@annt282411 жыл бұрын
Thank you. Your explanations are easy to follow.
@jigsangeles23654 жыл бұрын
You are really doing great!! I love your tutorials
@Exceltrainingvideos4 жыл бұрын
Glad you like them! Please share the Excel VBA tutorial with your friends too.
@karenmcneil436510 жыл бұрын
By the way - this material has been invaluable!!
@asokanth11 жыл бұрын
Good and really helpful which is easy to understand.
@Exceltrainingvideos11 жыл бұрын
Please have a look at the videos on how to use a list-box on a user-form. Hope that helps.
@caltory10 жыл бұрын
Good job! Thanks for the clear help with a common real-world situation.
@losvecinos202411 жыл бұрын
I did place the headers, and it is X1Down (Thanks for the follow up.... really appreciate!!!)
@rhyanndejuan92509 жыл бұрын
Mr. Dinesh your the man thanks for the tutorial.
@uprphy69044 жыл бұрын
Thanks Sir, did learn From your Useful Videos a lot. thanks
@Exceltrainingvideos4 жыл бұрын
You are welcome. Please share with your friends also.
@Exceltrainingvideos11 жыл бұрын
Sometimes you have to be patient till KZbin starts displaying data clearly based on your internet speed!
@rangadeva64723 жыл бұрын
Not working
@blanlapa11 жыл бұрын
you are right that is because the correct is End(xlDown) and not End(x1Down)
@bernardblumberg8037 жыл бұрын
Very good video. Well explained, Thanks.
@onesri10 жыл бұрын
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
@ChristosG11 жыл бұрын
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.
@adityamal0110 жыл бұрын
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.hanmandla11 жыл бұрын
Nice One......, Your detailing was awesome,,,,,,,
@santoshkumarsethi17859 жыл бұрын
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
@gifts4360211 жыл бұрын
this was awesome, I have been doing regular roll-ups huge time saver thank you
@vincysigma4 жыл бұрын
Thank you Mr.Dinesh.. wonderful tips..
@Exceltrainingvideos4 жыл бұрын
Always welcome! Please share the VBA tutorials with your friends.
@amit35478 жыл бұрын
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
@MrJoybhaumik10 жыл бұрын
Thanks, I appreciate the knowledge that you have shared. I will try and see more of it.
@chadnile11 жыл бұрын
Great. It was clearly explained. Thanks a lot.
@Exceltrainingvideos11 жыл бұрын
Click on File. Select Options. Click on Customize Ribbon. On the right-hand side under Main Tabs check Developer.
@mohamedakram23628 жыл бұрын
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.
@Exceltrainingvideos10 жыл бұрын
Pooja Patel: When you go back to sheet1, clear the data in the input cells with code.
@mirzasefer59227 жыл бұрын
Dinesh Kumar Takyar
@SriBrahmavidPrasad5 жыл бұрын
Can this be done if the sheet you need to pull the data from is constantly changing?
@karenmcneil436510 жыл бұрын
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!
@nanakweku411110 жыл бұрын
Great work Sir and would like to learn more from you Sir
@Exceltrainingvideos11 жыл бұрын
In sheet2 did you add the headers Name and Customer Problem?
@Exceltrainingvideos11 жыл бұрын
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.
@anandar1407 жыл бұрын
Dear sir,m Thank you so much for wonderful VBA Video
@weisseadler10 жыл бұрын
Superb! it can also be done much simpler by using the record macro and assign the macro to a shape object (button).
@Exceltrainingvideos10 жыл бұрын
Check this video out: kzbin.info/www/bejne/joXHoJuNq7ekm7s
@maryamjanahi33311 жыл бұрын
wow i was looking for a long time for this ! thanks alot
@Exceltrainingvideos11 жыл бұрын
You first access the workbook, then the appropriate worksheet and then copy the relevant data into your template file.
@vivekpagey17826 жыл бұрын
Many thanks sir nice vedio ot helps every one allot
@Exceltrainingvideos11 жыл бұрын
Did you place the headers in sheet2? Did you write xONEDown or XLONDONDown? x1 or xl?
@bauer1969olivish7 жыл бұрын
Thank you for your time and thank you for sharing .. Many thanks
@navagation10 жыл бұрын
Thank you very much, this was a big for my project!
@mdanwarfaizi65907 жыл бұрын
an outstanding video sir Thank you very much.
@isaiaspablo2918 Жыл бұрын
hanks lot Sir.. You helping us..
@chethangowda7846 жыл бұрын
Like that way you explained! Can have more video
@jane4you15 жыл бұрын
Thank you for your tutorial
@Exceltrainingvideos4 жыл бұрын
Thanks for the feedback.
@ehteshamshah10 жыл бұрын
Excellent Method of teaching.
@Exceltrainingvideos10 жыл бұрын
xl = XL and NOT x1 = XONE
@mervynmenezes14005 жыл бұрын
Excellent Tutorial. Thank you.
@goyaltraders32655 жыл бұрын
Sir thanks aapko maine data send kar diya ha happy diwali
@Exceltrainingvideos5 жыл бұрын
Happy Diwali!
@narvill18887 жыл бұрын
best tutorial sir
@debashishchatterjee64128 жыл бұрын
Thanks a lot. you saved my day.
@angeladasilva68389 жыл бұрын
hi Dinesh, giving it a look, many thanks.
@195aditi10 жыл бұрын
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.
@mustaffabinhassan822510 жыл бұрын
Thanks a lot Sir. It was very useful indeed!
@JuNi30018 жыл бұрын
Thank you kindly Dinesh. A most helpful video indeed. I am currently looking for your code to refresh Sheet 1.
@Exceltrainingvideos11 жыл бұрын
At 1.7 to 1.8 minutes of the video I've indicated that you can add more details.
@ayeshasahiba11 жыл бұрын
great lessons thanks
@yerbolsyzdykov44244 жыл бұрын
Thank you, Sir! Very-very helpful!
@Exceltrainingvideos4 жыл бұрын
Appreciate your feedback.
@miongoloid10 жыл бұрын
awesome video! thank you so much for sharing.
@shradhasharma88039 жыл бұрын
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.
@Exceltrainingvideos11 жыл бұрын
Did you check your sheet names? You're using sheet1 and your sheet name may be totally different!
@Exceltrainingvideos11 жыл бұрын
You're right! I've mentioned this in many videos and also commented. But where did you get 'downl'. It's just 'down'.
@Exceltrainingvideos11 жыл бұрын
Yes. Watch the latest videos.
@naveenrawat15355 жыл бұрын
Easily to implement above code. Thanks!!
@Achiko558 жыл бұрын
a great presentation. Thank you
@mjsalazar9179 жыл бұрын
Dinesh, Thank you Sir for the video. Your presentations are to the point and well presented. MSalazar - Centreville Virginia
@Exceltrainingvideos9 жыл бұрын
mjsalazar917 Thanks for watching!
@Exceltrainingvideos11 жыл бұрын
Did you place headers in sheet2 as I've shown in the video?
@Exceltrainingvideos11 жыл бұрын
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.
@ladyprintboss8 жыл бұрын
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?
@jasoncalaycay3046 жыл бұрын
thanks for the tutorial ...
@maheshsinhara8 жыл бұрын
i will check and btw you are superb
@manish_chandra10 жыл бұрын
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.
@Exceltrainingvideos10 жыл бұрын
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_chandra10 жыл бұрын
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. :)
@Exceltrainingvideos10 жыл бұрын
Have a look here: www.exceltrainingvideos.com/transfer-specific-excel-worksheet-data-range-from-one-worksheet-to-another/
@Exceltrainingvideos11 жыл бұрын
Check your VBA code line by line and word by word especially any code like xlUP. It is XL and not x1.
@Exceltrainingvideos11 жыл бұрын
That shouldn't matter as long as you have headers in the correct cells according your code.
@ozziegarcia110 жыл бұрын
Great video.
@josylimabansag11 жыл бұрын
Thanks for the very informative video. :)
@Jakhongir8410 жыл бұрын
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.
@aatifkhan762810 жыл бұрын
Best Tutorial !!!
@EmalAmiri10 жыл бұрын
Great work
@KoolGuyism8 жыл бұрын
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.
@ChristosG11 жыл бұрын
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
@psreekarreddyp10 жыл бұрын
very good teach
@essakhan100010 жыл бұрын
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
@programminghub59646 жыл бұрын
good job for learning
@ShreeRamaHanuman9 жыл бұрын
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
@sobhraj36708 жыл бұрын
It is really helpfull.
@MrRegcheeseman11 жыл бұрын
Thank you very much.
@geraldinerichardson87477 жыл бұрын
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?