Randy this is by far one of the most expensive tutorial that you have just offered for free here on this platform. I am so thankful to have undergone your Mentorship programe. I cannot thank you enough for what you have done for me and my entire family through these free trainings and most importantly the Mentorship programe. May God continue blessing you abundantly and Happy New Year to you! This is Davie from Malawi, Africa.
Thank you so very much, I really appreciate that and thank you for the kind comments. I am so glad that I can help share and support you every step of the way. Thank you for your Likes, Shares & Comments. It really helps.
Mostly you makes me wonder if you are part of Microsoft Excel introduction, you brings out solutions, templates, work scenarios that is mind blowing with Microsoft Excel...like seriously...is it Excel you use to do this😊🤩, @Randy you are super amazing with Excel, is an honour👍👏
Thank you so very much, I really appreciate that Richard. I will tell you a secret. I had never used Tree View control, but it was suggested to me from one of my followers. So i had to learn it on a Monday, then record and teach it on a Tuesday. LOL. So i just tried to think what would be an interesting scenario to use this on. The video seemed popular so I am sure I will use it again in the near future. Thank you for your Likes, Shares & Comments. It really helps.
Thank you so much Nathaniel & Richard. I don't think I am smarter than anyone else however i have a 'no quit' attitude and I will try new things UNTIL I figure it out. Bringing these tools and ideas to the world, and getting feedback like yours, is all the motivation I need in the world.
Hi, and thanks for your comment Paul. I do have several videos on Userforms and I plan to create a POS application with a userform coming up in the next few weeks which uses the ListView control so i am sure you will love it. Thanks so much for your continued support.
Randy, how would you go about if you had your data constructed more like a database, meaning you would have a separate table for the parents (customers) and then a table for work orders with the ID of the parent and finally a table for invoices where you have invoice ID, work order ID, and parent ID?
Hi and thanks very much for your comment. The Unique ID would be part of the Main node, you would then run and advanced filter based on this. In the Patreon update, i will include an option to show Order Items (work order items, Invoice Items, Purchase Items) which are stored on a different database, so I will be showing this, however I think its going to slow things down, but I want to try it as an option anyways. (Check out the update on Patreon next Monday for this) Thanks again
Randy, thank you for this. I've learned a lot. Can I ask, with this week's study, I want to use this with the invoice layout from the construction management with the individual tab switches and company cost for producr and it being detailed onto the final hard copy (exact as is there). How can I change this invoice layout to that? Also, I want to add a vehicle management with a vin decorder/lookup. I have customers with multiple vehicles that I'd like to keep track of, see if we have done maintenance on them in past and all. Lastly, sometimes customers have their own reference and or PO number they would wish to be included on the invoice. Is there a way to add a quick intake to make personal notes onto the invoices? I been trying to extend the header box with the customer information to include all this into that box but am having trouble with the VBA code. Thank you as always! I am enjoying playing around with the 300 package!
Hi and thanks so much and I am glad you enjoyed the training. The requirements you have requested need code, modifications, formulas and design and would not be something i can answer in a TH-cam video. Based on the training I have provided, please give it a try and if you run into any issues, please post the issue 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.
Hello Randy, do you know how can we show the data comparison in Userform in best way? Like comparing todays counts with yesterday's count for different different products. Any way to represent that in treeview?
Hi and thanks very much. It depends on the data type you want to compare. This may be much more natural in a sheet since you have tables and rows that naturally help with comparisons however you can try side by side lists boxes or you can combine the data into a single list box. 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
Randy, this is brilliant, as usual. I do have one concern. Does the treeview object "travel" with the app? I mean asking inexperienced user to find it and add it seems like a stretch... The reason I ask is because on MY computer (with Excel 2010 under Win10 32bit) the file does not work and this error pops up: "could not load an object because it is not available on this machine" and excel crash. There is also an error 800a9cf1 when trying to add the control. Just thought it is important to mention
Hi and thanks so much. If you don't have the correct reference libraries loaded, it might cause an issue, however within the video I did not add any additional reference libraries than the standard. You can open up the file, without macros running, to check any missing reference libraries. This file opened up on my laptop without issues, however it is worth exploring. Thank you for your Likes, Shares & Comments. It really helps.
Dear Respected Sir, is there end of your extrabrilliance... ? It's crasy...! It's crazy to see this work and crazy to know where it will finish. Please, could i apply this on my own project. ? Not to be sold... I swear. It's only to learn and to learn more and more... Wow
Hi and thanks so much for your feedback and I am so glad you enjoyed the training. Yes, you are welcome to download this and use it for your personal projects. I hope this helps and thanks so much.
I like 😻 your tutorials... My request is to create a new year resolution template and that has some tracking features for auto updates... You don't need much more explanation because you are an expert you may get some more ideas what features will include so I'm expecting it will... Once again Thank you for your awesome tutorial..
Hi and thanks for your comment. If you would like some help with this, 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 thanks so much. You can check out my Construction Estimator here: th-cam.com/video/3XU06Eg0PAg/w-d-xo.html I hope this helps and thanks so much.
Hi and thanks it may be possible however Mac for Excel is a struggle because it does not use ActiveX controls so it might be very frustrating. I hope this helps and thanks so much.
an estimate and invoice for insurance restoration would be sweet like an Xactimate format I am switching over to Excel and your templates for our CRM I'm new to excel and doing my best to learn as fast as possible but umm ya its excel...I literally was getting something notarized the other day and I swear on everything I wrote =today() in the date box...the document was in excel format... I just started laughing
haha that is funny and I am so glad you enjoy these training. I also have a dedicated Ultimate CRM here: th-cam.com/video/ITLmYf-FtLo/w-d-xo.html I hope this helps and thanks so much.
@ExcelForFreelancers much appreciated my man 💪 never thought I would be learning excel and loving this new language so much, I will definitely have to contribute to your efforts, hardwork, and generosity with the workbooks..thanks again!
![How To Create A Point Of Sale (POS) Application In An Excel Userform [Training & Free Download]](http://i.ytimg.com/vi/9biCBLwEngM/mqdefault.jpg)
![How To Create A Point Of Sale (POS) Application In An Excel Userform [Training & Free Download]](/img/tr.png)
![[LIVE] : ONE ลุมพินี 91 | คู่เอก "คมอาวุธ vs อเล็กเซย์"](http://i.ytimg.com/vi/V0RkEfYFsgM/mqdefault.jpg)
![ILLSLICK X YOUNGOHM - We're The same [Official Video]](http://i.ytimg.com/vi/yUJNkobYR0E/mqdefault.jpg)
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Randy, there is no end to your brilliance, everytime you just do things that is mind blowing in excel. Thank you so so so so much.
Thank you so much. I really appreciate your continued years of personal.
Randy this is by far one of the most expensive tutorial that you have just offered for free here on this platform. I am so thankful to have undergone your Mentorship programe. I cannot thank you enough for what you have done for me and my entire family through these free trainings and most importantly the Mentorship programe. May God continue blessing you abundantly and Happy New Year to you! This is Davie from Malawi, Africa.
Thank you so very much, I really appreciate that and thank you for the kind comments. I am so glad that I can help share and support you every step of the way. Thank you for your Likes, Shares & Comments. It really helps.
Mostly you makes me wonder if you are part of Microsoft Excel introduction, you brings out solutions, templates, work scenarios that is mind blowing with Microsoft Excel...like seriously...is it Excel you use to do this😊🤩, @Randy you are super amazing with Excel, is an honour👍👏
Thank you so very much, I really appreciate that Richard. I will tell you a secret. I had never used Tree View control, but it was suggested to me from one of my followers. So i had to learn it on a Monday, then record and teach it on a Tuesday. LOL.
So i just tried to think what would be an interesting scenario to use this on. The video seemed popular so I am sure I will use it again in the near future.
Thank you for your Likes, Shares & Comments. It really helps.
I'm always surprised... Where and how were you able to learn all these???
We deeply love and appreciate you, Randy. You're a gift to us
Thank you so much Nathaniel & Richard. I don't think I am smarter than anyone else however i have a 'no quit' attitude and I will try new things UNTIL I figure it out. Bringing these tools and ideas to the world, and getting feedback like yours, is all the motivation I need in the world.
Randy is just brilliant. Keep it up.
Thanks so much, so kind of you
You are doing excellent work. Best channel in TH-cam.
Thank you so very much, I really appreciate that Ibrahim. Much appreciated
Thank you Randy ... This is brilliant training. You surprise us all with your unique ideas for these trainings.🎉
Thank you so very much, I really appreciate that Neren along with your many years of support.
It is really fantastic, Sir Randy. Waiting for that!
Thank you so very much, I really appreciate that
Awesome Training Randy, I Really Like Working With Forms. Maybe You Could Do Something With The ListView Control In The Future?
Hi, and thanks for your comment Paul. I do have several videos on Userforms and I plan to create a POS application with a userform coming up in the next few weeks which uses the ListView control so i am sure you will love it. Thanks so much for your continued support.
That is awesome. Thank you so much Randy for this amazing video.
For sure, you are very welcome Syed. This one was a bit different and glad you enjoyed it.
Randy, how would you go about if you had your data constructed more like a database, meaning you would have a separate table for the parents (customers) and then a table for work orders with the ID of the parent and finally a table for invoices where you have invoice ID, work order ID, and parent ID?
Hi and thanks very much for your comment. The Unique ID would be part of the Main node, you would then run and advanced filter based on this. In the Patreon update, i will include an option to show Order Items (work order items, Invoice Items, Purchase Items) which are stored on a different database, so I will be showing this, however I think its going to slow things down, but I want to try it as an option anyways. (Check out the update on Patreon next Monday for this)
Thanks again
Hi Randy you are really bless for human.
Thank you so very much, I really appreciate that. Very kind of you. Thank you for your Likes, Shares & Comments. It really helps.
Randy, thank you for this. I've learned a lot. Can I ask, with this week's study, I want to use this with the invoice layout from the construction management with the individual tab switches and company cost for producr and it being detailed onto the final hard copy (exact as is there). How can I change this invoice layout to that? Also, I want to add a vehicle management with a vin decorder/lookup. I have customers with multiple vehicles that I'd like to keep track of, see if we have done maintenance on them in past and all. Lastly, sometimes customers have their own reference and or PO number they would wish to be included on the invoice. Is there a way to add a quick intake to make personal notes onto the invoices? I been trying to extend the header box with the customer information to include all this into that box but am having trouble with the VBA code. Thank you as always! I am enjoying playing around with the 300 package!
hmmm
Hi and thanks so much and I am glad you enjoyed the training. The requirements you have requested need code, modifications, formulas and design and would not be something i can answer in a TH-cam video. Based on the training I have provided, please give it a try and if you run into any issues, please post the issue 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.
Hello Randy, do you know how can we show the data comparison in Userform in best way? Like comparing todays counts with yesterday's count for different different products. Any way to represent that in treeview?
Hi and thanks very much. It depends on the data type you want to compare. This may be much more natural in a sheet since you have tables and rows that naturally help with comparisons however you can try side by side lists boxes or you can combine the data into a single list box.
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
Custmize ribbon में आपने ultimate ERP का tab कैसे बनाया है इस topic पे video step by step बनाएगा sirji।
HI and thanks very much. I have a training on that here: th-cam.com/video/WM8Smy-FpEc/w-d-xo.html
Creating Fault Tree Analysis (FTA) - sir please one template making
Thank you so very much, I really appreciate that and will try to make that in the near future
Randy, this is brilliant, as usual. I do have one concern. Does the treeview object "travel" with the app? I mean asking inexperienced user to find it and add it seems like a stretch...
The reason I ask is because on MY computer (with Excel 2010 under Win10 32bit) the file does not work and this error pops up: "could not load an object because it is not available on this machine" and excel crash. There is also an error 800a9cf1 when trying to add the control. Just thought it is important to mention
Hi and thanks so much. If you don't have the correct reference libraries loaded, it might cause an issue, however within the video I did not add any additional reference libraries than the standard. You can open up the file, without macros running, to check any missing reference libraries. This file opened up on my laptop without issues, however it is worth exploring. Thank you for your Likes, Shares & Comments. It really helps.
Merry Christmas to you and your family sir❤
Merry Christmas and thanks so much. I am glad you enjoyed the training.
Thanks so much. I really appreciate that
This looks old school even with the boxes.
Yes for sure. thanks so much Joe.
Dear Respected Sir, is there end of your extrabrilliance... ? It's crasy...! It's crazy to see this work and crazy to know where it will finish.
Please, could i apply this on my own project. ? Not to be sold... I swear. It's only to learn and to learn more and more... Wow
Hi and thanks so much for your feedback and I am so glad you enjoyed the training. Yes, you are welcome to download this and use it for your personal projects. I hope this helps and thanks so much.
@@ExcelForFreelancers
One billion ore more than one billion of thanks. Tomorrow, i will show my strength to my colleagues ,💪🥰
Nice! @@SM-tz1hc
I like 😻 your tutorials... My request is to create a new year resolution template and that has some tracking features for auto updates... You don't need much more explanation because you are an expert you may get some more ideas what features will include so I'm expecting it will... Once again Thank you for your awesome tutorial..
Thank you so very much for the nice suggestion. I have written it down and will certainly consider it for a training. Thanks so much
Hi sir, can you make a Trading Journal
Hi and thanks for your comment. If you would like some help with this, 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.
Parece increíble que aplicaciones de este tipo se puedan hacer en Excel. Pero usted maestro, todo lo hace posible.
Thank you so very much, I really appreciate that :) :)
Hey did you have concrete Excel?
Hi and thanks so much. You can check out my Construction Estimator here: th-cam.com/video/3XU06Eg0PAg/w-d-xo.html
I hope this helps and thanks so much.
@@ExcelForFreelancers thank you.
Can I do this on excel for Mac?
Hi and thanks it may be possible however Mac for Excel is a struggle because it does not use ActiveX controls so it might be very frustrating.
I hope this helps and thanks so much.
Oh sure, keep in the ambiguity error, but through the power of video editing leave out the Variable Not Defined error for OrdIID. 😁
Thanks for the tip, I will try to share these issues I come across them. Thank you for your Likes, Shares & Comments. It really helps.
you are the best thanks❤
Thank you so very much, I really appreciate that. Thank you for your Likes, Shares & Comments. It really helps.
an estimate and invoice for insurance restoration would be sweet like an Xactimate format I am switching over to Excel and your templates for our CRM I'm new to excel and doing my best to learn as fast as possible but umm ya its excel...I literally was getting something notarized the other day and I swear on everything I wrote =today() in the date box...the document was in excel format... I just started laughing
haha that is funny and I am so glad you enjoy these training. I also have a dedicated Ultimate CRM here: th-cam.com/video/ITLmYf-FtLo/w-d-xo.html
I hope this helps and thanks so much.
@ExcelForFreelancers much appreciated my man 💪 never thought I would be learning excel and loving this new language so much, I will definitely have to contribute to your efforts, hardwork, and generosity with the workbooks..thanks again!
Thank you so very much, I really appreciate that