Thanks so much Wayne. My first few videos were like this, then I kinda got away from it to try to create more complex applications. But based on the high views of this video, I really must return to this style of teaching, in some instances, since I believe it is easier to learn. It's a fine balance between people who think "yeah i know these steps already" to those who are thinking "oh wait, how did he get to that step?" I plan to release some comprehensive courses in the near future that get deep into the training and feature of large applications such as Reports Dashboards, Accounting, Scheduling, etc. Thanks so much for your extremely valuable feedback.

Hi Randy.. thanks and understood. I use the KZfaq playback speed to go faster or slower through sections that I feel I know more or less well. Even for something where I think I know the steps, I find that I learn something anyway by watching how a third party approaches it. I get that some might be impatient about that.. can't satisfy everyone. I look forward to your courses. If offered for a fee, I hope you host them on something like Udemy. I've taken a few paid courses there and like the interface and overall environment. If offered for free, well.. even better for all of us consumers out here. EXCEL is like a gold mine.. the deeper you dig, the more value you get. Thanks again for your generosity with the free tutorials.. much appreciated and I'll definitely consider your paid courses in the future, if that is how they are offered. Thumbs up!

@Wayne, I agree totally, couldn't have said it better myself. The learning is seeing it come together step by step. It is much easier to follow along then trying to check after completion all the code and how it all interacts.

Hi Wayne, thanks so much for your response. That helps me determine how to approach new training so I can better serve people. The courses will be comprehensive 15 - to 20 hours and I will host them on my own website (www.ExcelForFreelancers.com ), however it will be very similar to the Udemy format. I will make sure to set them at a very fair price, and to include a ton of value. Thanks again for your valuable feedback :)

@krn14242 Thanks very much for your insights. its great feedback to get so I can create more engaging lessons in the future. Much Appreciated!

For sure, you are very welcome and thanks so much. I am really glad you enjoyed the training.

WOW! Thanks so much for your great comment. I am so happy to help you learn and grow. Excel is like a blank canvas and we can great our own art right on it, and provide solutions to common problems in the world. (at least that is the way I see it) I will have some comprehensive courses coming out soon so stay tuned. If you have not done so yet, please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel

HI and thanks so much. Within databases, I use row 1 for the data mapping, but yes you should be careful if you delete rows or columns, data mapping must be updated.

Which Code would you use then? I have this Problem

Thanks Ian I really appreciate the feedback. I realize I must do more of the Build From Scratch in future videos. This one was not so complex so it was a bit easier, but the more complex ones would probably be separated over multiple weeks. Many people seem to agree with you, so your feedback is super helpful. Thanks so much.

Thanks so much Geert, As you know I always appreciate your feedback and comments. I am really glad you liked this one.

Thanks so much Nikki, and great to have you in our Excel For Freelancers Facebook Group as well.

Hi Tony, thanks so much for your comments, feedback and suggestion. I will also add it to my version so that anyone who downloads this in the future will also get this benefit. Much appreciated.

@@ExcelForFreelancers What is it necessary for?

Thank you so very much, I really appreciate that Leandro.

Hi Danny, thanks so much for your comment. I use Excel 2010 to create these applications and almost everything will work in 2007 that will work in 2010 (excel grouping shapes and Active X objects together) That is new and was introduced in 2010. I want people to be able to use the tricks and techniques I teach regardless of the Excel version they are using. Thanks so much.

For sure, you are very welcome and I really appreciate your comment and feedback. I realize this format of starting from the beginning is very helpful so I will continue to do more of this style of training.

kzfaq.info/get/bejne/qrR4gpuBua-Ye6s.html

Thanks very much, I am glad you liked it. I will continue to build applications from scratch. Much appreciated.

Thank you so very much, I really appreciate that and great to have you in the Mentorship Program. Much appreciated.

Hi thanks so much. I do appreciate that. I realize i must do a lot more 'from the beginning' as people seem to really like to watch every step. I thought it might be a bit boring, but seems to be popular. Thanks so much for the feedback.

