For sure, you are very welcome 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/
This "from scratch" walk-through to build the Excel Workbook is amazing! You used functions and tools in ways I've been hoping to learn! Thank you! Can't wait to get started on Part 2!
Thank you so very much, I really appreciate that. Please check out our School Management series in which we build an entire application, from scratch, in a big series right here: bit.ly/SchoolManagerSeries
Thank you, professor. This part 1 was great. Your step-by-step was easy to follow and informative. Your explanations were easy to understand. The concept is a fundamental for anyone to freelance and make a living. Thank you so much. You are a great teacher and I look forward to sitting through the rest of the parts and learning and creating and applying.
Yeah...sure...I've said it before. But...I'll gladly say it over and over and over. "THANK YOU!!!" Your teaching method and level of detail is greatly appreciated. xoxo, Tammy
Great Dani, here are my questions as you are the best in VBA. Company A has multiple real estate buildings in 2 different cities City 1- zip code 1-building 1 - Units (20 apartments) City 1- zip code 2-building 2 - Units (10 apartments and 10 stores) City 2- zip code A-building A1 - Units (60 apartments) City 2- zip code B-building B1 - Units (100 apartments) My question is as follow : How to add 2 level conditions on the data validation list ? -when I select an Operation Type (lease, Termination, Hold Off) i want my DATA VALIDATION LIST to Only show VACANT UNITS for the selected building in a Leasing Transaction and LEASED UNITS for the selected building in a Termination. It is at the best (you) that we can throw these difficult questions.
HI and thanks for your comment. Your question has to do with dynamic and dependent data validation. I have a separate video training on that here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ToXa_3Gk0lc.html I hope this helps and thanks so much.
This is a perfect topic - I have been looking for suggestions on how to update the very basic property tracker (I created 20 years ago)!! I will follow all of the sessions - again Thanks.
Incredible content. I'm trying to change my job position and I'm learning to become a data analyst. I'm following your videos and try to learn as much as I can about excel for my future job. Those videos are really helpful to learn new skills. Thanks a lot.
Thank you so very much, I really appreciate that Enrick. Make sure you to catch my latest series "School Manager" in which I am creating an entire application from scratch in a multi-part series here: bit.ly/SchoolManagerSeries
Thanks so much Avi. I really love the multi-parts myself its just that people don't always watch the 2nd and 3rd parts. Certainly your shares, likes and comments will help a lot.
This looks great. I see that this can modified for another applications very easily. Thank you for this great training. It’s amazing what you can achieve in just one hour.
I've been watching this training sessions and trying to practice along, but I'm having trouble with the dummy data you're using. Could you please provide some guidance on how to follow along effectively or share more details about the data you've used? I want to make sure I understand and apply your teachings correctly.Thank you for your amazing training sessions! Your guidance has been invaluable and eager to learn more from your expertise.❤
Hi, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. I did this training many years ago and your question is not specific about the data. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi Randy, thanks very much for another great tutorial. It is well timed too, as I am nearing completion buying my first buy-to-let property, so this should come in very handy for managing that. Looking forward to Part 2.
Thank you Vimal. I will try to do more videos like that, but please make sure to watch Part 2 as well. Sometimes people will watch part 1 but not part 2. Thank you for your Likes, Shares & Comments. It really helps.
Hi Mark, thanks so much for your comment. You can watch the entire playlist here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-f-rBZozYcms.html I hope this helps and thanks so much.
Thank you so very much, I really appreciate that Yes for sure, you can find Part 2 here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-tF-G-wtQAHg.html I hope this helps and thanks so much.
HI and thanks you can get many of the icons I use here: adioma.com/icons However each week, I share all of the icons, pictures and resources from our training in our new Patreon account here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Hi Janet thanks so much. The Mentorship is great for beginners when you enroll in the Free VBA course for beginners as well. 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/ You can enroll in the Mentorship Program at the same time here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
HI and thanks, i make the icons, pictures and shapes available on my Patreon platform every week here: www.patreon.com/ExcelForFreelancers You can also get free icons from any of these sites icons8.com/iconizer/ adioma.com/icons www.iconsdb.com/ I hope this helps and thanks so much.
Hi, I use "Video Speed Controller" extension in Chrome. That way I can speed up, slow down or quickly replay any section of the video using shortcut keys.
Thanks for this great explanation video but its too hard for me to do. I'm really bad at excel.. I saw that there is a website called someka. They have templates like this. What do you think?
Hi and thanks so much. I am glad you liked it and of course you can use whatever templates work best for you. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy Thank you for the tutorial. Just one question. * Instead of put everything in one file, I want to use separate files : PROGRAM and DATABASE. So that, if I add/edit/change the macro in the future, it doesn't effect the database. Can you explain or have a video about linking the program and database in VBA ? Thank you sir. You are awesome.
Hi Frederick, you can have a backup of the database then just import it or write code. You can also share and sync your macro enabled workbook & database with any other file using this training ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-aKV5seZmiBs.html I hope this helps and thanks so much.
Can u just come to my house and teach me this? Lol jk Your awesome! Sitting here trying to build an excel file for 2020 and I’m LOST. Wearing out the rewind on RU-vid lol
Sure i am on my way to your house :) I am glad you liked the video. If you are new to VBA 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/ Thanks again
HI and thanks you can add Sharing & Sync to any application you want just by following the video in this training: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-aKV5seZmiBs.html I hope this helps and thanks so much.
Hi and thanks very much. You can find all 4 parts in the Rental Property Manager in this playlist here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-f-rBZozYcms.html&ab_channel=ExcelForFreelancers I hope this helps and thanks so much.
Hello. I am new to your video tutorials. Thank you for this video. I am new to excel and this video was a huge help. I found all the icons on one website I found you listed in your comments, except for the house in sections. Where can I find this logo/icon? Thank you.
Hi and thanks so much. I just found the house on a Google Search, so it did not come from any particular site. You can also find other icons here icons8.com/iconizer/ adioma.com/icons www.iconsdb.com/ I hope this helps and thanks so much. If you are new to VBA, you may want to consider enrolling in Daniel Strong’s Ultimate Excel VBA 30-hour course, in which I have secured a special discount for Excel For Freelancer Followers right here: bit.ly/VBACourse_Discount Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Hello! Thank you for the suggestions. Can you tell me exactly what you typed into google search because I still cannot find it and in order to create this part of the spreadsheet, I will need that house! Lol. I found all kinds of houses in the links you provided, but nothing like the one shown in your video. Please provide a link or a way to copy this so I can continue with this project. Thanks so much. Appreciate all your help!
Hi Dawn, I am really not sure as have done this 1 1/2 years ago however this house is so basic you could create it yourself using basic lines in no time at all. I hope this helps and thanks so much. You can also copy the one that i used and paste it into any picture program and save it . I hope this helps and thanks so much.
Hi and thanks when adding a column, you will want to make sure to update all formulas, functions, VBA code and conditional formatting if necessary. Please also check your named ranges to make sure they are accurate as well. As far as the error, it would be difficult to tell the cause however if you can upload screenshots and all details in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 60,000 Members who would love to help you with this. Thanks so much.
Hi France, thanks for your suggest. At the moment, on these older applications I do not, however on every new application I create, I add the icons, pictures and other resources in a zip file and make them available to all patrons on our Patreon platform here when you join: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much.
Hi and thanks. It all depends on who you are building the application for. If the end-user wants to use Access then its good, otherwise Excel can work for most small and medium sized business.
hi randy eagerly waiting fo this video. is it possible for you to show how to create estimate vs actual tool with variance column. the estimate and actual should be at resource level example labor material equipment other direct cost with subtotal and grand total. data for estimate and actual comes from 2 separate workbooks. . it should be in horizontal format. 1st col estimate next col actuals 3rd col variance. thank you. you are the best.
Hi and thanks so much. I have most of that already in a training and workbook here: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-2H59thd0W2k.html Feel free to download it and customize it for your own requirements. Thanks so much
Thanks so much. I do have a few videos on 'Expense and Reports' so please search my channel. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks so much. I have this video series, Rental Property Manager to show you. If you need help, or you would like this customized, we have a group with 60,000 Excel experts who would love the opportunity to customize this for you. Please join our Excel For Freelancers Facebook Group here: bit.ly/groupexcel (if you have not done so yet) You can then create a post and mark it as a PAID JOB, along with all of the details and requirements. Our members can then contact you and decide on how to best move forward with your project. I hope this helps and thanks so much.
Hi and thank you can add any icon you want using the Quick Access Toolbar. or when you click multiple shapes it will become available. I hope this helps and thanks so much.
So I have multiple properties underneath the same property name. When working under the property dashboard and I go to select the property name, how would I go about making the sheet only show one of each property name, and not repeating the same property name over and over as other options?
Hi Jake, thanks for your comment. You would want to make sure to differentiate each name so that it is unique such as adding a "-1" or "-2" to the end of the name or any other distinguishable characteristics to help you select the right property. I hope this helps and thanks so much.
@@ExcelForFreelancers So assuming I created a building tab and had multiple building names under the same property name, I wouldn't be able to go into the properties and buildings tab, select from property a in the dropdown, then have a dropdown for different buildings within that property a? Thanks so much for your reply!
H Sunny, thanks very much. I will keep the videos on Excel though, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Hello Randy. Great Work! Please I need the issue that I am having accessing the Mentorship Program course resolved asap. I have emailed you, I have called number on receipt, and I have left a message here on RU-vid, but I have yet to receive a response from you. Please do so. Thank you.
Hi Elmer we respond to every single email. Every day, Both me and my assistant. I responded to your email last week, but please feel free to email me with any issues here: Randy@ExcelForFreelancers.com Both me and my staff have sent you many, many emails without response from you, so please check your spam folder.
Hi Ray, this one does not, however I have another training on Bank Reconciliation, so you are welcome to combine them. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank you for your prompt response, I will try the 4 part property management first if I succeed I will be back asking how to combine. Should I manage the task how would I go about protecting it for resale
Hi and thanks you can use sheet protection to secure it. If you need help customizing it, please feel free to post a PAID JOB in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this. Thanks so much.
Hi thanks for the quick response . so have been building this Rental Property Management but on Alerts section where we Build notification when I run the "ADD NEW" Macro i get an error saying that " the item with the specified name wasn't found " and when I debug it shows a yellow line on ("ExistGrp"). Plz help and thank you.
Hi and thanks very much that means there is a group of shapes named "ExistGrp" that is missing. You may want to download the original again, display the selection pane on that sheet, and copy over the grouped shapes to your workbook then change the macros. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
Hi Pino, you can download this file for free using the links in the description above with either your email or Facebook Messenger. If you would like to have the template customized or secured, feel free to email me and I can refer you to a qualified developer for a fair price (Randy@ExcelForFreelancers.com ) I hope this helps, and thanks.
@@ExcelForFreelancers hi thanks for your reply. I actually downloaded them using my email but the problem is they are not completed so I can't really use them 😔
Hi and thanks so much. This is only for Excel on a desktop computer and not as an app, however Excel can work with an app, as I teach you in this video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WRIBkgF61rc.html I hope this helps and thanks so much.
Hi Michael, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Hi and thanks so much. This template is free, you are welcome to download it and customize it however you like. This is the only one I have, but make sure to catch the Part 2 and after that as well. I hope this helps and thanks so much.
Hi and thanks for your comment. There are 4 parts to this. You can find the entire series here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-f-rBZozYcms.html&ab_channel=ExcelForFreelancers
Hi Carl, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
Hi Carl, can you please post your issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Please keep in mind that these are templates and not completed applications. If you would like a completed application, customized for your requirements, please feel free to email me here: Randy@ExcelForFreelancers.com I hope this helps and thanks so much.