Тёмный

How To Create An Excel Data Entry Form WITHOUT A UserForm 

Excel For Freelancers
Подписаться 533 тыс.
Просмотров 1,5 млн
50% 1
ВидеоПоделитьсяСкачатьДобавить в

🎁 SAVE UP TO 40% IN JULY 2024 DURING OUR BIRTHDAY CELEBRATION ► rebrand.ly/7thAnniv_YTDesc
🔥 GET THIS + 350 OF MY BEST DONE-FOR-YOU TEMPLATES HERE ► rebrand.ly/350Wkbks_YTDesc
📚 GET A DISCOUNTED DEVELOPERS LIBRARY HERE ► rebrand.ly/UDVL_YTDesc
🤖BRING AI INTO EXCEL WITH THIS INCREDIBLE ADD-IN ► rebrand.ly/AIToolpack_YTDesc
👉CREATE & SELL EXCEL BASED SOFTWARE IN MY MENTORSHIP PROGRAM ► rebrand.ly/MentorshipProgram_...
▶️ GET ACCESS TO OVER 100 UPDATED TRAININGS, WORKBOOKS & PDF CODEBOOKS: rebrand.ly/Patreon_YTDesc
👨‍💼BECOME AN EXPERT AT DASHBOARDS ► rebrand.ly/ExcelDashboard_YTDesc
📣START LEARNING VBA HERE ► rebrand.ly/VBAEFFDan_YTDesc
🏝BECOME A SUCCESSFUL FREELANCER ► rebrand.ly/FreelancersAcademy...
⭐️JOIN RU-vid MEMBERS FOR UNRELEASED TRAININGS ► rebrand.ly/YTMembership_YTDesc
In this week’s training, I will show you how to create a Contact Manager Data Entry Form.
⬇DOWNLOAD THIS WEEKS WORKBOOK FREE:
📩 USING YOUR EMAIL: bit.ly/DataEntryFrm_Wb
🤑 START EARNING BIG $$$ WITH MY AFFILIATE PROGRAM 👉 rebrand.ly/Affiliate_YTDesc
EXCEL COURSES:
►FREELANCER ACADEMY: rebrand.ly/FreelancersAcademy...
►MENTORSHIP PROGRAM: rebrand.ly/MentorshipProgram_...
►DASHBOARD MASTERCLASS: rebrand.ly/ExcelDashboard_YTDesc
►BEGINNERS VBA COURSE: rebrand.ly/VBAEFFDan_YTDesc
►WEB AUTOMATION COURSE WITH EXCEL VBA: rebrand.ly/WebAuto_YTDesc
EXCEL PRODUCTS:
►Turbocharge Your App Development: rebrand.ly/UDVL_YTDesc
►Get 350 Templates In 1 Zip File: rebrand.ly/350Wkbks_YTDesc
►Get ChatGPT Into Excel With This Addin: rebrand.ly/AIToolpack_YTDesc
►The Ultimate Excel Resource Guide: rebrand.ly/UERG_YTDesc
►Get Your Actual Employee Hourly Cost: rebrand.ly/LBC_YTDesc
►1000 Incredible Freelancing Resources: rebrand.ly/UFRG_YTDesc
►Secure Your Excel Applications From Theft: rebrand.ly/XLSPadlock_YTDescrptn
🧐Find the Best Excel Products & Courses Here: rebrand.ly/ExcelProductsAndCo...
TIMESTAMPS:
0:00 - Introduction
0:32 - Worksheet Design
26:04 - Selection Change Event
28:49 - Load Contact
41:55 - Save Contact
47:19 - Delete Contact
50:47 - Cancel New Contact
52:32 - Attach Thumbnail
58:08 - Display Thumbnail
1:05:12 - Change Event
JOIN OUR COMMUNITY:
►Facebook Group: rebrand.ly/EFF_Group
►Facebook Fan Page: rebrand.ly/EFF_FanPage
Follow me on my Social Media Accounts:
🤩TikTok: / excel4freelancers
🐦Twitter: / excel4freelance
🌏Website: www.ExcelForFreelancers.com
🔗LinkedIn: / excelforfreelancers
👤Facebook: / excelforfreelancers
📸 Instagram: / excelforfreelancers
🎥Rumble: rumble.com/c/ExcelForFreelancers
✉Telegram: t.me/ExcelForFreelancers
About Us:
I help Microsoft Excel enthusiasts turn their passion into profits so they can earn passive income using their skills without having to trade time for money.
I love making these videos for you each and every week. A great way of supporting Excel For Freelancers to keep this training free each and every week is by supporting us through one of the amazing products offered that will help you skyrocket your Excel Skills and reach your dreams.
Get Alerted IMMEDIATELY with new Free Training Videos & Workbook by subscribing here:
👉 / excelforfreelancers
New Training Video Uploaded every Tuesday!
Thank you very much for your continued support,
Randy Austin
#exceltraining #contactmanager #dataentryform #dataentry