Thank you so very much, I really appreciate that Victor.

HI thank you for your question Xavier. I don't think a frame would help however you would just want to determine the maximum width and height of a picture, then use those max values to set the picture height or width depending up which is greater, and maintaining the aspect ration.

Thanks so much Larry, I am really glad you like the lessons. I look forward to bringing you many more in the near future.

Thanks so much Robert, I really appreciate that. I think i am OK with designs but i have seen some people do amazing jobs with colors and designs. I also have a great dashboard you might be interested in the Employee Manager series here on KZfaq or a full course here: www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass

Thanks very much for your comment and feedback. Much appreciated. I look forward to bringing you new and exciting videos each week.

Thanks so much Jim, I really appreciate your comment. Check out our latest series, Employee manager for more comprehensive designs and features right here in KZfaq

@@ExcelForFreelancers ВВ ВДДДВДД Щзжвзж ВДЧВДДВДВ Вдзддчвддвдв ддзюдо вввдаьвввдаь ддввдж дождь все Ввечдджд в дверь всчввввввевядч👤 все равно все зависит в что двввввь ждать Ядвддаав двдвдв за что я тебя люблю чвтебя Вавввявя ➡ВВ ВВ ВВ и тебя люблю ЖВЖТВВВВ Ваввввввввввввввввввввдвсвввввввявя вчвв в

Д ввввввввввввввввввввввввввввдввввдввв вввввввввввввввдвсввввввщвявяв ВВ в вввввввввввввввдвсввввввщвявяв ВВ и все все все все время Вчвввввввввдввввввввввввввввввввввдвввввввв все в вввввввввввввввдвсввввввщвявяв Вжввввввввввввввввввввввввввзввввввввввв в вввввввввввввввдвсввввввщвявяв Вчвввввввввдввввввввввввввввввввввдвввввввв Вчвввввввввдввввввввввввввввввввввдвввввввв все вот Вчвввввввввввввввввввввввввввввввввввввввввввчвввв в вввввввввввввввдВВчавадвввлвжвввввввввввввввдввчавадвввлвжвчвввввввжвжжвжжвжвжвжввиввввввчвввжчжвжччвввввдввщввтвввввывдвдвчэввжвжвввввявввввв ивдввдвввв вот вв

HI thanks so much. I often do used named ranges right in the VBA, In the Employee Manager Series this is quite common. Thanks so much for the comments and suggestions.

Happy to help and thanks so much Susan. Thank you for your Likes, Shares & Comments. It really helps.

For sure you are welcome I am happy to share that. I also programmed for many years without figuring out how to map data like that. This has also saved me tons of programming time. I am happy to help.

Thanks so much Dante, I really appreciate that. I am going to add some amazing Automation in Parts 4 and 5 so please watch each week. Thanks again.

For sure, you are very welcome Thao. I am so happy I can help. Cam on em. :)

@@ExcelForFreelancers OMG, you speak vietnamese to me, how kind you are

Thanks so much. I am trying to learn. I have lived in Vietnam the last 5 years, now in Da Nang :) I love it here.

