🔥Download 350 Of The Worlds Best Templates Here ► rebrand.ly/350Wkbks_YTPinnedCom
@wayneedmondson10656 жыл бұрын
So Randy.. this video is excellent.. and I much prefer walking through the building process with you step by step vs. only interrogating an already built solution. While it may take longer to create and or view the video, I think the learning is elevated by seeing and experiencing the construction live.. including mistakes.. which we all make. I find that I can pause and replay the passages that need emphasis. All in all, the take away is much more valuable and engaging than just being an audience to an explanation of an existing end product. I highly encourage more of this type of tutorial. Also, I'd like to salute you for being so generous and sharing your unbelievable and impressive EXCEL skills. Getting an insight into your techniques and creative solutions is invaluable. Thank you and Thumbs up!
@ExcelForFreelancers6 жыл бұрын
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.
@wayneedmondson10656 жыл бұрын
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!
@krn142426 жыл бұрын
@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.
@ExcelForFreelancers6 жыл бұрын
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 :)
@ExcelForFreelancers6 жыл бұрын
@krn14242 Thanks very much for your insights. its great feedback to get so I can create more engaging lessons in the future. Much Appreciated!
@abhinav0686 Жыл бұрын
I just created my own data entry forms. It was so easy to adapt the details to my needs because everything was so well explained. Thank you soo much. You are doing a great service. To give something this amazing for free is nothing less than a service.
@ExcelForFreelancers Жыл бұрын
For sure, you are very welcome and thanks so much. I am really glad you enjoyed the training.
@valenification16 жыл бұрын
Could hug you right now if I could :) In an amazing tut you have answered a gazillion of questions which were bugging me. It's awesome to have a project commonly needed by perhaps millions of people, explained fluently, coherently, in an easy to follow language and step by step manner. This is the kind of course i would enrol in. Thank you very much for your tutorial.
@ExcelForFreelancers6 жыл бұрын
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
@gen814653 жыл бұрын
One minor thing to remind people about: If you're going to have "Delete Record" delete an entire row, be sure all data mapping, and all variables in columns A & B get stored above the actual area where the records reside. Otherwise, that information might accidentally disappear; especially if those rows & columns are hidden.
@ExcelForFreelancers3 жыл бұрын
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.
@paganizonda1000ps2 жыл бұрын
Which Code would you use then? I have this Problem
@ianlevitt69206 жыл бұрын
Great tutorial Randy, it makes it so much clearer actually seeing it built step by step. Keep up the good work.
@ExcelForFreelancers6 жыл бұрын
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.
@geertkoetje33116 жыл бұрын
Followed this remarkable video that revealed a real 'how to' guide in creating a well controlled functional application. Thank you for this explanatory video and commenting.
@ExcelForFreelancers6 жыл бұрын
Thanks so much Geert, As you know I always appreciate your feedback and comments. I am really glad you liked this one.
@mylove0mylife5 жыл бұрын
Great tutorial/video. I used it to make a quality analyst form for work, and I loved it. Never touched VBA before this, and it was easy enough to follow. Thank you!
@ExcelForFreelancers5 жыл бұрын
Thanks so much Nikki, and great to have you in our Excel For Freelancers Facebook Group as well.
@swagman92035 жыл бұрын
Hi Randy, Great instructional video. I added the following line .Range("E5").Activate into the Sub Cont_New section as I found it easier when adding a new customer to save the user having to click on the yellow field. I'm not sure if it's been mentioned elsewhere but I found it particularly useful from a data entry viewpoint. Keep up the great work, I've learnt lots from your videos. Thanks, Tony, Australia
@ExcelForFreelancers5 жыл бұрын
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.
@r47ms4 жыл бұрын
@@ExcelForFreelancers What is it necessary for?
@dataguyin2 жыл бұрын
This is one of the best excel lesson I've ever watched.... Thanks @Excel For Freelancers
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Leandro.
@dannyyeoh23405 жыл бұрын
I was sceptical this VBA program will work on older Excel 2007. I follow and key in the code as you show. And in the process doing a little bit code modification to suit me. Wow, I am speechless, all the codes works on older Excel 2007. You guys are really fantastic. Thanks a lot. I was wondering before how to use the methods and objects in the VBA. You guys utilise and shows how to put it to use all the methods and objects. Will be learning other things later from your other videos.. Thanks again for making all these wonderful videos.
@ExcelForFreelancers5 жыл бұрын
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.
@krn142426 жыл бұрын
Thanks Randy. This was excellent. Really enjoyed the step by step creation. This free content is incredibly valuable. There are many concepts and ideas shown here that can apply to many other excel macro applications. Thanks again.
@ExcelForFreelancers6 жыл бұрын
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.
@tarasolutions31285 жыл бұрын
kzfaq.info/get/bejne/qrR4gpuBua-Ye6s.html
@sabelokhoza45246 жыл бұрын
This is really a very good staff, especially building the system from scratch. Thanks bra
@ExcelForFreelancers6 жыл бұрын
Thanks very much, I am glad you liked it. I will continue to build applications from scratch. Much appreciated.
@arlenegriffin4523 Жыл бұрын
I am in mentorship program. I love all you videos. Great training. Thank you
@ExcelForFreelancers Жыл бұрын
Thank you so very much, I really appreciate that and great to have you in the Mentorship Program. Much appreciated.
@sirasnet64996 жыл бұрын
Hi Randy, this is the most relevant video you made until now as you showed us how to build all the things from the scratch. Thank you.
@ExcelForFreelancers6 жыл бұрын
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.
@victorcharlie95484 жыл бұрын
Wow, awesome. I love excel, and manage to stumble along, but you clearly have this down to an art! Always a pleasure to watch you! Keep up the great work & thx again!
@ExcelForFreelancers4 жыл бұрын
Thank you so very much, I really appreciate that Victor.
@xaviertkk5 жыл бұрын
Thanks for the great tutorial! Learned very much. I would like to ask if a placeholder frame (rectangle) for the picture in the sheet itself would make it easier to load the specific size of the picture and set the desired location rather than in the macro
@ExcelForFreelancers5 жыл бұрын
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.
@larrylahti28645 жыл бұрын
This is very useful. I am new to code and I am loving your lessons. Right now I can take a code and manipulate it but I am unable to write it from scratch. Learning as I go though.
@ExcelForFreelancers5 жыл бұрын
Thanks so much Larry, I am really glad you like the lessons. I look forward to bringing you many more in the near future.
@RobertLongM4 жыл бұрын
I'm at 10 min mark - REALLY ENJOYING THIS... I never was good at DESIGN! In fact I was mocked lovingly at work when I tried to create dashboards lol
@ExcelForFreelancers4 жыл бұрын
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
@samnangchhing33336 жыл бұрын
I really love this video. Thank for your showing for start to the end. Mr. Randy, You're really amazing teacher I've ever seen. I've learned so much from your video and it really help me with my business. Thank so much for your sharing.
@ExcelForFreelancers6 жыл бұрын
Thanks very much for your comment and feedback. Much appreciated. I look forward to bringing you new and exciting videos each week.
@jimjones61825 жыл бұрын
Wow this is truly amazing. I had no idea things like this were possible. Thank you very much!
@ExcelForFreelancers5 жыл бұрын
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
@user-lj3od8wz7z4 жыл бұрын
@@ExcelForFreelancers ВВ ВДДДВДД Щзжвзж ВДЧВДДВДВ Вдзддчвддвдв ддзюдо вввдаьвввдаь ддввдж дождь все Ввечдджд в дверь всчввввввевядч👤 все равно все зависит в что двввввь ждать Ядвддаав двдвдв за что я тебя люблю чвтебя Вавввявя ➡ВВ ВВ ВВ и тебя люблю ЖВЖТВВВВ Ваввввввввввввввввввввдвсвввввввявя вчвв в
@user-lj3od8wz7z4 жыл бұрын
Д ввввввввввввввввввввввввввввдввввдввв вввввввввввввввдвсввввввщвявяв ВВ в вввввввввввввввдвсввввввщвявяв ВВ и все все все все время Вчвввввввввдввввввввввввввввввввввдвввввввв все в вввввввввввввввдвсввввввщвявяв Вжввввввввввввввввввввввввввзввввввввввв в вввввввввввввввдвсввввввщвявяв Вчвввввввввдввввввввввввввввввввввдвввввввв Вчвввввввввдввввввввввввввввввввввдвввввввв все вот Вчвввввввввввввввввввввввввввввввввввввввввввчвввв в вввввввввввввввдВВчавадвввлвжвввввввввввввввдввчавадвввлвжвчвввввввжвжжвжжвжвжвжввиввввввчвввжчжвжччвввввдввщввтвввввывдвдвчэввжвжвввввявввввв ивдввдвввв вот вв
@jgenterprisesnew95525 жыл бұрын
I enjoyed this video a lot. Like many replies here I will also implement some of your ideas on my designs. I only have a few suggestions for you: 1- Whenever you refer to some involved steps, put a link to a separate video (or text file) that describes how to perform that step in more detail. That way you save time in the current video. 2- Why not label the different ranges and use those labels in the formulas and macros?
@ExcelForFreelancers5 жыл бұрын
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.
@susank61222 жыл бұрын
Thank you! I learned lots. You are my hero! My goal is to know as much as you!
@ExcelForFreelancers2 жыл бұрын
Happy to help and thanks so much Susan. Thank you for your Likes, Shares & Comments. It really helps.
@JustoShowCartoons5 жыл бұрын
This was excellent. I've never thought to map like this. This gave some me some ideas/direction for a application I working on for my wife. Thanks!
@ExcelForFreelancers5 жыл бұрын
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.
@danterusso63545 жыл бұрын
Amazing! The data mapping Technic you use added a new dimension to how I was coding my Student Tracking application. Thank you so much. Subscribed and am looking forward to seeing more of your expertise. =8)
@ExcelForFreelancers5 жыл бұрын
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.
@thaof18984 жыл бұрын
I completely succeeded making those macros and subs, just everything you taught us in the video. Thank you very much. You blowed my mind
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome Thao. I am so happy I can help. Cam on em. :)
@thaof18984 жыл бұрын
@@ExcelForFreelancers OMG, you speak vietnamese to me, how kind you are
@ExcelForFreelancers4 жыл бұрын
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.
@thaof18984 жыл бұрын
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 :(
@ExcelForFreelancers4 жыл бұрын
HI yes still on lockdown here but hopefully over soon. Otherwise safe here and just working. Thanks so much. Great city here.
@leoarias32 жыл бұрын
I really appreciate your video and it seems really good but I know nothing from excel. I will look at it later when I have a more accurate knowledge basis in this program. Thank you!
@ExcelForFreelancers2 жыл бұрын
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.
@tjorange94214 жыл бұрын
Hello There Mr. Randy, I followed your tutorial step by step and it really helps me a lot, now i can monitor our employee's information whenever there is a change in the data.... my concern now is to add search and edit button and execute it at the same time with a code for me to easily find specific employee, can you make a video or in any other way, how to add this buttons and make it executable.... Your kind help will complete my workbook and implement it in our office... Thank You.
@ExcelForFreelancers4 жыл бұрын
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
@stevem43064 жыл бұрын
Great tutorial, thanks for all the hard work. I had a question though. If you were adding loads of new contacts, and tabbing between fields, how could you make it so that after adding the email field for each new customer, then the next 'tab' would highlight the 'add new contact' button so you can just press 'enter' on the keyboard instead of having to use the mouse?
@ExcelForFreelancers4 жыл бұрын
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
@rajeshshah67584 жыл бұрын
I was actually looking to learn VB from scratch but couldn't take my eyes off till the last. Really awesome man. It was really fun watching it. You are a great teacher. It looks far too advanced. It will help me in future. If you could help me with a link from where I can start learning the basics. Thanks Randy.
@ExcelForFreelancers4 жыл бұрын
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.
@rajeshshah67584 жыл бұрын
Thanks for the link. 😊
@guitalelefan3 жыл бұрын
A note for those who are viewing this video for the first time... Excel For Freelancers has another Contact Manager training...even more advanced tips and techniques!!! HIGHLY RECOMMENDED!!!!
@ExcelForFreelancers3 жыл бұрын
Thanks so much. Great idea for the comment. Here is the link: kzfaq.info/get/bejne/nduhiKaHmJeycqM.html
@mikelgaloy52595 жыл бұрын
Hi! thanks for this tutorial vid, but I keep on having an error on H7 & H9 on first row of the data saved, they alternately change every time I save a new contact. honestly I am new in VBA, I just copy your work. so im having a hard time figuring out what is wrong on my input.. thanks a lot! kudos!
@ExcelForFreelancers5 жыл бұрын
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.
@generationkonji2 жыл бұрын
Thanks brother for this super tool for me. I would like add languages spoken by each and good at speaking each of them. Thanks again
@ExcelForFreelancers2 жыл бұрын
Yes for sure and you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
@sitaramrathi74832 жыл бұрын
अध्यापकजी नमस्कार आपके विडियो बहुत ही ज्ञानवर्धक एवं शिक्षाप्रद है सभी को बहुत कुछ सीखने को मिलता है परन्तु आजतक पारिवारिक सदस्यों का रिलेशनशिप सम्बन्ध के लिंक का एक्सल में एक्सैस में एचटीएमएल में कोई विडियो नही बना है अतःआप एक फार्म ऐसा बनाये जिसमें आई डी हो, स्वयं हो ,पत्नी हो, पति हो, पुत्र हो, पुत्री हो, माता हो, पिता हो, सीटी हो, कास्ट हो, और भी बहुत कुछ लिखा जा सकता है परन्तु अपन को पारिवारिक रिलेशनशिप सम्बन्ध लिंक बनाना है वो इतने में बन जायेगा कोई बात समझ में न आये तो पूछ लेना
@ExcelForFreelancers2 жыл бұрын
Thanks very much for your suggestion. I will try to have the added.
@EOO-Stand5 жыл бұрын
Great video, very detailed and you are not rushing for slow people like myself. can't wait to get a project to build step by step.
@ExcelForFreelancers5 жыл бұрын
Thanks so much. I am really glad you liked it. Much appreciated.
@YoucefYoucef-ft9ce2 жыл бұрын
Unlimited like thank you for your efforts sir this is the best channel ever
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome and happy to help.
@RakibHasan-ct8ck6 жыл бұрын
This is what I looking for or waiting for. Thanks Randy, thanks Excel For Freelancers....
@ExcelForFreelancers6 жыл бұрын
You are welcome, happy to help.
@najihahleyla71954 жыл бұрын
I'm here todayy. Can't wait to learn how to do this. Thank you for the great video
@ExcelForFreelancers4 жыл бұрын
Thank you very much. I do appreciate that :)
@allisround5 жыл бұрын
Excellent video and a very effective way to teach...real-time. I learnt s lot. I have created one easily for my business in under a week (with a few additional features.). Thanks a zillion.
@ExcelForFreelancers5 жыл бұрын
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
@allisround5 жыл бұрын
@@ExcelForFreelancers any reason you prefer this to user forms in excel?
@yahya_yg886 жыл бұрын
Awsom job sir we talked about that before 4 months I think and you make special video for people who really need this kind of files . good luck Mr Randy .
@ExcelForFreelancers6 жыл бұрын
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.
@danielmchenry10004 жыл бұрын
Thank you for working quickly and concisely. A refreshing change of pace from some that drone on with minutia. (for me anyway).
@ExcelForFreelancers4 жыл бұрын
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.
@danielmchenry10004 жыл бұрын
@@ExcelForFreelancers I would rather stop and go back than wait for the person to finish explaining.
@NanaAtiekuFrans4 жыл бұрын
Thanks very much for the content. You make excel look so easy to the ordinary person. I very much appreciate all your effort.
@ExcelForFreelancers4 жыл бұрын
Thank you very much. I do appreciate that Nana.
@sniklegem Жыл бұрын
Why did I just watch this entire thing? :D Nice video!
@ExcelForFreelancers Жыл бұрын
Thank you very much. So nice of you Sniks304
@w.estrada51813 жыл бұрын
Thank you for taking the time to put this tutorial together, excellent!!
@ExcelForFreelancers3 жыл бұрын
You're very welcome and happy to help
@davidyergensen45094 жыл бұрын
Excellent tutorial. This is well detailed and easy to follow. great job!
@ExcelForFreelancers4 жыл бұрын
Thank you very much David, I do appreciate that.
@corenting73432 жыл бұрын
The fact that we delete a contact by deleting a row ends up for me with no more lines formated. So instead of "EntireRow.delete" I did .selection; and Selection.ClearContents; and sort the contact board from a to z (not creating a blank row in the middle of filled ones). I would be happy to know an easier way to do that. Thanks Randy for this usefull knowledge shared! I am currently using this video to make a Seminars multibilling platform for valet car park at work.
@ExcelForFreelancers2 жыл бұрын
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.
@corenting73432 жыл бұрын
@@ExcelForFreelancers thanks so much for your answer, best wishes for this new year!
@christiantoledopaglumotan8844 жыл бұрын
Thank you so much Sir! 😇 God bless you and your team 😇😇😇
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome
@rolandovaldez7225 жыл бұрын
Thank you Randy for this video. Easy to understand though I am new in creating Macros. I was just looking for some videos on creating forms but for a beginner like me this one seems a bit easy to understand. I can just download the FREE Data Form. Again thank you.
@ExcelForFreelancers5 жыл бұрын
Hi Rolando. I am glad you liked it. Thanks so much. I am happy I could help.
@congnghevakythuat4 жыл бұрын
Very good! Welcome to view and give comments. Thanks
@ExcelForFreelancers4 жыл бұрын
Thank you very much. I do appreciate that.
@k102stone6 жыл бұрын
Thanks Randy for the walk through on how you put this together.. I really liked this video.
@ExcelForFreelancers6 жыл бұрын
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 :)
@k102stone6 жыл бұрын
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
@agonalia27964 жыл бұрын
Crazy....this tutorial is gold! Thanks!
@ExcelForFreelancers4 жыл бұрын
Thanks so much. I am glad you like it :)
@wamburaskinyunyi22764 жыл бұрын
Wow this amazing. I had no idea things like this were possible. Thanks
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome Wambura. I am happy I can help.
@islamisbest72564 жыл бұрын
Great Brother : your Videos are very helpful for beginner
@ExcelForFreelancers4 жыл бұрын
I am really glad you liked it. Thanks so much.
@avataravatar43252 жыл бұрын
Sir please speak slowly some other country people con not get easily Great work sir thank you
@ExcelForFreelancers2 жыл бұрын
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
@jenskemeijs4 жыл бұрын
Wow what an awesome video! It was so clearly explaned. I followed it step by step and it works great! I made into a table so I can use filters and that works fine as well. Really really amazing! Thank you!
@ExcelForFreelancers4 жыл бұрын
Thanks so much Jenske. I am really glad you enjoyed the video training.
@jenskemeijs4 жыл бұрын
@@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?
@ExcelForFreelancers4 жыл бұрын
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.
@jonnypeace28103 жыл бұрын
What a video, I've still so much to learn 😬
@ExcelForFreelancers3 жыл бұрын
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/
@spartanasasable5 жыл бұрын
Great Video!! Thanks for going true step by step, really appreciate!
@ExcelForFreelancers5 жыл бұрын
For sure, you are very welcome, happy to help.
@ZataarW4 жыл бұрын
Very helpful and creative, thanks for your efforts and everything...
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome and thank you.
@dineshsingh-nv1bn5 жыл бұрын
Rguide... best KZfaq channel to become excel expert
@ExcelForFreelancers5 жыл бұрын
Thanks so much Dinesh. I really appreciate that.
@handpowers5 жыл бұрын
Thank you for putting in so much effort on this excellent video. Keep up the good work!
@ExcelForFreelancers5 жыл бұрын
HI thanks very much and I am really glad you liked it. Much appreciated.
@markhines6531 Жыл бұрын
I learned a lot thanks for the easy to follow instructions. I do have a question I can’t figure out. When deleting an contact how can you delete or clear just the columns that have the contact information and not delete the Entire Row. I have added a list of data validation items to the right and I keep loosing information from these lists. Thanks again.
@ExcelForFreelancers Жыл бұрын
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.
@janezklun5 жыл бұрын
Very interesting to see it done from scratch, Thanks
@ExcelForFreelancers5 жыл бұрын
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.
@leonardrobinson87573 жыл бұрын
This is some Great Stuff Thank you for bringing this video to us I just would like to know If I could do all this in OpenOffice Software.
@ExcelForFreelancers3 жыл бұрын
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.
@hanuaezyfinancelimited38494 жыл бұрын
Awesome video, been looking for this for sometime. Thank you!
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome Hanua
@arodvi6 ай бұрын
Excellent form table could you extend it with search option? For example if the contacts become hundreds or thousands will be much easier for searching them in some field or maybe some dynamic table and when you search specific group of contacts to show only them there?
@ExcelForFreelancers6 ай бұрын
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.
@Nigromancy3 жыл бұрын
Absolutely Brilliant Tutorial thank you soooo much!!!
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that Ali
@kaiserluvkailove4 жыл бұрын
This is really awesome, I've tried it and modified some data and actually worked! could you also teach us how to edit and save if I want to edit the contact list? I've tried to code but it didn't work.
@ExcelForFreelancers4 жыл бұрын
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.
@joshuahurt5939 Жыл бұрын
Randy, I’m so happy to have found this tutorial. I’m interested in buying a version of this contact manager or chatting about having another made. This is the exact solution I’ve been searching for. Is there a preferred way we can discuss?
@ExcelForFreelancers Жыл бұрын
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.
@mohdradhi67616 жыл бұрын
excellent explaination and superb technique. Thank you so much for all of your great videos! Ten thumbs up!
@ExcelForFreelancers6 жыл бұрын
Thanks so much Mohd, I really appreciate that. :)
@charanreddy48215 жыл бұрын
Excellent Video Sir.... I need some more things to be added ( Login : USER/PWD) , Multiple pictures for Each Contact ( the image should open bigger in the open space right side .)
@ExcelForFreelancers5 жыл бұрын
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.
@aziziabdullah63593 жыл бұрын
Thanks for the great tutorial. I really love this video.
@ExcelForFreelancers3 жыл бұрын
For sure, you are very welcome Azizi
@brosseauchristian53655 жыл бұрын
Thank you so much for this tutorial. It was a lot of fun. Cheers.
@ExcelForFreelancers5 жыл бұрын
For sure you are very welcome. I am so glad you liked it.
@jamesleslie16506 жыл бұрын
Excel lent tutorial I learned a ton. Thank you so very much.
@ExcelForFreelancers6 жыл бұрын
For sure you are so welcome. Quite happy to help. :)
@tadelebirhanu24035 жыл бұрын
Thank you very much ! I expect more video later on !
@ExcelForFreelancers5 жыл бұрын
For sure no problem. I am glad you enjoyed it.
@microsoftsarker2 жыл бұрын
Wow Thank you so much for this video,
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome
@bravozn995 жыл бұрын
Great turtorial Helped me alot!!!
@ExcelForFreelancers5 жыл бұрын
Excellent!. I am very happy I could help.
@binsh3el4 жыл бұрын
many thanks, really really helpfully to be honest, i didn't understand anything LOL but thanks any way :)
@ExcelForFreelancers4 жыл бұрын
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.
@busyfx234 жыл бұрын
Wow!!! Very Coool.Great Teaching Techniques .keep it all Up.
@ExcelForFreelancers4 жыл бұрын
More to come, thanks so much Abel
@joemanflyer20012 ай бұрын
Yes. This makes it super fast !!
@ExcelForFreelancers2 ай бұрын
Awesome. Happy to hear that
@ruginathomas38733 жыл бұрын
Wow the best tutorial i have learnt alot can you create one for payroll for me Thanks!
@ExcelForFreelancers3 жыл бұрын
HI and thanks I have a Payroll in our Employee Manager series right here on KZfaq. I hope this helps and thanks so much.
@kiranarana72745 жыл бұрын
I have learned so much from you and I look forward to learning more. Thank you for being a remarkable teacher and I am very grateful to have you as a teacher. Please help how to edit select data and save after edit ?
@ExcelForFreelancers5 жыл бұрын
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
@kiranarana72745 жыл бұрын
Dear mr, Did you have tutorial for point of sale in excel ?
@ExcelForFreelancers5 жыл бұрын
Hi not at this time however it is something that I have on my list to create in the near future.
@gusTechnikPro Жыл бұрын
Brilliant tutorial. Was inspiration for my software, how do you prevent the user from clicking and changing the data in the table? If you lock it, then you can not access it with VBA also?
@ExcelForFreelancers Жыл бұрын
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.
@marksandzvlog2 жыл бұрын
Hope you can make also a data entry that can multiple and calculate total. Thanks
@ExcelForFreelancers2 жыл бұрын
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.
@systemadmin80752 жыл бұрын
Its amazing. thanks for your video
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome and happy to help.
@Swamhtetyan4 жыл бұрын
Very good your Excel and VBA , Thank you sir
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome Aung
@haroonkhanafridi49964 жыл бұрын
Going to try this today. Was given a task to make an account profiling checklist for our hotel corporate clients. This would work great! If anyone has a similar template for hotels, please comment below!
@ExcelForFreelancers4 жыл бұрын
Thank you very much Haroon, I do appreciate that.
@thedukeofno4 жыл бұрын
This is a really walk-through. I added an additional msg box line to the "delete contact" sub, to "double check" that you indeed want to make a deletion. I'm thinking of how to add something similar to the editing feature... you wouldn't want an accidental keystroke to unknowingly allow you to edit a contact.
@ExcelForFreelancers4 жыл бұрын
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.
@tsmith93544 ай бұрын
Great Talent Randy, I would like to add an update button or when i click on the row and add the new info in the field to add that info in that row. How can i accomplish that. or do you have a video showing that feature i can watch. Thanks :)
@ExcelForFreelancers4 ай бұрын
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.
@styles61784 жыл бұрын
i really appreciate for your nice video
@ExcelForFreelancers4 жыл бұрын
Thanks so much I am glad you like it.
@albertoisturiz82695 жыл бұрын
thanks to your, great job Good luck Greetings from Venezuela
@ExcelForFreelancers5 жыл бұрын
For sure, you are very welcome Alberto, I am really glad you liked it.
@jankes19925 жыл бұрын
That's what I was looking for. Thanks!
@ExcelForFreelancers5 жыл бұрын
For sure, you are very welcome
@abdulhamidalhaddadi2255 Жыл бұрын
Great Lesson
@ExcelForFreelancers Жыл бұрын
Thank you so very much, I really appreciate that
@eilronoleus Жыл бұрын
Hi Great Video. Can you teach additional button in case you wanted to edit previous or older entries. What should be the macro script? I Appreciate your kind support.
@ExcelForFreelancers Жыл бұрын
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.
@drparthibanchandransegaran49035 жыл бұрын
Hi there! Excellent tutorial, Bravo! I would love to move thru the columns (H5:K9) for data entry by pressing tab, can you show how to do it?
@ExcelForFreelancers5 жыл бұрын
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
@juninquig4 жыл бұрын
Great tutorial and I loved it so much. One thing I noticed Sir, please correct me if I'm wrong, in the Sub Cont_CancelNew the values of ExistContGrp, NewContGrp, and b3 are not reset but in the video the values were reset. Thank you very much!
@ExcelForFreelancers4 жыл бұрын
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.
@surinderpalsharma11332 жыл бұрын
Certainly an excellent video to farther MS Excel skills. I Have a question. After clicking on Add New Contact and making entries in the form, if you don't press enter key or tab key after entering email-id and click on Save Contact, the New Contact is added, but the email-id of the previously selected row also get changed as that of newly added contact.
@ExcelForFreelancers2 жыл бұрын
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
@novagulmatico69187 ай бұрын
This tuitorial video is very amazing. Just wondering how to add the link on ADD ID BTN
@ExcelForFreelancers6 ай бұрын
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
@airair34356 жыл бұрын
Thanks Randy ,I'd learnt lots from you ,just need a little bit slowly would be great .
@ExcelForFreelancers5 жыл бұрын
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.
@ArchieWeber4 жыл бұрын
Watch at .75 playback speed. Great Vid
@ExcelForFreelancers4 жыл бұрын
Thank you so much Archie. I am glad you liked the video
@steventilk56353 жыл бұрын
Dude, Great Video!!! Thanks so much!!!
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that Steven.