Hello Mr Austin, I'm one of your biggest students, i learned and still learning a lot from you. I just want to say thank you for this great and wonderful project. I've just finished this part 1 and waiting for others ! Thank you Sir, Keep working ! # From Haïti
Thank you so much Sebastien, I really appreciate that and looking forward to bringing you many more every week. Make sure to watch, share and comment on each one. Thanks again.
This is a great tool. The code is simple and short and works so flawlessly. I love that I can create multiple "forms" on one sheet with the end user being able to focus on one section cleanly. Thanks for sharing this with us.
Hi Randy, thnx for this part. It's great. I'm working as an exam's manager on a school in the Netherlands and can provide some workflow cases if you wish. What I'm really looking forward to is the ability not only to administer general data but grades- and results data on subject classes as well. With this and to define graduation criteria can indicate a successful graduation. The grades-systems over the world differ a lot. In the Netherlands for instance, it is common to grade in the decimal system (for 1,0 - 10,0 where 1,0 is the worst and 10,0 is the best grade). But in the US it is common to grade with letters (A through F I believe). So, on the Admin sheet we must define this. Another thing is (I'm a Privacy Officer to ;-)), depending on the role of the app user, some fields of sheets(parts) can or can't be mutate/seen. Therefore, a rightssystem would necessary.
Thank you Eric-Jan. Since I don't have the industry experience on this one, your insights are going to be really helpful. Yes for sure inside the Admin sheet we will have a table to define grades and scores of all types. Please feel free to email me with samples, as it will come in really handy. Randy@ExcelForFreelancers.com I have also had a few requests for user-rights and multiple-user application so I will probably be adding this in as well. Thanks so much, this will be a great application with your help and feedback.
I did something similar like this in MS Access for a school project. I based it from your vid which is very helpful. It's challenging and tiring but very worth it in the end. You're such a great help
Love it! Following step by step and making the parts I really need to make one of my work tools get to the next level. Thanks for sharing this and also for explaining everything step by step so wonderfully. You rock!
Hi there, this is not one of the best..it is the best tutorial I have come across after searching every where. I really wanted to keep track of my students assessment data and this is the best. But I will need your awesome assistance to help me out. Thank you so much for this wonderful tutorial and for sending me my free Automated Form Creator. You're a blessing. Thanks.
HI and thanks so much. I really appreciate that. If you would like to use this template, for yourself, you can download the final one, Part 20 I believe, then you can write some specifications to secure and customize it. Please then email me with those requirements (Randy@ExcelForFreelancers.com ) I can then refer a qualified developer since i am unable to take on any projects. I hope this helps and thanks so much.
I absolutely love your style of teaching! I'm very new to VBA & am finding the more I learn, the more I admire what can be done. The trick now is to find the right projects to apply this to & the time to build one of these beauties. Keep up the awesome work!
Thank you so very much, I really appreciate that LIz. Make sure you join 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.
Thank you so very much, I really appreciate that and I am really glad you enjoyed the training. Thank you for your Likes, Shares & Comments. It really helps.
Thanks for this. It is very best and helpful tutorial for me. I have seen many tutorials for school management but it is my full stop video. I am excited for next part. Please upload next part Asap.
this technique with selecting the "tabs" and showing / hiding the rows ... is easy but effective... i didnt even thought about it... never 😆 Thank you 😎🤙 it is a well strucutured project and video👍
I think its going to be better (hopefully) because this one I am going to do from scratch, during video, while the Employee Manager I did before the video, then explained what I did. Thank you for your support and watching these multi-part videos.
Thank you so very much, I really appreciate that Mustafe, These videos are released very Tuesday so the next one will be coming shortly. Much appreciated.
Like always Superb Tutorial, and I wanted to thank you that you took in consideration my suggestion in just supplying the Template with out all the coding. Looking forward to part 2 of this project.
HI and thanks Frantonio. I appreciate your suggestion however 99% would want the code as well, so I would have to create multiple downloads. My suggestion would be to download the application with the code, then delete the code and start again so you can practice. I hope this helps and thanks so much.
Impressive & Outstanding Randy, !!! one could simple ran out of superlatives to describe this application, you have setup a new bar in Excel applications and customization.
Hi Randy! Thank you so much for this great tutorial. I was able to successfully create this sheet with no errors and it is doing what you showed. My question is.....When you select a different student, is all the information supposed to populate for that student in the general info tab or will that be gone over in one of the upcoming trainings in this series?
Hi Wally, thanks so much for your comment and glad you enjoyed the training. When selecting a different student from the drop down list, the selected student should auto-populate the fields. This happens based on code from the Worksheet Change Event. Please feel free to download my sample to check. 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/VBADiscount_Randy
I have not had time to watch all of it yet so you might have said this already, but could the schedule section include one for the teacher, so they know what class to teach. And one for each student, so they would know what class and room to be in. So excited for this. I have been trying to modify the hotel booking one to do this.
That makes a lot of sense to have a 'teacher view' and a 'student view' so that when we email schedules out to students or teachers they are very different. I have written down your excellent idea so you can expect to see it in the coming weeks.
Hey Randy, thanks a bunch for high quality tutorials. 8 minutes into the video. One suggestion. To select a student, i feel it will be a better approach if we use IDs. These can be alphanumeric. Because two students in the same class can hàve same name. Since it is part 1, would be easy to make changes if you want to. Apologies if i jumped the gun
Hi Vinod, thanks for your suggestion. I do actually have Student ID's however i can add a search/enter field to load students based on entering the student ID which may help. Thanks for the nice suggestion.
Hi Randy, your tutorials are awesome. Can you help me the change in color based on click using conditional formatting. I've been stuck there . Thank you
Hi and thanks so much. Programming different colors in VBA with conditional formatting is extremely time-consuming. If you want to use multiple colors in multiple conditions use shapes instead. It's faster, easier to program and works extremely well. I show you how to do that here: ruclips.net/video/CNornJ75mZM/видео.html I hope this helps and thanks so much.
Hi Randy, Thanks very much for this amazing work. To be frank, your teaching is addictive. I can’t get enough of it. I always look forward to every post from you. 🙏 You rock 👌
Hi Matheus, when using the this will filter out and exclude any values that are blank or empty. I hope this helps. Should you have any additional questions, please join our Excel For Freelancers Facebook Group in which we have thousands of Excel experts who can guide and help you with your Excel Questions. Just post your detailed question, and upload your current workbook, or post detailed screenshots so we can get you the answers you need, fast. Please join here: bit.ly/groupexcel
HI and thanks I am sure we can get that fixed for you. Can you post your issues in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 40,000 Members who would love to help you with this and many are Dutch. Thanks so much.
Hi Randy, question: after I purchased that 200 templet can I use them for my school or can I modified them as I needed? I need school manager templet. and Can I buy only school manager templet only? please let me know. Thanks for ur good work.
Hi and thanks for your comment. You are welcome to use the applications however you like, i just ask that you do not create RUclips videos using them. I do not have the School Manager by itself however the entire application is already included in my 200 workbook pack. www.excelforfreelancers.com/product/200-of-my-best-excel-workbooks I hope this helps and thanks so much.
Question how did you duplicate the button at 21:28 in the video Got it Control D if I would have paid more attention at 22:05 I love this Excel You are amazing at it
Thanks so much, Leonard, yes Ctrl + D. If you want to copy a shape that is in a group and keep it in a group use Ctrl + D. IF you are want to duplicate a shape that is in a group on the outside of a group use Ctrl + C then Ctrl + V. I hope this helps and thanks so much.
@@ExcelForFreelancers Thank You I am enjoying this alot I am going to go through all the lessons So I may have a lot of questions Hope you Do not Mind. My first problem is I got to the part to make the first macro But it works if I Choose Code and Macros but it does not work when I click on General Info Tab 56:26. I went into the trust Center and Selected (Enable VBA macros) and I check marked (Enable Excel 4.0 macros when VBA macros are enabled ) and with (Trust access to the VBA project object model) Checked I also went into Active X Settings and Chose (Enable all controls without restrictions and without prompting ) I also Went into my Computer settings and turned on Developer Mode Still Nothing Now it is Saying it is installing Windows Developer Mode Package Hope That Works.
Hi can you upload your specific questions, with screenshots, 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.
Good day Randy Thank you very much for your videos and step by step instructions. I have the following question about the School Manager. How can I enter a change of address? That means I want to add a new address to an existing record. Is that possible? Kind regards Riccardo
Hi and thanks for your Comment Richard, If you want to have multiple address via a single record you can do that in a new table as long as the addresses are linked with a single ID such as "Student ID". All of the addresses can them be displayed in a small table in the Student Information. 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
The long awaiting has finally dropped. Can't wait for it. Let's do up to Part 10. With the ability to email parents individually of their arrears and student results from excel.
Yes good idea. We have both Parents and Student emails, so in my Email & Notification Center I will include the ability to email parents and not students in some cases.
hi Randy, i used to follow your tutorial and always amazing. i want to ask you one thing. how you set an ID number to begin from 1001 or please demonstrate me which tutorial i shall attend to know this. thanks a lot
Hi and thanks so much. Assuming you have no data in your database and you want to set the Next Student ID to 1001 you would use a formula like this =IFERROR(Max(Stud_ID)+1,1001) I hope this helps and thanks so much.
Thank you so much for those explanations, it's so cool ! Can anyone can help me figure out how to fix the problem that appears at 1:51:06 please ? I can't find the answer in the video, I probably missed it... Thanks again !
Hi Nicolas, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
Thank you so very much, I really appreciate that Ahmad. Please make sure to watch each week in this series and you will learn how to build an amazing application.
Hi and thanks so much. You can set up a schedule of fees with an alert based on date, and update the balances. Next week I will have a Debt Manager coming that will help you with this. I hope this helps and thanks so much.
I saw this on 2024. Its exactly what was i am looking for . I lost too many of my skills deo to lack of practice. In my region everyone is talking about the easy part . But no body spoken about this full system to manage all classes . My challenge is to include result system for the students. This lesson is too important to me ❤❤❤ God bless you ❤
Hi and thanks so much. This is exclusive to Excel and not google sheets which uses a very different coding structure. I will be adding Share & Sync to this application so you will be able to share and sync this application with any user in the world, so there may not be a need for Google sheets. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, am watching your tutorial very nice videos thanks more but i have a question where your create new rules formatting =mod(Row0,2)=o please check if am doing wrong
Hi and thanks so much. It looks like in your sample, the last character is a o (letter o) and should be a 0 (number zero) Mod(Row(),2)=0 I hope this helps and thanks so much.
Thanks too that you're helping me, i got it. There's another question which is assigned macro to (New student) it's showing me (the item with the specified name wasn't found) @ExcelForFreelancers
Hi and thanks. this usually means that VBA is looking for a specific shape that does not exist on the sheet. It would be difficult for us to help unless we see the specific bug you are running into. 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.
I totally love learning this. I do have a question though. I have more rooms than you do. for some reason I can't get them all to display and I receive this error
Case Is = "Room" Room = .Range("CH" & ResultRow).Value 'Room SchedCol = Schedule.Range("P2:BB2").Find(Room).Column
It is the last row of this that is erroring out. Where should I look?
Hi Tressa, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
Great app I'm trying to adapt for a different purpose, learnt a lot and slowly getting there :) Just need to figure out why my SaveUpdate macro won't call and run the SortNames macro - nothing like a challenge :)
Hi John, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into 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 and thanks so much. 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
This is awesome! Thank you for this amazing tutorial. I was wandering if you could do also a Fb group manager for admins (to take track of all the members, the roles, and the 'bad' members like a black list). btw thank you so much for this tutorial!
Thank you so very much, I really appreciate that. I will certainly consider the FB Group manager training in the near future. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy. This is simply awesome!!! Been following along and creating my own. Seems everything is working perfectly!!! The only issue am having is that when I add New Student the Student ID is not automatically being created. Also, what if there are pre-created Student IDs i.e. A2365, will that be able to work if someone enters these in any order? Thanks for the wonderful work. Gift from Malawi
Hi Gift, thanks so much and glad you like the training. Make sure you pull new student ID's from the cell that contains the formula =Max(Stud_ID)+1 Also if you want to combine alphanumeric letters with your id you can use a helper column. One column with only numeric values and another column to combine the text with numbers 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
Is it possible to connect this Excel VBA to wordpress School website in backend so that students and parents can login and know the details? Can you make a video on that how to connect it?
Hi and thanks so much. I do have a video in which I connect WoredPress to Excel here ruclips.net/video/egzNg7AL7uY/видео.html I hope this helps and thanks so much.
@@ExcelForFreelancers I don't understand that how I use for this? Trigger option is not applicable for this case, right? Can you make a seperate video for this? It will be a great help for us.
This us great great lesson and will be comprehensive application. Any chance of including a lesson on how to run this application on secondary basis with all data being reinstated with master copy in case of unintentionally or intentionally temper of application. This borders around protection and security of application i guess.
HI Vimal thanks so much for your suggestion. I am sure you will love this. If you save this application in any type of a cloud folder such as Dropbox, OneDrive or Google Drive, each saved version is already stored on a server, protecting the data. That is probably the best and easiest solution since it does not require any additional programming. I hope this helps and thanks so much.
Hi Randy, Thank you for this great video. I have learnt so much. I was following along but on the Sort Names macro, I get a compile error saying that the SkipSort function or sub is not defined. How would I correct the error? I also tried adding more data to my database and when I do that, it sorts all the data in that row including the header. I have typed in all the VBA code exactly as you have in the video. I would really appreciate some assistance. I am watching from South Africa.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. 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.
@@ExcelForFreelancers I have done that and have been assisted on the forum. I appreciate it and am looking forward to learning even more from this page 😃😃
Hi Brandon in each of those columns i put in a formula '=Column()' This formula displayed the column # that it is in. (Just to show you the columns) then I highlighted those cells and clicked the Delete key as they were just used to show you what column #'s they were. I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers do you build excel products for people to use. If so do you have any contact information that I explain what I am looking for and then tell me the cost to build it?
Hi Brandon, I am unable to take on any projects myself, however if you would like to write up a detailed scope and email it to me (Randy@ExcelForFreelancers.com) I can then refer a qualified developer. I hope this helps and thanks so much.
What I like to do with sheet codenames is prefix them with 'ws'. This has 3 benefits, 1. it is visually apparent in your code that you are referencing a worksheet 2. when you type 'ws' intellisense shows only your sheets and 3. you are unlikely to have any other variables with that name.
Hi Steve, thanks for your comment. I also received your email on the same. The School Manager application will be available for sale within a few months, fully completed, however the training part of it will be done next week.
Hello Randy, Thank you for video. I am having trouble with the conditional formatting for the Sel. Tab Col. When I click on the tabs, General Info etc. the number doesn't recognize the column number.
Hi Wendy, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
Hi, Randy. I'm enjoying your practicals. But I'm stuck. I don't get the part where you are creating the color change based on conditional formatting. Please can you walk me through it.
Hi and thanks so much. If you use an adjacent cell value, you can apply conditional formatting based on that adjacent cell (Or you can use shapes, which is probably faster and better and uses less memory like in the sample i gave you in your other comment)
I need help I am trying to do the sort names in the StudentDB but it wont add my name to Sorted Names column in AA3. I have checked my code and it matches yours but will not transfer the names over to the AA column like in timestamp 1:50:59 of your video. Can I get any help with this?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. 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 thank you for these videos, they are an excellent source of knowledge! I do have one question Do you suggest we continue using non named ranges for larger projects? Example: on the horizontal tabs instead of having to write out which rows to un hide, would it be better (aka better “code” and “habits”) to name those ranges and use them as such? I even noticed on some loops you like to count out columns rather than do some sort of .count, I wanted to see if there was some reasoning behind this
Hi Saul, thanks for your comment. I like using as many named ranges as possible. I like to see them in the code and in formulas. In my big Accounting application I have hundreds of them. I once heard that too many named ranges slows down an application but I have never scientifically tested this theory out. So yes, adding named ranges in these instances will work very well. I hope this helps and thanks so much.
@@ExcelForFreelancers Is it possible for the application to include an instant picture and fingerprint capture during the initial general information capture for students and teachers database?
Hi and thanks Zainab, if you have a fingerprint reader you can then translate that into a unique ID. This ID can be stored with each student. I hope this helps and thanks so much.
Hi yes and thanks, you can use my Data Import Manager training to do that (just search my channel) I hope this helps and thanks so much Noemi (You can also just copy and paste the students from your database to the current application)
Thank you so much for the tutorial. This is very useful. I am referring to your video and try to build a simplified version on my own. However, I have encountered a issue when trying to create the button. When I click on the new student button, the 'existing student group' button doesn't appear. Wondering if it is linked to the codes that I might miss out during the process. Hope you can guide me on this. Thanks a lot.
Hi Sarah, thanks so much. You can check your 'Selection Pane' to see which pictures exists and which don't, or are not displayed. Sometimes groups or shapes do not appear because their width or height moves to 0. 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
Scheduling please ... with daily and weekly and monthly options..along with predecessors.. I have been trying out the hotel management app.. but not going anywhere.. hope this series could help.. Hope u could include that Randy.. please 🙏
Hi and thanks Avi, yes most certainly we will be doing Day, Week & Month Scheduling Views since that is really an important part of this application. Thank you for your Likes, Shares & Comments. It really helps.
Fantastic tutorial! How can we make Excel be side by side with another app like a browser. I would like to see most of the Excel? I know how to split screen but I need to scroll a bit.
HI and thanks very much. There are some ways you can add a browser in Excel and also run them side by side. Perhaps you can add some screenshots and samples of what you are looking for 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 and thanks so much for your suggestion Jersey French. If i get enough requests for this feature I will be adding it in. Thank you for your Likes, Shares & Comments. It really helps.
Hi and thanks. I will do my best. If you need to have a specific application made for you, 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 Randy! Thanks for the amazing training session. I don't know if I missed that part here, but is there a code in the sheet to check we have duplicate entries (like if we end up adding the same student info twice)? Thanks again :)
Hi and thanks, I have one video that may help you called Conversion Manager here: ruclips.net/video/CRITdthMYlU/видео.html I hope this helps and thanks so much.
Hi and thanks. Yes it is certainly possible with my Share & Sync training in which you can share and sync your macro-enabled workbook with anyone in the world here: ruclips.net/video/aKV5seZmiBs/видео.html I hope this helps and thanks so much.
Thanks for the video, your videos are always amazing. Sir, can you pls create an application in excel were on can attach JPEG or PDF files, and also download them.
Hi and thanks so much. I have that already here: ruclips.net/video/lHT0u2zFBoQ/видео.html Thank you for your Likes, Shares & Comments. It really helps.
column selection is not work on my system even after entry the new rule code=$B$5=column(). i didnt any responses can you help, i use hp probook 6470b ms excel2019.
HI and thanks, Your version of Excel and your laptop is just fine. It would be hard to know the problem unless we see pictures of your code and your sheet. Can you post your detailed 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. Thanks so much.
hello, My problem is: after assigning a macro to new student, as soon as I click on new student it displays: Run-time error '1004' We can't do that to a merged cell. and then in visual basic the range of: .Range("F3,F7,F9,H9,J9, etc has turned yellow. How to arrange ? please. This part 1:22:06
HI and thanks that means you are trying to clear the contents of a merged cell, however you have not identified the upper left and lower right cell addresses within VBA. So if Cell A1 is merged with B1 and you try to clear out only A1, it will return an error. You must use something like Sheet1.Range("A1:B1").clearcontents I hope this helps and thanks so much.
Randy Austin, thank you so much. What I want to request you in the second tutorial is that when I click on update button and didn't make any changes in the Target cells I want to get message box "please make at least one change to update student" then if the user makes change, save that change. That's all teacher. I'm sure you can. And you will in the second party. Thanks again.
Hi and thanks very much. You are welcome to download it for free using the link in the description and customize it yourself. I hope this helps and thanks so much.
![How To Create A Simple, Yet Powerful, Vertical Menu In Excel, And A TON More [School Manager Pt. 2]](http://i.ytimg.com/vi/7vMRJlFvi_Q/mqdefault.jpg)
![How To Create A Simple, Yet Powerful, Vertical Menu In Excel, And A TON More [School Manager Pt. 2]](/img/tr.png)
![Create Horizontal AND Vertical Tabs in this Excel Employee Manager [Part 1]](/img/1.gif)
😱 𝗧𝗨𝗥𝗡 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗗𝗔𝗧𝗔 𝗜𝗡𝗧𝗢 𝗦𝗜𝗠𝗣𝗟𝗘 𝗦𝗢𝗟𝗨𝗧𝗜𝗢𝗡𝗦 𝗪𝗜𝗧𝗛 𝗔𝗜 ▶ www.excelforfreelancers.com/AiDataAnalystYTPinnedComment
I am very thankful to you for starting this series. I requested it two months ago and now I am having it. So nice of you. Thanks a lot.
That is great. I am very happy to bring this to you. Thank you for your Likes, Shares & Comments. It really helps.
Hello Mr Austin, I'm one of your biggest students, i learned and still learning a lot from you. I just want to say thank you for this great and wonderful project. I've just finished this part 1 and waiting for others ! Thank you Sir, Keep working ! # From Haïti
Thank you so much Sebastien, I really appreciate that and looking forward to bringing you many more every week. Make sure to watch, share and comment on each one. Thanks again.
This is a great tool. The code is simple and short and works so flawlessly. I love that I can create multiple "forms" on one sheet with the end user being able to focus on one section cleanly. Thanks for sharing this with us.
For sure, you are very welcome. I am happy to help and share
Hi Randy, thnx for this part. It's great. I'm working as an exam's manager on a school in the Netherlands and can provide some workflow cases if you wish. What I'm really looking forward to is the ability not only to administer general data but grades- and results data on subject classes as well. With this and to define graduation criteria can indicate a successful graduation. The grades-systems over the world differ a lot. In the Netherlands for instance, it is common to grade in the decimal system (for 1,0 - 10,0 where 1,0 is the worst and 10,0 is the best grade). But in the US it is common to grade with letters (A through F I believe). So, on the Admin sheet we must define this.
Another thing is (I'm a Privacy Officer to ;-)), depending on the role of the app user, some fields of sheets(parts) can or can't be mutate/seen. Therefore, a rightssystem would necessary.
Thank you Eric-Jan. Since I don't have the industry experience on this one, your insights are going to be really helpful. Yes for sure inside the Admin sheet we will have a table to define grades and scores of all types. Please feel free to email me with samples, as it will come in really handy. Randy@ExcelForFreelancers.com
I have also had a few requests for user-rights and multiple-user application so I will probably be adding this in as well.
Thanks so much, this will be a great application with your help and feedback.
Your channel and education method is second to none!
Thank you so very much, I really appreciate that. :)
I did something similar like this in MS Access for a school project. I based it from your vid which is very helpful. It's challenging and tiring but very worth it in the end. You're such a great help
Thank you so very much, I really appreciate that Angela. I believe you will love this serires.
Love it! Following step by step and making the parts I really need to make one of my work tools get to the next level. Thanks for sharing this and also for explaining everything step by step so wonderfully. You rock!
For sure, you are very welcome and I am happy to help and share
Hi, I am from Indonesia. I am really glad to find your youtube channel. This is what I want. Thank you Randy. I am ready to be your student
For sure, you are very welcome, please follow this series every week. Today we launch Part 10 so make sure you catch up. Thanks again
year for all of us, for so- it's still ongoing. i respect you for being honest as that's what's been keeping a bit sane recently, just being
Thank you for your Likes, Shares & Comments. It really helps Puskar
Hi there, this is not one of the best..it is the best tutorial I have come across after searching every where. I really wanted to keep track of my students assessment data and this is the best. But I will need your awesome assistance to help me out. Thank you so much for this wonderful tutorial and for sending me my free Automated Form Creator. You're a blessing. Thanks.
HI and thanks so much. I really appreciate that. If you would like to use this template, for yourself, you can download the final one, Part 20 I believe, then you can write some specifications to secure and customize it. Please then email me with those requirements (Randy@ExcelForFreelancers.com ) I can then refer a qualified developer since i am unable to take on any projects.
I hope this helps and thanks so much.
I absolutely love your style of teaching! I'm very new to VBA & am finding the more I learn, the more I admire what can be done. The trick now is to find the right projects to apply this to & the time to build one of these beauties. Keep up the awesome work!
Thank you so very much, I really appreciate that LIz. Make sure you join 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.
This is so good... Well done and thank you for giving time to do this School Manger System. Waiting for the next video...
It's my pleasure Buri, I am glad you enjoyed it. I can't wait to bring you many more in this series.
You have a heart of gold!
Thank you so very much, I really appreciate that and I am really glad you enjoyed the training.
Thank you for your Likes, Shares & Comments. It really helps.
Thank you Sir. You're the best among RUclipsrs. I like to follow you cause you explain things much better. You're my hero. Have a nice day!
Thank you so very much, I really appreciate that Hamid
Just watched part of this video. Excellent presentation.
Thank you so very much, I really appreciate that.
Very much looking forward to this series - thank you Randy
Thank you so very much, I really appreciate your continued support Tony.
Thanks for this. It is very best and helpful tutorial for me. I have seen many tutorials for school management but it is my full stop video. I am excited for next part. Please upload next part Asap.
THanks so much. I will have a new one each Tuesday. It will be available here in just 36 hours: ruclips.net/video/7vMRJlFvi_Q/видео.html
this technique with selecting the "tabs" and showing / hiding the rows ... is easy but effective... i didnt even thought about it... never 😆
Thank you 😎🤙
it is a well strucutured project and video👍
Thank you so very much, I really appreciate that Kolavit
This is really one of the marvelous creation by by the freelancers the Excel freelancer you really did it best
Thank you so very much, I really appreciate that :)
I think this tutorial will be the same as the Employee Manager, the one you did before and I can't wait for this training
I think its going to be better (hopefully) because this one I am going to do from scratch, during video, while the Employee Manager I did before the video, then explained what I did. Thank you for your support and watching these multi-part videos.
Thanks millions of time, it the best I have seen. I can't wait the next video please send it quickly
Thank you so very much, I really appreciate that Mustafe, These videos are released very Tuesday so the next one will be coming shortly. Much appreciated.
Like always Superb Tutorial, and I wanted to thank you that you took in consideration my suggestion in just supplying the Template with out all the coding. Looking forward to part 2 of this project.
HI and thanks Frantonio. I appreciate your suggestion however 99% would want the code as well, so I would have to create multiple downloads. My suggestion would be to download the application with the code, then delete the code and start again so you can practice. I hope this helps and thanks so much.
Good Morning Randy from mid America.
Great start of a really insightful project.
Thanks so much Al, I always appreciate your comments. I am sure you will love this series.
Thanks for this good memory refreshment I really needed that :) looking forward to Part2 :)
You are very welcome P. Rietveld, I am glad you enjoyed it and Part 2 will not disappoint.
Impressive & Outstanding Randy, !!! one could simple ran out of superlatives to describe this application,
you have setup a new bar in Excel applications and customization.
Thank you so very much, I really appreciate that Edward. I look forward to your feedback and ideas in this series.
im from Philippines, great tutorial. thank you
Thank you so very much, I really appreciate that.
Hi Randy! Thank you so much for this great tutorial. I was able to successfully create this sheet with no errors and it is doing what you showed. My question is.....When you select a different student, is all the information supposed to populate for that student in the general info tab or will that be gone over in one of the upcoming trainings in this series?
Hi Wally, thanks so much for your comment and glad you enjoyed the training. When selecting a different student from the drop down list, the selected student should auto-populate the fields. This happens based on code from the Worksheet Change Event. Please feel free to download my sample to check.
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/VBADiscount_Randy
waow sir nice and one of the best school manager system, wait for next video
Thank you so very much, I really appreciate that.
I have not had time to watch all of it yet so you might have said this already, but could the schedule section include one for the teacher, so they know what class to teach. And one for each student, so they would know what class and room to be in. So excited for this. I have been trying to modify the hotel booking one to do this.
That makes a lot of sense to have a 'teacher view' and a 'student view' so that when we email schedules out to students or teachers they are very different. I have written down your excellent idea so you can expect to see it in the coming weeks.
Hey Randy, thanks a bunch for high quality tutorials. 8 minutes into the video. One suggestion. To select a student, i feel it will be a better approach if we use IDs. These can be alphanumeric. Because two students in the same class can hàve same name. Since it is part 1, would be easy to make changes if you want to. Apologies if i jumped the gun
Hi Vinod, thanks for your suggestion. I do actually have Student ID's however i can add a search/enter field to load students based on entering the student ID which may help. Thanks for the nice suggestion.
@@ExcelForFreelancers Thanks. It will make things a lot easier.
Thank you so much for all these tutorials bro. So much valuable knowledge
For sure, you are very welcome Muhammad.
Thank yo so much Randy. It has helped me learn a lot from you Sir. Very proud of your VBA skills
For sure, you are very welcome I am happy to help.
Hi Randy, your tutorials are awesome. Can you help me the change in color based on click using conditional formatting. I've been stuck there . Thank you
Hi and thanks so much. Programming different colors in VBA with conditional formatting is extremely time-consuming. If you want to use multiple colors in multiple conditions use shapes instead. It's faster, easier to program and works extremely well. I show you how to do that here: ruclips.net/video/CNornJ75mZM/видео.html
I hope this helps and thanks so much.
Hi Randy,
Thanks very much for this amazing work. To be frank, your teaching is addictive. I can’t get enough of it. I always look forward to every post from you. 🙏
You rock 👌
Awesome, thank you so much Pap. I really appreciate that.
This is absolutely amazing
Thanks so much. Very kind of you Nasir
Another great training coming up. Thank you.
Thanks so much. I think you will really love this series.
Could somebony explain to me what the Adv. Filter criteria does?
Hi Matheus, when using the this will filter out and exclude any values that are blank or empty. 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
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Hi Randy, what an amazing tutorial!! Sad though that some of the formulas won't work in Dutch Excel 365. What can I do about that?
HI and thanks I am sure we can get that fixed for you. Can you post your issues in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel
We have 40,000 Members who would love to help you with this and many are Dutch. Thanks so much.
I can't wait for part 2
Thank you so very much, I really appreciate that and I can't wait to bring it to you. Thank you for your Likes, Shares & Comments. It really helps.
بارك الله بكم وبجهوكم ❣may god bless you many thanks
Its no problem, I am happy to help and share سجاد جاسم محمد عبد النبي
Only source of best education on excel
Thank you so very much, I really appreciate that Farrukh
Hi Randy, question: after I purchased that 200 templet can I use them for my school or can I modified them as I needed? I need school manager templet. and Can I buy only school manager templet only? please let me know. Thanks for ur good work.
Hi and thanks for your comment. You are welcome to use the applications however you like, i just ask that you do not create RUclips videos using them. I do not have the School Manager by itself however the entire application is already included in my 200 workbook pack. www.excelforfreelancers.com/product/200-of-my-best-excel-workbooks
I hope this helps and thanks so much.
@@ExcelForFreelancers thanks a lot.
Love to watch your tutorial,❤️ from India
Awesome! Thank you Golam
Question how did you duplicate the button at 21:28 in the video Got it Control D if I would have paid more attention at 22:05 I love this Excel You are amazing at it
Thanks so much, Leonard, yes Ctrl + D. If you want to copy a shape that is in a group and keep it in a group use Ctrl + D. IF you are want to duplicate a shape that is in a group on the outside of a group use Ctrl + C then Ctrl + V.
I hope this helps and thanks so much.
@@ExcelForFreelancers Thank You I am enjoying this alot I am going to go through all the lessons So I may have a lot of questions Hope you Do not Mind. My first problem is I got to the part to make the first macro But it works if I Choose Code and Macros but it does not work when I click on General Info Tab 56:26. I went into the trust Center and Selected (Enable VBA macros) and I check marked (Enable Excel 4.0 macros when VBA macros are enabled ) and with (Trust access to the VBA project object model) Checked I also went into Active X Settings and Chose (Enable all controls without restrictions and without prompting ) I also Went into my Computer settings and turned on Developer Mode Still Nothing Now it is Saying it is installing Windows Developer Mode Package Hope That Works.
Hi can you upload your specific questions, with screenshots, 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.
@@ExcelForFreelancers Absolutely Thank you I want to join that facebook group
Good day Randy
Thank you very much for your videos and step by step instructions.
I have the following question about the School Manager.
How can I enter a change of address? That means I want to add a new address to an existing record. Is that possible?
Kind regards
Riccardo
Hi and thanks for your Comment Richard, If you want to have multiple address via a single record you can do that in a new table as long as the addresses are linked with a single ID such as "Student ID".
All of the addresses can them be displayed in a small table in the Student Information.
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
The long awaiting has finally dropped. Can't wait for it. Let's do up to Part 10. With the ability to email parents individually of their arrears and student results from excel.
Yes good idea. We have both Parents and Student emails, so in my Email & Notification Center I will include the ability to email parents and not students in some cases.
Hi I am from Bhutan and I absolutely like your teaching. I'm learning lots from your videos. Keep up the awesome work... Thank you so much
Thank you so very much, I really appreciate that and so happy I can help. Thank you for your Likes, Shares & Comments. It really helps.
hi Randy, i used to follow your tutorial and always amazing. i want to ask you one thing. how you set an ID number to begin from 1001 or please demonstrate me which tutorial i shall attend to know this. thanks a lot
Hi and thanks so much. Assuming you have no data in your database and you want to set the Next Student ID to 1001 you would use a formula like this
=IFERROR(Max(Stud_ID)+1,1001)
I hope this helps and thanks so much.
good work king, love you
Thank you so very much, I really appreciate that
This is very interesting. Is this a multiple user workbook?
Hi and thanks. Yes I will be adding multi-user functionality to this workbooks so please make sure to watch each video in the series.
Was waiting for this from a long time part 2......
Thank you Javeed, Happy to share and help.
Thank you so much for those explanations, it's so cool ! Can anyone can help me figure out how to fix the problem that appears at 1:51:06 please ? I can't find the answer in the video, I probably missed it... Thanks again !
Hi Nicolas, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
Great job Randy 👌
Thank you so very much, I really appreciate that Ahmad. Please make sure to watch each week in this series and you will learn how to build an amazing application.
Thanks so much for this wonderful training.
My question is how can I track the updates on fees balances.
Calculation of fees balances automatically
Hi and thanks so much. You can set up a schedule of fees with an alert based on date, and update the balances. Next week I will have a Debt Manager coming that will help you with this. I hope this helps and thanks so much.
Yes thanks so much for this wonderful reply
Thank you so much Randy for this amazing tutorial. I was actually looking for it for quite some time.
Thank you Syed, A lot of people have suggested it so it is about time I started this. Thanks again for your continued support.
I saw this on 2024. Its exactly what was i am looking for .
I lost too many of my skills deo to lack of practice. In my region everyone is talking about the easy part . But no body spoken about this full system to manage all classes . My challenge is to include result system for the students.
This lesson is too important to me ❤❤❤
God bless you ❤
Thank you so very much, I really appreciate that and I am glad I can help and share
Nice one - Thank you Randy
Thank you so very much, I really appreciate that.
Hi Randy, this is fantastic! Would I be able to apply this in google sheets too?
Hi and thanks so much. This is exclusive to Excel and not google sheets which uses a very different coding structure.
I will be adding Share & Sync to this application so you will be able to share and sync this application with any user in the world, so there may not be a need for Google sheets. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, am watching your tutorial very nice videos thanks more but i have a question where your create new rules formatting =mod(Row0,2)=o please check if am doing wrong
Hi and thanks so much. It looks like in your sample, the last character is a o (letter o) and should be a 0 (number zero)
Mod(Row(),2)=0
I hope this helps and thanks so much.
Thanks too that you're helping me, i got it. There's another question which is assigned macro to (New student) it's showing me (the item with the specified name wasn't found) @ExcelForFreelancers
Hi and thanks. this usually means that VBA is looking for a specific shape that does not exist on the sheet. It would be difficult for us to help unless we see the specific bug you are running into. 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.
I totally love learning this. I do have a question though. I have more rooms than you do. for some reason I can't get them all to display and I receive this error
Case Is = "Room"
Room = .Range("CH" & ResultRow).Value 'Room
SchedCol = Schedule.Range("P2:BB2").Find(Room).Column
It is the last row of this that is erroring out. Where should I look?
Hi Tressa, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
Great app I'm trying to adapt for a different purpose, learnt a lot and slowly getting there :) Just need to figure out why my SaveUpdate macro won't call and run the SortNames macro - nothing like a challenge :)
Hi John, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into 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.
I am having this same challenge
I really enjoy the lessons.
I want to learn VBA programming itself from scratch. Do you by anyway have videos on that...
Hi and thanks so much. 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
This is awesome! Thank you for this amazing tutorial. I was wandering if you could do also a Fb group manager for admins (to take track of all the members, the roles, and the 'bad' members like a black list). btw thank you so much for this tutorial!
Thank you so very much, I really appreciate that. I will certainly consider the FB Group manager training in the near future. Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy. This is simply awesome!!! Been following along and creating my own. Seems everything is working perfectly!!!
The only issue am having is that when I add New Student the Student ID is not automatically being created. Also, what if there are pre-created Student IDs i.e. A2365, will that be able to work if someone enters these in any order?
Thanks for the wonderful work. Gift from Malawi
Hi Gift, thanks so much and glad you like the training. Make sure you pull new student ID's from the cell that contains the formula =Max(Stud_ID)+1
Also if you want to combine alphanumeric letters with your id you can use a helper column. One column with only numeric values and another column to combine the text with numbers
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
Is it possible to connect this Excel VBA to wordpress School website in backend so that students and parents can login and know the details? Can you make a video on that how to connect it?
Hi and thanks so much. I do have a video in which I connect WoredPress to Excel here ruclips.net/video/egzNg7AL7uY/видео.html
I hope this helps and thanks so much.
@@ExcelForFreelancers I don't understand that how I use for this? Trigger option is not applicable for this case, right? Can you make a seperate video for this? It will be a great help for us.
This us great great lesson and will be comprehensive application.
Any chance of including a lesson on how to run this application on secondary basis with all data being reinstated with master copy in case of unintentionally or intentionally temper of application. This borders around protection and security of application i guess.
HI Vimal thanks so much for your suggestion. I am sure you will love this. If you save this application in any type of a cloud folder such as Dropbox, OneDrive or Google Drive, each saved version is already stored on a server, protecting the data. That is probably the best and easiest solution since it does not require any additional programming.
I hope this helps and thanks so much.
Hi Randy, Thank you for this great video. I have learnt so much. I was following along but on the Sort Names macro, I get a compile error saying that the SkipSort function or sub is not defined. How would I correct the error? I also tried adding more data to my database and when I do that, it sorts all the data in that row including the header. I have typed in all the VBA code exactly as you have in the video. I would really appreciate some assistance. I am watching from South Africa.
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. 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.
@@ExcelForFreelancers I have done that and have been assisted on the forum. I appreciate it and am looking forward to learning even more from this page 😃😃
Greetings Randy thanks for the video.
Where can I get the icons?
HI Jaime, thanks for your comment. You can get free icons from the following sites:
icons8.com/iconizer/
adioma.com/icons
www.iconsdb.com/
Hi Randy, I was racking everything up to 12:11 when the 5,6,7,8,9 disappeared. What did you do?
Hi Brandon in each of those columns i put in a formula '=Column()'
This formula displayed the column # that it is in. (Just to show you the columns) then I highlighted those cells and clicked the Delete key as they were just used to show you what column #'s they were.
I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers do you build excel products for people to use. If so do you have any contact information that I explain what I am looking for and then tell me the cost to build it?
Hi Brandon, I am unable to take on any projects myself, however if you would like to write up a detailed scope and email it to me (Randy@ExcelForFreelancers.com)
I can then refer a qualified developer. I hope this helps and thanks so much.
What I like to do with sheet codenames is prefix them with 'ws'. This has 3 benefits, 1. it is visually apparent in your code that you are referencing a worksheet 2. when you type 'ws' intellisense shows only your sheets and 3. you are unlikely to have any other variables with that name.
Thanks very much for your suggestion Mr. Aitch. Much appreciated.
thnx sir u r the best excell trainer
For sure, you are very welcome Reza.
Is the completed School Manager available for purchase?
Hi Steve, thanks for your comment. I also received your email on the same. The School Manager application will be available for sale within a few months, fully completed, however the training part of it will be done next week.
Hello Randy, Thank you for video. I am having trouble with the conditional formatting for the Sel. Tab Col. When I click on the tabs, General Info etc. the number doesn't recognize the column number.
Hi Wendy, Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. Can you upload screenshots of your bug and sheet into our Excel For Freelancers Facebook Group here: bit.ly/groupexcel We have 50,000 Members who would love to help you with this. Thanks so much.
Hi, Randy. I'm enjoying your practicals.
But I'm stuck. I don't get the part where you are creating the color change based on conditional formatting. Please can you walk me through it.
Hi and thanks so much. If you use an adjacent cell value, you can apply conditional formatting based on that adjacent cell (Or you can use shapes, which is probably faster and better and uses less memory like in the sample i gave you in your other comment)
I need help I am trying to do the sort names in the StudentDB but it wont add my name to Sorted Names column in AA3. I have checked my code and it matches yours but will not transfer the names over to the AA column like in timestamp 1:50:59 of your video. Can I get any help with this?
Hi , Thanks for your comment. It would be difficult for us to help unless we see the specific bug you are running into. 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
How to have an "In-Cell" or PopUp Calender for a Date field ?
HI and thanks, I have that available for download and training here: ruclips.net/video/PLAJ08LP7kE/видео.html
I hope this helps and thanks so much.
Hi randy thank you for these videos, they are an excellent source of knowledge!
I do have one question
Do you suggest we continue using non named ranges for larger projects?
Example: on the horizontal tabs instead of having to write out which rows to un hide, would it be better (aka better “code” and “habits”) to name those ranges and use them as such?
I even noticed on some loops you like to count out columns rather than do some sort of .count, I wanted to see if there was some reasoning behind this
Hi Saul, thanks for your comment. I like using as many named ranges as possible. I like to see them in the code and in formulas. In my big Accounting application I have hundreds of them. I once heard that too many named ranges slows down an application but I have never scientifically tested this theory out.
So yes, adding named ranges in these instances will work very well. I hope this helps and thanks so much.
looking forward to the complete series
Thanks its going to be a long one but certainly a lot of fun and a lot of learning.
@@ExcelForFreelancers Is it possible for the application to include an instant picture and fingerprint capture during the initial general information capture for students and teachers database?
Hi and thanks Zainab, if you have a fingerprint reader you can then translate that into a unique ID. This ID can be stored with each student. I hope this helps and thanks so much.
Hi Randy, I was wondering if there was a way to add students doing copy paste from a old database, without adding a student at a time...
Hi yes and thanks, you can use my Data Import Manager training to do that (just search my channel)
I hope this helps and thanks so much Noemi (You can also just copy and paste the students from your database to the current application)
Thank you so much for the tutorial. This is very useful. I am referring to your video and try to build a simplified version on my own. However, I have encountered a issue when trying to create the button. When I click on the new student button, the 'existing student group' button doesn't appear. Wondering if it is linked to the codes that I might miss out during the process. Hope you can guide me on this. Thanks a lot.
Hi Sarah, thanks so much. You can check your 'Selection Pane' to see which pictures exists and which don't, or are not displayed. Sometimes groups or shapes do not appear because their width or height moves to 0.
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
Good work Rand
Thank you very much. So nice of you Esempa TV
So Great Mr.Randy wawoooooooooooooo
Thank you so very much, I really appreciate that Ahmed
Scheduling please ... with daily and weekly and monthly options..along with predecessors..
I have been trying out the hotel management app.. but not going anywhere.. hope this series could help..
Hope u could include that Randy.. please 🙏
Hi and thanks Avi, yes most certainly we will be doing Day, Week & Month Scheduling Views since that is really an important part of this application. Thank you for your Likes, Shares & Comments. It really helps.
Fantastic tutorial! How can we make Excel be side by side with another app like a browser. I would like to see most of the Excel? I know how to split screen but I need to scroll a bit.
HI and thanks very much. There are some ways you can add a browser in Excel and also run them side by side.
Perhaps you can add some screenshots and samples of what you are looking for 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 Randy. Could you please add possibility for multiple user to update data simultaneously?
Hi and thanks so much for your suggestion Jersey French. If i get enough requests for this feature I will be adding it in. Thank you for your Likes, Shares & Comments. It really helps.
@@ExcelForFreelancers Hi Sir Randy it will be a great addition for this kind of application
Good day,
Can you create a excel program. Adding data horizontal?
Hi and thanks. I will do my best. If you need to have a specific application made for you, 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 Randy! Thanks for the amazing training session. I don't know if I missed that part here, but is there a code in the sheet to check we have duplicate entries (like if we end up adding the same student info twice)?
Thanks again :)
Hi and thanks yes that is added later on in the series. I hope this helps and thanks so much.
Hi Sir do you have tutorial for making billing statement excel to pdf with dynamic tables? Thank very much!
Hi and thanks, I have one video that may help you called Conversion Manager here: ruclips.net/video/CRITdthMYlU/видео.html
I hope this helps and thanks so much.
Hi
I am from india
I watched all of your video, it's really Marvelous.
Please make gst billing software.
Hi and thanks so much. My next series will be an automated time tracking and billing with GST. Thanks again.
Students or parents can't login to the system?
Hi and thanks. Yes it is certainly possible with my Share & Sync training in which you can share and sync your macro-enabled workbook with anyone in the world here: ruclips.net/video/aKV5seZmiBs/видео.html
I hope this helps and thanks so much.
Thanks for the video, your videos are always amazing. Sir, can you pls create an application in excel were on can attach JPEG or PDF files, and also download them.
Hi and thanks so much. I have that already here: ruclips.net/video/lHT0u2zFBoQ/видео.html
Thank you for your Likes, Shares & Comments. It really helps.
column selection is not work on my system even after entry the new rule code=$B$5=column(). i didnt any responses can you help, i use hp probook 6470b ms excel2019.
HI and thanks, Your version of Excel and your laptop is just fine. It would be hard to know the problem unless we see pictures of your code and your sheet. Can you post your detailed 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. Thanks so much.
Teachers should be using this !!!
hello, My problem is: after assigning a macro to new student, as soon as I click on new student it displays: Run-time error '1004' We can't do that to a merged cell. and then in visual basic the range of: .Range("F3,F7,F9,H9,J9, etc has turned yellow. How to arrange ? please. This part 1:22:06
HI and thanks that means you are trying to clear the contents of a merged cell, however you have not identified the upper left and lower right cell addresses within VBA. So if Cell A1 is merged with B1 and you try to clear out only A1, it will return an error. You must use something like
Sheet1.Range("A1:B1").clearcontents
I hope this helps and thanks so much.
@@ExcelForFreelancers Okay, thanks, I'll give it a try.
Absolutely amazing
Thank you so very much, I really appreciate that Chumki
Randy Austin, thank you so much.
What I want to request you in the second tutorial is that when I click on update button and didn't make any changes in the Target cells I want to get message box "please make at least one change to update student" then if the user makes change, save that change. That's all teacher. I'm sure you can. And you will in the second party. Thanks again.
Thanks very much for your suggestion. I will try to get this added. Much appreciated.
yo bro, really thankya. Big respect
Glad it helped. Thank you very much, I really appreciate that Alon
Very cool and nice tutorial. Thanks for your help with the codes.
For sure, you are very welcome Atanu
Hi Sir, I want to start a school in my village and I want to buy the full school manager application to run it. Your thoughts will be appreciated 😊
Hi and thanks very much. You are welcome to download it for free using the link in the description and customize it yourself. I hope this helps and thanks so much.