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!
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.
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!
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.
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?
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.
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.... :)
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.
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.
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. :)
This guide was fantastic! Thank you! Is there any way to have it delete the information on the first sheet after it copies it over to the second sheet?
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!
great video on this topic. Question, what would the code be, if you wanted to use a dropdown box for the customer name to update a particular sheet tied to the customer-specific?
This link will guide: www.exceltrainingvideos.com/tag/how-to-ensure-entry-of-data-only-from-combobox-drop-down-list/ You can also search this channel or my website www.exceltrainingvideos.com
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
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.
This was exactly what I have been looking for :) If I wanted to delete the data previously entered once returning to cell C4 on sheet1 is there another step I can enter?
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.
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
Hi computer club,,, Your videos are really helpful,,, i have a requirement..im working fully excel based job..i need to create a multiple sheet on single click which contans different names
Really like the way, Having an issue once I create my own file for macros, If you can help. Please let me know how I can send you create data file with VB program for Macro, so that you can check and let me know the mistake why its not working on my end. If you can help I will appreciate. Thanks
Mr. Takyar I love your videos. I am currently trying to put together an expense database that would use User From to input the data and update itself every time I close the application. any thoughts??The fields i want to use are Date, Store or Services, Description, Category, and Amount.
JOSE AVILA Please have a careful look at all the 4 videos starting here:@4CFoPl99FpgFor more details you can view this link:@tag/database-management-using-excel-userform-with-vba/
Hello Dinesh Kumar Takyar. Your videos helped me a lot. I copied your code here from your link and tested it. It works fine, but i want to have two text cells, instead of one with text and a number. What i have to change in the code?
Dinesh. Your code works great. I am trying to update not only one sheets but two with the same data.. How would I use this code to update two sheets with the same information?
Sir, Very informative session I have a small issue i have copied this code and done but after second entry it is deleting the second entry and pasting the third entry on same column of second kindly advice
Have a look at this video: youtudotbe/YLxnmyYCis8. Replace 'dot' with '.' How to transfer data from one workbook to another automatically using Excel VBA
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
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.
Get the book Excel 2016 Power Programming with VBA: amzn.to/2kDP35V If you are from India you can get this book here: amzn.to/2jzJGqU Or visit www.exceltrainingvideos.com to learn more for free.
This was very helpful. It would also be helpful to use this on a master sheet, which then updates subsequent sheets depending on which sheet it belongs to. I want to use this to create a workbook that assigned responsibilities to different people who have a sheet assigned to them. When I put the data in the master list, I want it to populate the data in the correct person's sheet so that when they click their sheet, they only see their data, and not the other person's. Do you have a way to do that?
This link will help: www.exceltrainingvideos.com/transfer-specific-excel-worksheet-data-range-from-one-worksheet-to-another/ You can also search my website www.exceltrainingvideos.com for many more solutions related to your query.
Hello, thank you for your video and explanation! How it works if I have hundrends of worksheets? Then how to link certain cells from each sheet to cells in a master sheet? So far I didn't find a way to do tad, so I hope that you could help me with this! Thank you in advance!
Hi Dinesh great video as i am a newbie to excel. I have 2013, it all works well bar when i click the command button the info copies over the last entry. could you please advise
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
Sirji you post really informative videos. 1 que. Sir Hi, I have my Excel file which is updated through an odbc connection. But how can I sync that Excel data into Google Sheets that could be updated automatically in periodic intervals but without using 3rd party connectors. Any Solution? Thanks
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!
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.
Glad that the video was useful.
I have seen many excel master you are also brilliant as well
Please share with your friends and on social media. You can view more videos in Hindi and English at www.exceltrainingvideos.com/
Wow! I found it. This is the thing I was searching for. I think my problem will be solved. Thanks a lot.
You're welcome!
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!
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!
Thank you!
Sir, ur VBA teaching is very good.
Thank u 4 sharing.
You are really doing great!! I love your tutorials
Glad you like them! Please share the Excel VBA tutorial with your friends too.
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.
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
+adeshola oluseun Thank you!
By the way - this material has been invaluable!!
That was the problem.. I changed the 1 for an L... and did works OK!!!! Thanks!!!!
Sir ur videos are most important in my professional life thank for ur time 🙏🙏🙏🙏
Thank you Sir! After hours spending on help everywhere else, your virtual class helped me with my problem.
Thanks Sir, did learn From your Useful Videos a lot.
thanks
You are welcome. Please share with your friends also.
Sir, I like your vedios so much... easy to understand and easy to use..
Thank you. Your explanations are easy to follow.
Thanks You so much Dinesh ji, Your efforts made Our lives Easier... Thanks Alot for Sharing such Knowledges.
Nice One......,
Your detailing was awesome,,,,,,,
Thank you Mr.Dinesh.. wonderful tips..
Always welcome! Please share the VBA tutorials with your friends.
Very good video. Well explained, Thanks.
Good and really helpful which is easy to understand.
Mr. Dinesh your the man thanks for the tutorial.
In sheet2 did you add the headers Name and Customer Problem?
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?
I did place the headers, and it is X1Down (Thanks for the follow up.... really appreciate!!!)
Good job! Thanks for the clear help with a common real-world situation.
this was awesome, I have been doing regular roll-ups huge time saver thank you
Sir thanks aapko maine data send kar diya ha happy diwali
Happy Diwali!
Dear sir,m
Thank you so much for wonderful VBA Video
Please have a look at the videos on how to use a list-box on a user-form. Hope that helps.
Pooja Patel: When you go back to sheet1, clear the data in the input cells with code.
Dinesh Kumar Takyar
Great work Sir and would like to learn more from you Sir
Did you place the headers in sheet2? Did you write xONEDown or XLONDONDown?
x1 or xl?
Very nice ❤
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.
Excellent Method of teaching.
xl = XL and NOT x1 = XONE
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.... :)
Many thanks sir nice vedio ot helps every one allot
Great. It was clearly explained. Thanks a lot.
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.
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.
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. :)
Have a look here: www.exceltrainingvideos.com/transfer-specific-excel-worksheet-data-range-from-one-worksheet-to-another/
This guide was fantastic! Thank you!
Is there any way to have it delete the information on the first sheet after it copies it over to the second sheet?
an outstanding video sir
Thank you very much.
hi Dinesh, giving it a look, many thanks.
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!
Like that way you explained! Can have more video
Thank you, Sir! Very-very helpful!
Appreciate your feedback.
great video on this topic. Question, what would the code be, if you wanted to use a dropdown box for the customer name to update a particular sheet tied to the customer-specific?
This link will guide: www.exceltrainingvideos.com/tag/how-to-ensure-entry-of-data-only-from-combobox-drop-down-list/
You can also search this channel or my website www.exceltrainingvideos.com
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
Sometimes you have to be patient till TH-cam starts displaying data clearly based on your internet speed!
Not working
Did you place headers in sheet2 as I've shown in the video?
hanks lot Sir.. You helping us..
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.
Thanks, I appreciate the knowledge that you have shared. I will try and see more of it.
This was exactly what I have been looking for :) If I wanted to delete the data previously entered once returning to cell C4 on sheet1 is there another step I can enter?
Thanks a lot Sir. It was very useful indeed!
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.
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
Thank you very much, this was a big for my project!
Thank you for your tutorial
Thanks for the feedback.
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.
i will check and btw you are superb
Excellent Tutorial. Thank you.
wow i was looking for a long time for this ! thanks alot
Hi computer club,,,
Your videos are really helpful,,,
i have a requirement..im working fully excel based job..i need to create a multiple sheet on single click which contans different names
Thank you kindly Dinesh. A most helpful video indeed. I am currently looking for your code to refresh Sheet 1.
Superb! it can also be done much simpler by using the record macro and assign the macro to a shape object (button).
Check this video out: th-cam.com/video/XTdohWvRqeY/w-d-xo.html
you are right that is because the correct is
End(xlDown)
and not
End(x1Down)
Thank you for your time and thank you for sharing .. Many thanks
Click on File. Select Options. Click on Customize Ribbon. On the right-hand side under Main Tabs check Developer.
Dinesh, Thank you Sir for the video. Your presentations are to the point and well presented.
MSalazar - Centreville Virginia
mjsalazar917 Thanks for watching!
Yes. Watch the latest videos.
Thanks a lot. you saved my day.
awesome video! thank you so much for sharing.
Really like the way, Having an issue once I create my own file for macros, If you can help. Please let me know how I can send you create data file with VB program for Macro, so that you can check and let me know the mistake why its not working on my end. If you can help I will appreciate. Thanks
Mr. Takyar I love your videos. I am currently trying to put together an expense database that would use User From to input the data and update itself every time I close the application. any thoughts??The fields i want to use are Date, Store or Services, Description, Category, and Amount.
JOSE AVILA Please have a careful look at all the 4 videos starting here:@4CFoPl99FpgFor more details you can view this link:@tag/database-management-using-excel-userform-with-vba/
Hello Dinesh Kumar Takyar. Your videos helped me a lot. I copied your code here from your link and tested it. It works fine, but i want to have two text cells, instead of one with text and a number. What i have to change in the code?
Dinesh. Your code works great. I am trying to update not only one sheets but two with the same data.. How would I use this code to update two sheets with the same information?
Pedro Robles Use the code for the other sheet also!
Sir, Very informative session
I have a small issue
i have copied this code and done but after second entry it is deleting the second entry and pasting the third entry on same column of second
kindly advice
Easily to implement above code. Thanks!!
a great presentation. Thank you
thnx sir,very useful,could you plz help me out to filter data in excel sheet based on listbox above the data e.g by country data selection.
Have a look at this video:
youtudotbe/YLxnmyYCis8. Replace 'dot' with '.'
How to transfer data from one workbook to another automatically using Excel VBA
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
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.
Thanks for the video, I would like to do this but for multiple rows how would I do this?
Dear Sir, really good work. I have similar requirement where
nice tutorial sir, can you make example using value of 1,0 or true ,false instead of command button. thanks!
Get the book Excel 2016 Power Programming with VBA: amzn.to/2kDP35V
If you are from India you can get this book here: amzn.to/2jzJGqU
Or visit www.exceltrainingvideos.com to learn more for free.
This was very helpful. It would also be helpful to use this on a master sheet, which then updates subsequent sheets depending on which sheet it belongs to. I want to use this to create a workbook that assigned responsibilities to different people who have a sheet assigned to them. When I put the data in the master list, I want it to populate the data in the correct person's sheet so that when they click their sheet, they only see their data, and not the other person's. Do you have a way to do that?
This link will help: www.exceltrainingvideos.com/transfer-specific-excel-worksheet-data-range-from-one-worksheet-to-another/
You can also search my website www.exceltrainingvideos.com for many more solutions related to your query.
first thanks a lot, Yes but in short form like in sheet1 Cofficent of performance and in sheet2 it's name is COP. is it fine or wrong?
Hello, thank you for your video and explanation!
How it works if I have hundrends of worksheets? Then how to link certain cells from each sheet to cells in a master sheet? So far I didn't find a way to do tad, so I hope that you could help me with this! Thank you in advance!
Try it out! If you have hundreds of sheets then use arrays.
Have a look at this video: Consolidate Data from Multiple Excel Workbooks using VBA
youtudotbe/oEgp_RjAoAY - replace 'dot' with '.'
thanks very much but i have a question if i want to take a cell value and merge it in middle of text cell
Hi Dinesh
great video as i am a newbie to excel. I have 2013, it all works well bar when i click the command button the info copies over the last entry. could you please advise
If Worksheets("receipt").Range("A6").Offset(1, 0) "" Then
Worksheets("receipt").Range("A6").End(xlDown).Select
I have used "L" and not "1"
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
How do I add more columns? The video was super helpful but i have 5 rows in sheet1 that need to be transferred to 5 rows in sheet2. Thanks!
+Breanne L This link might help: www.exceltrainingvideos.com/copy-paste-multiple-rows-of-data-from-one-workbook-to-another-using-excel-vba/
Thanks for help Sir!!!!
God bless you!!!!! :)
+Ajay Patil Thank you!
+Dinesh Kumar Takyar Thaanks for this outstanding explanation on excel thanks so much bro
Can you tell me if Excel 2002 will support this? That's what our department uses.
Hi there.
Thanks alot for det video. This is not automaticly bcz I have to klick on the Botton to transfer the data.
Sirji you post really informative videos. 1 que. Sir Hi,
I have my Excel file which is updated through an odbc connection. But how can I sync that Excel data into Google Sheets that could be updated automatically in periodic intervals but without using 3rd party connectors. Any Solution?
Thanks