Excel For Freelancers oh yes, it sounds great, we’re quite close. now i’m living in Sai Gon, however, Da Nang is my father’s hometown. I think you’re facing a tough time there, right? Da Nang is now a corona disease spot :(

HI yes still on lockdown here but hopefully over soon. Otherwise safe here and just working. Thanks so much. Great city here.

Hi Leo, thanks so much for your comment. There is a great, basic VBA course you can take here: www.excelvbaisfun.com/ExcelForFreelancers_Discount/ I hope this helps and thanks so much.

Hi and thanks so much. I have a Search feature in which you can copy in my Employee Manager series right here: kzfaq.info/get/bejne/qricadRiqa_Jh5c.html

Hi Steve, thanks so much for the comment and great question. In this training I show you not only how to tab through fields but buttons as well, allowing you to run these macros without ever having to touch your mouse: kzfaq.info/get/bejne/d8h9f5qJuJ2weqc.html

Hi Rajesh, thanks so much and I am really glad you liked the training. My channel tends to be a bit more advanced however channels such as "Excel VBA Is Fun" is a great way to start learning VBA from the beginning. I also have some courses taught by others on this page here: www.excelforfreelancers.com/partner-courses/ Thanks so much.

Thanks for the link. 😊

Thanks so much. Great idea for the comment. Here is the link: kzfaq.info/get/bejne/nduhiKaHmJeycqM.html

HI Michael thanks for your comment and I am glad you found our channel. We do have an Excel For Freelancers Facebook Group here: bit.ly/groupexcel If you can create a post and add your screenshots of the issue and your modifications we can help you through the bug. Thanks so much.

Yes for sure and you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.

Thanks very much for your suggestion. I will try to have the added.

Thanks so much. I am really glad you liked it. Much appreciated.

For sure, you are very welcome and happy to help.

You are welcome, happy to help.

Thank you very much. I do appreciate that :)

Hi and thanks so much. After I finish this Employee Manager series I am going to try to do a lot more videos where I start from nothing. I can see that most people enjoy learning as I create them. It takes a bit longer in the planning stage but i see that its super important. Thanks so much

@@ExcelForFreelancers any reason you prefer this to user forms in excel?

Yes very true. Since you have already seen so many of my videos, this idea was not new, but I realized with great feedback from people like you, that I need to start from the beginning and show people every step. Thanks so much.

Thanks so much Daniel, I appreciate that so much. There are still those who say I move to fast, but I always try to find a happy medium. Thank you for your Likes, Shares & Comments. It really helps.

@@ExcelForFreelancers I would rather stop and go back than wait for the person to finish explaining.

Thank you very much. I do appreciate that Nana.

Thank you very much. So nice of you Sniks304

You're very welcome and happy to help

Thank you very much David, I do appreciate that.

Hi Corentin, thanks so much for the comment and feedback. Clearing the contents and then resorting the table can work just great, as long as you don't mind the order of your data changing. This may be better as it won't affect things like conditional formatting and named ranges. I hope this helps and thanks so much.

@@ExcelForFreelancers thanks so much for your answer, best wishes for this new year!

For sure, you are very welcome

Hi Rolando. I am glad you liked it. Thanks so much. I am happy I could help.

Thank you very much. I do appreciate that.

Thanks so much. I am really glad you liked it. I will do more starting with blank workbooks, although i tend to mess up more. LOL :)

That's one of the most important parts of training a new person on a subject because it helps everyone with the logical operations. Also you talked about the auto hot keys you used. Did you do a video on them yet? Thanks

Thanks so much. I am glad you like it :)

For sure, you are very welcome Wambura. I am happy I can help.

I am really glad you liked it. Thanks so much.

Thanks so much. I will do my best to speak slower. Try the video I created yesterday. I move a lot slower in this one here: kzfaq.info/get/bejne/hrGSrZBiydzMm5c.html

Thanks so much Jenske. I am really glad you enjoyed the video training.

@@ExcelForFreelancers I have one question though, is it also possible to make like a search button? Where you can fill in for example a name and then press search such that you get back the information from that person?

Hi Jenske, yes for sure. I have added that already in the Employee Manager series on KZfaq, so please search my channel for that video. Thanks very much.

Thank you so very much, I really appreciate that. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/

For sure, you are very welcome, happy to help.

For sure, you are very welcome and thank you.

Thanks so much Dinesh. I really appreciate that.

HI thanks very much and I am really glad you liked it. Much appreciated.

