Hi sir i just want to share that i successfully finished your video tutorial and also successfully finished it in excel. Thank you so much sir for taking time to show us your information for free. You are such a person! ❤
The very best UA-cam Excel Macro Tutorial I've ever watched. You're very unselfish in sharing your expertise for Free. You are an angel to many Excel VBA Beginners. It is very comprehensive and covered a lot of topics including the Debugging process to ensure that the codes are running correctly and covered also many other important techniques. A thousand Likes and Thank you very much. God Bless you Brother.
Hello sir , This Videos is amazing , thanks for sharing so much info. I want ask something if I have 5 Rows and I want to delete the 3rd row when I deleted The ID suppose to be 1 2 3 4 but the ID not change its like 1 2 4 5 and advice for this problem ?
Love this and built it today for my business, thank you! would you know if it is possible to capture the deleted line items and store in on a separate sheet? this would be very useful for historical records. also could you show me how to secure the document to prevent modifications but will allow data input into the management system
Hi, Thanks for Teaching me and making me update. it was really amazing to learn in easy way. but i have one quire. When we delete the entry from add items why it's not taking ID in continue way? (Exmple:- If I have adding 10 items and if i want to delete the 5th entry then below number are not coming in sequence) So just update me can we make it possible with VBA
Thank you so much for sharing. It's help me improve inventory for my small business.❤❤ Btw, I have a question about Userform on product list. I wanted to show all the data such as product code, product name, and remark in the box but when double click, it will fill only product code. can you tell me how to do it?
Great stuff. One issue that I encountered with this is when you delete an entry is that the ID is no longer incrementing correctly. For example, if you have 5 ID then delete the data or entry that is in ID 3, the ID data will show as 1, 2, 4 and 5 instead of 1,2,3 and 4.
Thanks for your comment. A good question. On deleting issue, it was built not re-use the same ID number in order not to overlapping with the ID number which is already removed from the list of inventory array. Otherwise, it might be confused later on, I think.
Great, easy to follow tutorial... Can you upload (or send to me directly) the XLS file w/ the VBA? I really like what you did and I'd like to include DATES (ReservedFrom & ReservedTo), which will add a lot of complexity but necessary for my use case. Thank you, in advance, for your consideration.
Hi, I am trying out this program and notice that when I choose export my values are not going down (E.G I have 150 import and when I add 50 export, the graph will show 150 import and 50 export) Could you help me with this? Much thanks and appreciation
this is a great tutorial just i faced one issue in the correction mode that once i click on a cell containg the thing i want to change and after correction its changing another cell with the same characteristics so imagine i have imported two products usually the correction is implemented in the one at the top
Hi Sir, thanks for sharing this amazingly useful video. I have encountered this "error 91 object variables not set, can u explain how to resolve this?🙏
Thank you for giving an extraordinary tutorial useful, sir. I have a problem sir. When I click the delete button, then I add the item again, the data is inputted on the lowest row (on the Row B1048576). Is there a way out for the problem? Thank You
Great tutorial Sir, Can you help me to fix this issue when I choose export my values are not going down for exemple if i have 100 pcs keyboard when I add 50 export, the graph will show 100 import and 50 export, as normal must show 50 import and 50 export.Thank you
After checking them, it is required a lot of things to do. It is unfortunately too much for me to do it. However, the next video will be sale receipt VBA. That might be partly cover up BOM part. Thanks for your understanding.
thanks so much for such a wonderful workdone. i have followed your procedure and i have been able to produce a wonderful work , but i am trying to report the vba codes in different sheets in same workbook though i will change some few variables and name but the approach will be same. i have tried that but i get minor errors in the sheet 2 though i used the module 2. can your please help me with that?
hello, sir. first off, great work. awesome exercise. My id counter keeps increasing when i make an edit to an old entry. For example, when i want to edit ID #2, i dbl click, make the edit, and now the ID # has changed to the newest increment. any suggestions?
Hello I’m having issues on part 19:40 of the video. After Inputing everything as displayed, when I click F5, it says the below: Run-time error: ‘1004’ Method ‘Range’ of object’_Global’ failed Plsssss help 😢
very nice inventory management system. can you make a management system of a seed inventory with login? so that it is more secure and only allowed person can access.
Hi MK-Tech, Thanks a lot for your inquiry. Kindly please share some more detail on fee management system for gym? More detail would be better for me to understand it.
Hi.. the code for worsheetfunction max dont accept the colon. I always get compile error. Thank u so much i am learning a lot.. hope u can answer me please. Appreciate it a lot 💜
I love Excel but you cannot replace this with a good ERP system. Supply chain is tied to billing and costing of products and tracking POs and item receipts. Great for a small mom and pop but not scalable. You would still need to ultimately migrate to a system that handles all.
Hi Imme, Thanks for the comment. There is a solution. Please go to the setting and the quality of video. Select the Full HD and it should work. My original video is Full HD, but somehow it shows blur sometime and sometimes not. Please let me know if it does not work.
"What Is VBA? Visual Basic for Application is a human-readable and editable programming code that gets generated when you record a macro. Today, it is widely-used with other Microsoft Office applications such as MS-Word, MS-Excel, and MS-Access."
Hi sir i just want to share that i successfully finished your video tutorial and also successfully finished it in excel. Thank you so much sir for taking time to show us your information for free. You are such a person! ❤
Wow!!! I am so happy to hear that. I hope that this video is helping your business. You are also so amazing. I wish you have a great day.
The very best UA-cam Excel Macro Tutorial I've ever watched. You're very unselfish in sharing your expertise for Free. You are an angel to many Excel VBA Beginners. It is very comprehensive and covered a lot of topics including the Debugging process to ensure that the codes are running correctly and covered also many other important techniques. A thousand Likes and Thank you very much. God Bless you Brother.
Thanks for sharing. There are so many concepts included. Great video.
Everything is very well explained in a factual and understandable way. Thank you very much for all your hard work and dedication.
A good video with easy steps. Thank you
This is some really great content. Highly practical and useful. Thanks
Thank you for your sharing. It's really a cool stuff.
Excellent! It is easy to follow tutorial. Thank you!!!👍👍👍👍👍
Thanks a lot. I really appreciate the effort. Just keep going!
선생님 엄청 능력자시네요 굿!!
Excellent brother and for the cleare explanation. Do more videos please👍👍👍👍👍
Thank you for sharing this. it's really helpful I appreciate it.
Thank you for your amazing comment.
Great Video, Thanks a lot
You are an amazing teacher! 😊😊😊
Thx you so much , Macro Tutorial I've ever watched ..good luck
The best tutorial I've ever watched 🥰🥰🥰
Great tutorial and easy to follow. Keep it up, bro.
Thank you for watching and your warm comment.
OMG thanks so much for this! It really helped me with building my Lab inventory system
You are amazing! Thank you for what you are doing!
Wow awesome dude. This is of such great help. Are you using korean excel?
Thanks and I hope that this video gives you some benefits for completing your task. I am using both Korean and English settings.
@excel-tutorial thanks! Yes very helpful tutorial really. It has very practical, simple and smart ways to handle complicate tasks.
You're very good keep it up you will soon get many Subscribers and views. 👍
Hello sir , This Videos is amazing , thanks for sharing so much info. I want ask something if I have 5 Rows and I want to delete the 3rd row when I deleted The ID suppose to be 1 2 3 4 but the ID not change its like 1 2 4 5 and advice for this problem ?
Thank you for sharing ❤ is it possible to add the start time and end time column? Similar to time tracker? Thank you so much
Love this and built it today for my business, thank you! would you know if it is possible to capture the deleted line items and store in on a separate sheet? this would be very useful for historical records. also could you show me how to secure the document to prevent modifications but will allow data input into the management system
did you ever figure this out? i want to do the same
I really like this
is there a way to make the selected row that is highlighted to get to a new sheet instead of being deleted
This was very usefull. Thank you very much.
HI can you make a stocks daily inventory like example for restaurant
Hi,
Thanks for Teaching me and making me update. it was really amazing to learn in easy way.
but i have one quire.
When we delete the entry from add items why it's not taking ID in continue way?
(Exmple:- If I have adding 10 items and if i want to delete the 5th entry then below number are not coming in sequence)
So just update me can we make it possible with VBA
Thank you so much for sharing. It's help me improve inventory for my small business.❤❤
Btw, I have a question about Userform on product list. I wanted to show all the data such as product code, product name, and remark in the box but when double click, it will fill only product code. can you tell me how to do it?
Hi zorsun, Thank you for watching the vdieo.
On your inquiry, please see at 40:57, you can control it as well.
I got the error message "rowNum is not defined" and it can not work. I don not know where the problem ist.
The solution would be go to name box and define rowNum. Then the issue will be gone, I think.
hi sir it give me error while i add rowSource in userform
Hi, Thank you for watching this video. Based on my guess, it would be a good idea to check the range of rowSource is correctly implemented.
I got the the same issue. Did you figure it out?
Great stuff. One issue that I encountered with this is when you delete an entry is that the ID is no longer incrementing correctly. For example, if you have 5 ID then delete the data or entry that is in ID 3, the ID data will show as 1, 2, 4 and 5 instead of 1,2,3 and 4.
Thanks for your comment. A good question.
On deleting issue, it was built not re-use the same ID number in order not to overlapping with the ID number which is already removed from the list of inventory array. Otherwise, it might be confused later on, I think.
@@excel-tutorial is there a way to get the ID incrementing correctly?
It is incrementing correctly. It's an ID, so it's unique to only that entry otherwise it would just be a count, if I'm correct
@@excel-tutorial
Hello sir
Okay but if I want to make the sequence go right if I deleted any row
Is there a way to do it?
Up. I also wanted to have this kind of feature.
would anyone help me?
As I follow step by step, but "variant is not support in automation VBA" msgbox is prompt.
Great, easy to follow tutorial... Can you upload (or send to me directly) the XLS file w/ the VBA? I really like what you did and I'd like to include DATES (ReservedFrom & ReservedTo), which will add a lot of complexity but necessary for my use case. Thank you, in advance, for your consideration.
Great sir can u make a fee management system for gym and highlited or generate report of fee dues
it says rowNum empty when i am at 26:56
hi and thank you for this really interesting video. a question... but how did you enter the calendar when selecting the date? Thanks for the reply.
Great video. How could you import the "raw data" to another sheet within the worksheet👍🏻
Hi, I am trying out this program and notice that when I choose export my values are not going down
(E.G I have 150 import and when I add 50 export, the graph will show 150 import and 50 export) Could you help me with this?
Much thanks and appreciation
Where can I downloaded this system?
this is a great tutorial just i faced one issue in the correction mode that once i click on a cell containg the thing i want to change and after correction its changing another cell with the same characteristics so imagine i have imported two products usually the correction is implemented in the one at the top
Please give download link
Hi Sir, thanks for sharing this amazingly useful video. I have encountered this "error 91 object variables not set, can u explain how to resolve this?🙏
Thank you for giving an extraordinary tutorial useful, sir. I have a problem sir. When I click the delete button, then I add the item again, the data is inputted on the lowest row (on the Row B1048576). Is there a way out for the problem? Thank You
Hello
Did you find a solution for this problem
Great tutorial Sir, Can you help me to fix this issue when I choose export my values are not going down for exemple if i have 100 pcs keyboard when I add 50 export, the graph will show 100 import and 50 export, as normal must show 50 import and 50 export.Thank you
Can you make manufacturing inventory management?
Hi bhavnesh parikh,
Kindly please tell me what kind of functions are necessary for the manufacturing inventory management?
@@excel-tutorial Create BOM and process wise matinee Production job order consumption finish product transfer to BSR and sold product
After checking them, it is required a lot of things to do. It is unfortunately too much for me to do it. However, the next video will be sale receipt VBA. That might be partly cover up BOM part. Thanks for your understanding.
thanks so much for such a wonderful workdone. i have followed your procedure and i have been able to produce a wonderful work , but i am trying to report the vba codes in different sheets in same workbook though i will change some few variables and name but the approach will be same. i have tried that but i get minor errors in the sheet 2 though i used the module 2. can your please help me with that?
Thanks
hello, sir.
first off, great work. awesome exercise. My id counter keeps increasing when i make an edit to an old entry. For example, when i want to edit ID #2, i dbl click, make the edit, and now the ID # has changed to the newest increment. any suggestions?
In case of manufacturing process ?
How to work?
Thank you. Sir
Do you make custom excel sheets for people ?
Hello I’m having issues on part 19:40 of the video. After Inputing everything as displayed, when I click F5, it says the below:
Run-time error: ‘1004’
Method ‘Range’ of object’_Global’ failed
Plsssss help 😢
Sir do you have warehouse inventory vba?
Have location, batch, mfg and tracing features? Thanks
very nice inventory management system. can you make a management system of a seed inventory with login? so that it is more secure and only allowed person can access.
hello ! have you found anything for seed inventory?
Sir make fee management system for gym thanks sir
Hi MK-Tech,
Thanks a lot for your inquiry. Kindly please share some more detail on fee management system for gym? More detail would be better for me to understand it.
Sir can u share u r email id plz
@@manoj9351
This is my e-mail address.
life96336@gmail.com
Thanks sir I send u detail asap
can you share the template bro ? :D
I need same but there need some changes. How I can contact you?
Hi.. the code for worsheetfunction max dont accept the colon. I always get compile error. Thank u so much i am learning a lot.. hope u can answer me please. Appreciate it a lot 💜
Hey how can I add a single toolbar for text search on the Userform
Help. When I’m adding a new item, it adds to the last row of the table not the first row. What can be done to fix this?
is it possible to have userform on macbook air?
im adding a item and it add in the main sheet but in the print sheet the additional item wont appear
thanks for the tutorials what if you have multiple products would this be convenient .please can you share the file
Hi sir how can it automatically update number when deleting item?
Bro can I get the template
Easy on Sim Registration o one
I have a problem in updating the data it will not reflect in the table and the formula I inputted was gone
I love Excel but you cannot replace this with a good ERP system. Supply chain is tied to billing and costing of products and tracking POs and item receipts. Great for a small mom and pop but not scalable. You would still need to ultimately migrate to a system that handles all.
Can i have that
Why you didn’t add a location, bin or store number?
very blur cant read the text
Hi Imme, Thanks for the comment. There is a solution. Please go to the setting and the quality of video. Select the Full HD and it should work. My original video is Full HD, but somehow it shows blur sometime and sometimes not. Please let me know if it does not work.
Vba meaning
"What Is VBA? Visual Basic for Application is a human-readable and editable programming code that gets generated when you record a macro. Today, it is widely-used with other Microsoft Office applications such as MS-Word, MS-Excel, and MS-Access."
Garcia Elizabeth Perez Karen Robinson Eric
Great sir can u make a fee management system for gym and highlited or generate report of fee dues