Хобби

Опубликовано:

 

28 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 1,1 тыс.   
@ExcelForFreelancers
@ExcelForFreelancers 9 месяцев назад
🎉 7th Anniversary Sale: Save Big This July 2024! ► rebrand.ly/7thAnniv_YTPinnedCom
@ianlevitt6920
@ianlevitt6920 6 лет назад
Great tutorial Randy, it makes it so much clearer actually seeing it built step by step. Keep up the good work.
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
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.
@krn14242
@krn14242 6 лет назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
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.
@tarasolutions3128
@tarasolutions3128 5 лет назад
ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tNHO8PTI4Kw.html
@valenification1
@valenification1 6 лет назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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
@JustoShowCartoons
@JustoShowCartoons 5 лет назад
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!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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.
@mylove0mylife
@mylove0mylife 5 лет назад
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!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thanks so much Nikki, and great to have you in our Excel For Freelancers Facebook Group as well.
@swagman9203
@swagman9203 5 лет назад
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
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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.
@r47ms
@r47ms 4 года назад
@@ExcelForFreelancers What is it necessary for?
@samnangchhing3333
@samnangchhing3333 6 лет назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
Thanks very much for your comment and feedback. Much appreciated. I look forward to bringing you new and exciting videos each week.
@victorcharlie9548
@victorcharlie9548 4 года назад
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!
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Thank you so very much, I really appreciate that Victor.
@danterusso6354
@danterusso6354 5 лет назад
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)
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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.
@sabelokhoza4524
@sabelokhoza4524 5 лет назад
This is really a very good staff, especially building the system from scratch. Thanks bra
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thanks very much, I am glad you liked it. I will continue to build applications from scratch. Much appreciated.
@wayneedmondson1065
@wayneedmondson1065 6 лет назад
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!
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
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.
@wayneedmondson1065
@wayneedmondson1065 6 лет назад
Hi Randy.. thanks and understood. I use the RU-vid 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!
@krn14242
@krn14242 6 лет назад
@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.
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
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 :)
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
@krn14242 Thanks very much for your insights. its great feedback to get so I can create more engaging lessons in the future. Much Appreciated!
@jimjones6182
@jimjones6182 5 лет назад
Wow this is truly amazing. I had no idea things like this were possible. Thank you very much!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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 RU-vid
@user-lj3od8wz7z
@user-lj3od8wz7z 3 года назад
@@ExcelForFreelancers ВВ ВДДДВДД Щзжвзж ВДЧВДДВДВ Вдзддчвддвдв ддзюдо вввдаьвввдаь ддввдж дождь все Ввечдджд в дверь всчввввввевядч👤 все равно все зависит в что двввввь ждать Ядвддаав двдвдв за что я тебя люблю чвтебя Вавввявя ➡ВВ ВВ ВВ и тебя люблю ЖВЖТВВВВ Ваввввввввввввввввввввдвсвввввввявя вчвв в
@user-lj3od8wz7z
@user-lj3od8wz7z 3 года назад
Д ввввввввввввввввввввввввввввдввввдввв вввввввввввввввдвсввввввщвявяв ВВ в вввввввввввввввдвсввввввщвявяв ВВ и все все все все время Вчвввввввввдввввввввввввввввввввввдвввввввв все в вввввввввввввввдвсввввввщвявяв Вжввввввввввввввввввввввввввзввввввввввв в вввввввввввввввдвсввввввщвявяв Вчвввввввввдввввввввввввввввввввввдвввввввв Вчвввввввввдввввввввввввввввввввввдвввввввв все вот Вчвввввввввввввввввввввввввввввввввввввввввввчвввв в вввввввввввввввдВВчавадвввлвжвввввввввввввввдввчавадвввлвжвчвввввввжвжжвжжвжвжвжввиввввввчвввжчжвжччвввввдввщввтвввввывдвдвчэввжвжвввввявввввв ивдввдвввв вот вв
@Cookye306
@Cookye306 4 года назад
Hi! I can't tell you HOW MUCH it helped me create the database I needed! This is a great tutorial! I can't wait to watch the others!!! You explain so well and I was able to follow and understand every steps without having ever used macros! Thank you SO MUCH!!! :)
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
For sure, you are very welcome Nat I am so glad you liked it. Much appreciated.
@handpowers
@handpowers 5 лет назад
Thank you for putting in so much effort on this excellent video. Keep up the good work!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
HI thanks very much and I am really glad you liked it. Much appreciated.
@sirasnet6499
@sirasnet6499 6 лет назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
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.
@xaviertkk
@xaviertkk 5 лет назад
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
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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.
@brosseauchristian5365
@brosseauchristian5365 5 лет назад
Thank you so much for this tutorial. It was a lot of fun. Cheers.
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
For sure you are very welcome. I am so glad you liked it.
@EOO-Stand
@EOO-Stand 4 года назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Thanks so much. I am really glad you liked it. Much appreciated.
@tjorange9421
@tjorange9421 4 года назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Hi and thanks so much. I have a Search feature in which you can copy in my Employee Manager series right here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tRl6q1DIeWc.html
@stevem4306
@stevem4306 4 года назад
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?
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AbML7XS7LJs.html
@davidyergensen4509
@davidyergensen4509 4 года назад
Excellent tutorial. This is well detailed and easy to follow. great job!
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Thank you very much David, I do appreciate that.
@spartanasasable
@spartanasasable 5 лет назад
Great Video!! Thanks for going true step by step, really appreciate!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
For sure, you are very welcome, happy to help.
@gen81465
@gen81465 3 года назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
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.
@paganizonda1000ps
@paganizonda1000ps 2 года назад
Which Code would you use then? I have this Problem
@mikelgaloy5259
@mikelgaloy5259 5 лет назад
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!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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.
@mohdradhi6761
@mohdradhi6761 6 лет назад
excellent explaination and superb technique. Thank you so much for all of your great videos! Ten thumbs up!
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
Thanks so much Mohd, I really appreciate that. :)
@hanuaezyfinancelimited3849
@hanuaezyfinancelimited3849 4 года назад
Awesome video, been looking for this for sometime. Thank you!
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
For sure, you are very welcome Hanua
@k102stone
@k102stone 6 лет назад
Thanks Randy for the walk through on how you put this together.. I really liked this video.
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
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 :)
@k102stone
@k102stone 6 лет назад
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
@rolandovaldez722
@rolandovaldez722 5 лет назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi Rolando. I am glad you liked it. Thanks so much. I am happy I could help.
@abhinav0686
@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
@ExcelForFreelancers Год назад
For sure, you are very welcome and thanks so much. I am really glad you enjoyed the training.
@geertkoetje3311
@geertkoetje3311 6 лет назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
Thanks so much Geert, As you know I always appreciate your feedback and comments. I am really glad you liked this one.
@w.estrada5181
@w.estrada5181 3 года назад
Thank you for taking the time to put this tutorial together, excellent!!
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
You're very welcome and happy to help
@jamesleslie1650
@jamesleslie1650 6 лет назад
Excel lent tutorial I learned a ton. Thank you so very much.
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
For sure you are so welcome. Quite happy to help. :)
@jenskemeijs
@jenskemeijs 4 года назад
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!
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Thanks so much Jenske. I am really glad you enjoyed the video training.
@jenskemeijs
@jenskemeijs 4 года назад
@@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?
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Hi Jenske, yes for sure. I have added that already in the Employee Manager series on RU-vid, so please search my channel for that video. Thanks very much.
@larrylahti2864
@larrylahti2864 5 лет назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thanks so much Larry, I am really glad you like the lessons. I look forward to bringing you many more in the near future.
@yahya_yg88
@yahya_yg88 5 лет назад
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 .
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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.
@NanaAtiekuFrans
@NanaAtiekuFrans 4 года назад
Thanks very much for the content. You make excel look so easy to the ordinary person. I very much appreciate all your effort.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Thank you very much. I do appreciate that Nana.
@jankes1992
@jankes1992 5 лет назад
That's what I was looking for. Thanks!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
For sure, you are very welcome
@najihahleyla7195
@najihahleyla7195 4 года назад
I'm here todayy. Can't wait to learn how to do this. Thank you for the great video
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Thank you very much. I do appreciate that :)
@RakibHasan-ct8ck
@RakibHasan-ct8ck 6 лет назад
This is what I looking for or waiting for. Thanks Randy, thanks Excel For Freelancers....
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
You are welcome, happy to help.
@danielmchenry1000
@danielmchenry1000 4 года назад
Thank you for working quickly and concisely. A refreshing change of pace from some that drone on with minutia. (for me anyway).
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
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.
@danielmchenry1000
@danielmchenry1000 4 года назад
@@ExcelForFreelancers I would rather stop and go back than wait for the person to finish explaining.
@gabrielkishon2938
@gabrielkishon2938 4 года назад
Hi Randy, first of all thank you very much for this tutorial - I really loved it. How can i apply Range on merged cells in the Cont_Load macro?
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Hi Gabriel, thanks so much for your comments. You can add any value to a merged cell range by using the first cell in a range. When clearing out merged cells, make sure you specify the entire range. 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
@sohildahy
@sohildahy 5 лет назад
Thank you Randy, it is amazing! If I want to add search how can I do it? And anyway to lock content and could only delete contact by clicking "delete contact" button? Thank you!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi SoHildahy thanks very much for your comment. You can use a search using Index/Match based on user entered details (I have a search in the scheduling section of my Employee Manager on this channel in which you can see a sample) You can assign a delete button to delete the selected or contact row. I also have samples of this in the Employee Manager series as well. 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
@lunaedge7565
@lunaedge7565 6 лет назад
I too was looking for something like this. Thanks
@ExcelForFreelancers
@ExcelForFreelancers 6 лет назад
Great, I am glad I could help
@mishraamukesh
@mishraamukesh 5 лет назад
Exceptional... Thank you very much.
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thank you very much. I do appreciate that Mukesh.
@kiranarana7274
@kiranarana7274 5 лет назад
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 ?
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-CJTUiPsacAQ.html
@kiranarana7274
@kiranarana7274 5 лет назад
Dear mr, Did you have tutorial for point of sale in excel ?
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi not at this time however it is something that I have on my list to create in the near future.
@albertoisturiz8269
@albertoisturiz8269 5 лет назад
thanks to your, great job Good luck Greetings from Venezuela
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
For sure, you are very welcome Alberto, I am really glad you liked it.
@rajeshshah6758
@rajeshshah6758 4 года назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
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.
@rajeshshah6758
@rajeshshah6758 4 года назад
Thanks for the link. 😊
@bravozn99
@bravozn99 5 лет назад
Great turtorial Helped me alot!!!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Excellent!. I am very happy I could help.
@allisround
@allisround 5 лет назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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
@allisround
@allisround 5 лет назад
@@ExcelForFreelancers any reason you prefer this to user forms in excel?
@dannyyeoh2340
@dannyyeoh2340 5 лет назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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.
@Rida5365
@Rida5365 5 лет назад
Thank you so much. It's a huge effort
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
For sure you are very welcome Meta, I am happy to help.
@ramakurniawan7484
@ramakurniawan7484 5 лет назад
thanks randy, its helping me so much
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
For sure Rama, glad to help. Make sure to check out our Employee Manager series. We are covering tons of amazing Tips, Tricks & Techniques
@jsbarbosa
@jsbarbosa 5 лет назад
Thanks randy for you excelent video! I have one doubt: if I want to insert the picture in the table instead of the location of the picture to be always showing how can I do it? Thanks again!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi Joao, there are 3 different ways you can add a picture in a table. I go over all 3 ways in this video here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-5Vsiju7DinY.html
@Nigromancy
@Nigromancy 3 года назад
Absolutely Brilliant Tutorial thank you soooo much!!!
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
Thank you so very much, I really appreciate that Ali
@truepath5129
@truepath5129 5 лет назад
Wonderful Tutorial. Love You Brother
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thanks so much. I am really glad you liked it.
@dataguyin
@dataguyin 2 года назад
This is one of the best excel lesson I've ever watched.... Thanks @Excel For Freelancers
@ExcelForFreelancers
@ExcelForFreelancers 2 года назад
Thank you so very much, I really appreciate that Leandro.
@ccpcarlone
@ccpcarlone 6 лет назад
Really good video Randy, thanks a lot
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thanks so much Carlos, happy to help
@anthonyjohnson4944
@anthonyjohnson4944 5 лет назад
Excellent video. This was really helpful. If I wanted to duplicate this worksheet and have the add, delete, save, cancel buttons work on another worksheet independently of the original worksheet, how would I modify the module code for this? instead of "With Sheet1" what would I need to change this to?
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi Anthony, thats a great question. My most recent training covers just that Part 1 and Part 2 of the Employee Manager (where the actual data is on a different sheet) covers data mapping when the data is on a different sheet. Part 2 here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-lba5z5RlzxI.html Covers 1 part of the data mapping, and Part 3 (out tomorrow) will cover the 2nd half of that. I do suggest you watch from the beginning in where I start from a blank worksheet here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iyr9WIyxlJc.html Thanks very much.
@ZataarW
@ZataarW 3 года назад
Very helpful and creative, thanks for your efforts and everything...
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
For sure, you are very welcome and thank you.
@tauqiranwar5699
@tauqiranwar5699 5 лет назад
Great Work Randy! keep it up...
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thanks so much Taugir, much appreciated.
@arlenegriffin4523
@arlenegriffin4523 Год назад
I am in mentorship program. I love all you videos. Great training. Thank you
@ExcelForFreelancers
@ExcelForFreelancers Год назад
Thank you so very much, I really appreciate that and great to have you in the Mentorship Program. Much appreciated.
@janezklun
@janezklun 5 лет назад
Very interesting to see it done from scratch, Thanks
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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.
@wamburaskinyunyi2276
@wamburaskinyunyi2276 4 года назад
Wow this amazing. I had no idea things like this were possible. Thanks
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
For sure, you are very welcome Wambura. I am happy I can help.
@drcom10
@drcom10 4 года назад
I love this. you made this video easy to follow. Thanks. Is there a way to move the List or data to different work sheet and implement a search on lets say name? that would pull up other info for that name.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
HI Ralph, thanks so much and I am really glad you love the training. It is certainly possible to do a search on one sheet, based on source data on another sheet. In my Employee Manager series I cover that here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tRl6q1DIeWc.html
@noaho.nakwambwa921
@noaho.nakwambwa921 4 года назад
I like This presentation. Good Stuff.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Thanks so much. I am glad you liked it.
@drparthibanchandransegaran4903
@drparthibanchandransegaran4903 5 лет назад
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?
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi thanks so much. I am really glad you liked the training. You can see the video training to automatically tab through cells: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-40aYorpxPiU.html
@leonardrobinson8757
@leonardrobinson8757 3 года назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
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.
@susank6122
@susank6122 2 года назад
Thank you! I learned lots. You are my hero! My goal is to know as much as you!
@ExcelForFreelancers
@ExcelForFreelancers 2 года назад
Happy to help and thanks so much Susan. Thank you for your Likes, Shares & Comments. It really helps.
@aziziabdullah6359
@aziziabdullah6359 3 года назад
Thanks for the great tutorial. I really love this video.
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
For sure, you are very welcome Azizi
@praveenkumarch7558
@praveenkumarch7558 3 года назад
Hi sir, It is an awesome work. Thanks for your valuable time and sharing of knowledge.
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
For sure, you are very welcome, I am happy I can help
@favouredbygod5439
@favouredbygod5439 5 лет назад
hi Rand, thanks for your training, it has helped me so much, am trying to run this contact manager that i have created and i receive this error "COMPILE ERROR, SYNTAX ERROR" please help, am using EXCEL 2017.
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi thanks for your comment, its hard to know what the issue is unless we see the bug and the code. 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
@rudy7019
@rudy7019 5 лет назад
Mr Randy thank you for you tutorial video and i do litte bit modify for mandatory insert data and how to make search data button in the list data we make? by using tutorial above
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi thanks for your comment. I put a search in my Employee Manager, you can view the series here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-iyr9WIyxlJc.html
@RobertLongM
@RobertLongM 4 года назад
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
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
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 RU-vid or a full course here: www.excelforfreelancers.com/product/advanced-excel-reports-dashboard-masterclass
@agonalia2796
@agonalia2796 4 года назад
Crazy....this tutorial is gold! Thanks!
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Thanks so much. I am glad you like it :)
@islamisbest7256
@islamisbest7256 4 года назад
Great Brother : your Videos are very helpful for beginner
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
I am really glad you liked it. Thanks so much.
@thedukeofno
@thedukeofno 4 года назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
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.
@tadelebirhanu2403
@tadelebirhanu2403 5 лет назад
Thank you very much ! I expect more video later on !
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
For sure no problem. I am glad you enjoyed it.
@thaof1898
@thaof1898 3 года назад
I completely succeeded making those macros and subs, just everything you taught us in the video. Thank you very much. You blowed my mind
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
For sure, you are very welcome Thao. I am so happy I can help. Cam on em. :)
@thaof1898
@thaof1898 3 года назад
@@ExcelForFreelancers OMG, you speak vietnamese to me, how kind you are
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
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.
@thaof1898
@thaof1898 3 года назад
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 :(
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
HI yes still on lockdown here but hopefully over soon. Otherwise safe here and just working. Thanks so much. Great city here.
@oyeolabikini4637
@oyeolabikini4637 5 лет назад
Thanks buddy. Very helpful. subscribed already.
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thanks so much. Glad you like it and I look forward to bringing you amazing videos and training each week. (also check out our new Employee Manager series)
@christiantoledopaglumotan884
@christiantoledopaglumotan884 4 года назад
Thank you so much Sir! 😇 God bless you and your team 😇😇😇
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
For sure, you are very welcome
@Yg3jMnBv
@Yg3jMnBv 4 года назад
Hello! Thank you very much for your great work!!!!! I have one question, i could not fınd an answer for that.... I want the table with contacts showed below the buttones to be locked.. I tried to few alternatives, but i assume bcs there is a code for the worksheet (1st one in your video) for selecting cells it does not allow to protect/unprotect the table. I would really appreciate your help. Or maybe you can tell me in which of your video i can find it?
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Hello Olga, thank you for your comments. You can protect the sheet and then make sure that Edit Objects in the protection pop-up is not selected. This will keep the buttons locked. If you use VBA to protect, you can add in xlUserInterfaceOnly in the code. This will allow VBA to make changes to protected cells, but not allow users to make changes to those same cells. 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
@leoarias3
@leoarias3 2 года назад
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!
@ExcelForFreelancers
@ExcelForFreelancers 2 года назад
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.
@kaiserluvkailove
@kaiserluvkailove 4 года назад
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.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Hi Kaiser, thanks so much for your comment. Here is a great training that will show you how to edit and save data: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-Ry3PYTMbskg.html Thank you for your Likes, Shares & Comments. It really helps.
@systemadmin8075
@systemadmin8075 2 года назад
Its amazing. thanks for your video
@ExcelForFreelancers
@ExcelForFreelancers 2 года назад
For sure, you are very welcome and happy to help.
@noureddinekrimche4926
@noureddinekrimche4926 5 лет назад
Many thanks a great job !!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
For sure you are very welcome noureddine.
@mohammadabdulrasheed5817
@mohammadabdulrasheed5817 5 лет назад
Thank you ... Excellent work
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
For sure, you are very welcome Mohammad
@najmulgani2814
@najmulgani2814 5 лет назад
This video is very very help full
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thanks so much. :)
@nikkodignadice7917
@nikkodignadice7917 4 года назад
This was awesome! Thank you for uploading this. It will help us beginners. Thanks! anyway, Is there a code if ever I want to search for specific Customer? Thanksss
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Hi Nikko, thanks very much. If you would like to learn search functionality check out my Employee Manager series or search my channel for the word "Search" and you will find a good video training to show you how to do this. Thank you for your Likes, Shares & Comments. It really helps.
@FabioGambaro
@FabioGambaro 5 лет назад
Hi, very useful video! Do you foresee any issues if the data is in an Excel table? I believe the table will add value, particularly when I have to summarize it with a Pivot...
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi Fabio, thanks very much for your question. Excel Tables are more limited in functionality however if you were to separate the data, you could then use it in any format. (meaning if you have one sheet of data) you can then bring it into a pivot table, or in a form like the one in the video. 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
@omaymarashad3726
@omaymarashad3726 4 года назад
It's amazing I have one question at the end of the video when you make change "update" by using data mapping I didn't get why you add number 8 I know you want to know the right column, right cells It's difficult part to me .
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Hi Omayma, Thanks for your comment. 8 is the column # where the data belongs. We need both the row and the column to place the data, so this is important. 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
@staceywebber3660
@staceywebber3660 5 лет назад
Great video, what is the data for conditional formatting, new rule...…...I cant make that out?
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Hi Stacey, Thanks for your comment. Please make sure to download the Free application using the links in the description above. There are 3 different conditional formats on this sheet: 1) When cells are blank make them yellow for required fields. Rule: Blank Cells 2) Color Alternate rows in table: Formula: =Mod(Row(),2)=0 3) Color Selected Row: Formula: =$B$2=ROW() I hope this helps. Should you have any additional questions, please do not hesitate to ask.
@papnyanamah2748
@papnyanamah2748 3 года назад
Hi Randy, Thanks again for this awesome work. It’s a masterpiece. Can this be used to manage students records for a school? My big brother is still using an archaic form to manage his school information. It sometimes takes him days to get a student’s information. Thanks once again 🙏
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
Hi and yes, This can easily be converted to students instead of Contacts. Please feel free to download this application and customize it however you like. Thanks again.
@bluetick6400
@bluetick6400 4 года назад
Hi randy. I love and been watching your videos so much and thank you for the effort you made to help others on using excel. But I have some problem while following and listening to all your instructions. Its about this line -> With .Pictures.Insert(PicPath) It keep showing me this is the problem. But I dont know what to fix
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
Hi Caramel, thanks so much for following and watching. Most likely the problem is with the PicPath, it has to be exactly right or there will be an error so you may want to look at it with a line Msgbox PicPath 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
@ramosastanos5318
@ramosastanos5318 4 года назад
thank you ! very helpful.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
For sure, you are very welcome
@busyfx23
@busyfx23 4 года назад
Wow!!! Very Coool.Great Teaching Techniques .keep it all Up.
@ExcelForFreelancers
@ExcelForFreelancers 4 года назад
More to come, thanks so much Abel
@jgenterprisesnew9552
@jgenterprisesnew9552 5 лет назад
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?
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
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.
@steventilk5635
@steventilk5635 3 года назад
Dude, Great Video!!! Thanks so much!!!
@ExcelForFreelancers
@ExcelForFreelancers 3 года назад
Thank you so very much, I really appreciate that Steven.
@JenJHayden
@JenJHayden 5 лет назад
this was fantastic!
@ExcelForFreelancers
@ExcelForFreelancers 5 лет назад
Thanks so much J, much appreciated
@RuelSinon
@RuelSinon 2 года назад
Amazing!!! Thank you so much for this
@ExcelForFreelancers
@ExcelForFreelancers 2 года назад
You're so welcome! Thank you for your Likes, Shares & Comments. It really helps.
Далее
How To Create Your First Excel Userform In Excel | Step By Step Training
51:52
How To Create Your First Excel Userform In Excel | Step By Step Training
Просмотров 20 тыс.
EASILY Make an Automated Data Entry Form in Excel
14:52
EASILY Make an Automated Data Entry Form in Excel
Просмотров 432 тыс.
Почему адаптеры Apple могут быть опасны?
00:51
Почему адаптеры Apple могут быть опасны?
Просмотров 2,8 млн
Обзор луков звезд. Премия МУЗ-ТВ 2024. Возвращение | Митя Фомин, Лолита, Ольга Бузова
1:08:27
Обзор луков звезд. Премия МУЗ-ТВ 2024. Возвращение | Митя Фомин, Лолита, Ольга Бузова
Просмотров 319 тыс.
КРАСИМ ДЕНЬГИ В РОЗОВЫЙ!
01:01
КРАСИМ ДЕНЬГИ В РОЗОВЫЙ!
Просмотров 464 тыс.
Что показала Бьянка другу?😅 #shorts #аленаблин #бьянка Смотрите в VK! ▶▶▶
00:37
Что показала Бьянка другу?😅 #shorts #аленаблин #бьянка Смотрите в VK! ▶▶▶
Просмотров 163 тыс.
Learn How To Become An Excel Developer As I Create This Customer Manager In Excel From Scratch
1:30:25
Learn How To Become An Excel Developer As I Create This Customer Manager In Excel From Scratch
Просмотров 377 тыс.
Say Goodbye to IF Statements in Excel with SWITCH
7:45
Say Goodbye to IF Statements in Excel with SWITCH
Просмотров 469 тыс.
How To Create An Excel Data Entry Form With A UserForm - Full Tutorial
36:11
How To Create An Excel Data Entry Form With A UserForm - Full Tutorial
Просмотров 722 тыс.
Create Excel Database and Data Entry Form. Excel Magic Trick 1690.
8:08
Create Excel Database and Data Entry Form. Excel Magic Trick 1690.
Просмотров 832 тыс.
How To Create A Powerful Point Of Sale (POS) Application In Excel [Full Training & Free Download]
1:40:00
How To Create A Powerful Point Of Sale (POS) Application In Excel [Full Training & Free Download]
Просмотров 8 млн
How to Create a Data Entry Form in Excel
34:30
How to Create a Data Entry Form in Excel
Просмотров 265 тыс.
Make Beautiful Excel Charts Like The Economist (file included)
19:07
Make Beautiful Excel Charts Like The Economist (file included)
Просмотров 389 тыс.
How To Create A Fillable Form With A Submit Button In Excel
29:20
How To Create A Fillable Form With A Submit Button In Excel
Просмотров 132 тыс.
Fully Automated Data Entry User Form in Excel - Step By Step Tutorial
35:41
Fully Automated Data Entry User Form in Excel - Step By Step Tutorial
Просмотров 3,5 млн
Уверен, каждый хотел бы себе телефон как Илона 😉
0:35
Уверен, каждый хотел бы себе телефон как Илона 😉
Просмотров 2 млн
CAA Conversion kit at ZAHAL 🎯
0:14
CAA Conversion kit at ZAHAL 🎯
Просмотров 73 млн
Первая встреча 💙
0:37
Первая встреча 💙
Просмотров 994 тыс.
Я - ПЕРЕКУП?! 💸🤑💰#питбайк #эндуро #мото #enduro #extreme #motocross #money #endurolive #перекуп #brz
0:53
Я - ПЕРЕКУП?! 💸🤑💰#питбайк #эндуро #мото #enduro #extreme #motocross #money #endurolive #перекуп #brz
Просмотров 857 тыс.
ОБМЕНЯЛ СКРЕПКУ НА ЛЮКСОВЫЙ АВТО! ЛИТВИН, ТАМАЕВ, СУБО, СТИЛ!
1:38:25
ОБМЕНЯЛ СКРЕПКУ НА ЛЮКСОВЫЙ АВТО! ЛИТВИН, ТАМАЕВ, СУБО, СТИЛ!
Просмотров 4,9 млн
FlexIQ Orbito #настольныеигры #boardgames #games #игры #настолки #настольные_игры
0:32
FlexIQ Orbito #настольныеигры #boardgames #games #игры #настолки #настольные_игры
Просмотров 4,3 млн
ОБМЕНЯЛ СКРЕПКУ НА ЛЮКСОВЫЙ АВТО! ЛИТВИН, ТАМАЕВ, СУБО, СТИЛ!
1:38:25
ОБМЕНЯЛ СКРЕПКУ НА ЛЮКСОВЫЙ АВТО! ЛИТВИН, ТАМАЕВ, СУБО, СТИЛ!
Просмотров 4,9 млн