Hi Mark, thanks for your comment. There are instances when we want to delete a contact, but not the entire row. You may want to leave the first column (which should be an ID #) with its value in place. You can run a loop from the 2nd column, to the last column, and clear out the contents of the cells. I show you how to do this in this video: kzfaq.info/get/bejne/l7GGaNaWv9PNcqc.html I hope this helps and thanks so much.

For sure, you are very welcome, I try to do it from scratch when i can but the training can take be quite long, but I do see the value in it for sure. Thanks so much.

Hi and thanks so much. This code and function is exclusive to Microsoft Excel. I have not worked with Open Office so I am not sure. Thank you for your Likes, Shares & Comments. It really helps.

For sure, you are very welcome Hanua

Hi and thanks, yes for sure, In fact i have a 'Search By' field set up for just that in this training: kzfaq.info/get/bejne/j7qnZKmW0JnOqoE.html I hope this helps and thanks so much.

Thank you so very much, I really appreciate that Ali

Hi Kaiser, thanks so much for your comment. Here is a great training that will show you how to edit and save data: kzfaq.info/get/bejne/iN9jg7yFssjXm5s.html Thank you for your Likes, Shares & Comments. It really helps.

Hi Joshua, thanks for the information. There is no doubt we can help you with that. This template is free for download however if you want it customized and secured, that can be done. While I cannot take on any projects, I would be happy to refer this to a qualified developer. Can you please email me all your specifications in a detailed scope so I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.

Thanks so much Mohd, I really appreciate that. :)

HI thanks we cover the multiple pictures and attachments in our new Employee Manager series (we are on Part 4 currently) I hope this helps.

For sure, you are very welcome Azizi

For sure you are very welcome. I am so glad you liked it.

For sure you are so welcome. Quite happy to help. :)

For sure no problem. I am glad you enjoyed it.

For sure, you are very welcome

Excellent!. I am very happy I could help.

Hi and thanks for your comment. I know it can be a bit complicated at times. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ I hope this helps and thanks.

More to come, thanks so much Abel

Awesome. Happy to hear that

HI and thanks I have a Payroll in our Employee Manager series right here on KZfaq. I hope this helps and thanks so much.

HI thanks Kirana, I do appreciate that. You can use data mapping to save changes to the database. I also do the same thing here in this video: kzfaq.info/get/bejne/ebCEiMyB2MfHcYU.html

Dear mr, Did you have tutorial for point of sale in excel ?

Hi not at this time however it is something that I have on my list to create in the near future.

Hi and thanks so much. Data can be locked in the cells, however, ultimately the data can be on a different and hidden sheet. I hope this helps and thanks so much.

HI and thanks so much for your comment. Please search my channel for additional videos to help you with totals. I hope this helps and thanks so much.

For sure, you are very welcome and happy to help.

For sure, you are very welcome Aung

Thank you very much Haroon, I do appreciate that.

Hi and thanks for the comment. If I were to turn this into a distributable application I would add protection to the table below so that users were unable to edit any of the table items, and only edited and updated by VBA. I hope this helps and thanks very much for your suggestion.

HI and thanks you can use the same macro for Save New or Update, You just need an If/Then statement to determine if it is new or existing. I show you how to do that in this video: kzfaq.info/get/bejne/o7dgjaaH2r6amJ8.html I hope this helps and thanks so much.

Thanks so much I am glad you like it.

For sure, you are very welcome Alberto, I am really glad you liked it.

For sure, you are very welcome

Thank you so very much, I really appreciate that

Hi and thanks very much. Feel free to download this and customize it however you like. If you need help with this, I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.

Hi thanks so much. I am really glad you liked the training. You can see the video training to automatically tab through cells: kzfaq.info/get/bejne/apaRjNKj1d60mYk.html

HI and thanks for your feedback. I created this application a few years ago, so i would have to check on those variables. Feel free to customize this application to your own requirements. Thank you for your Likes, Shares & Comments. It really helps.

Hi and thanks so much Surinder. Please check both the data mapping and the row in which the data is being saved. You can step through the code using F8 to see where the issue lies. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

Hi and thanks so much. I did this training many years ago, so i am not sure about the details, however you can right click any button and select 'Assign Macro' to any button. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel

Thank you so much Air. I will try to move slower of course. I really appreciate your feedback and value your comment. Thank you very much.

Thank you so much Archie. I am glad you liked the video

Thank you so very much, I really appreciate that Steven.