Thank you Randy for your empowering tutorials. I have been following you for the past 5 years. please could you make a video of invoice and use VBA for the calculation instead of excel formula on the sheet? your help is required. Thanks you for your support
HI and thanks so much. Yes I could do that. I enjoy the Invoice trainings and they are popular. Can you let me know what advantages doing the calculations in VBA would benefit? This way I can understand and also share those benefits with my followers. I hope this helps and thanks so much.
Hi dear Randy and thank you very much on this lesson. I have suggestion ,can you go deep in VBA functions on some of new lessons. I mean can you explain us and differentiaet how to use and make proper functions in VBA. It would be great lesson. Thank you very much on your efforts...
For sure, you are very welcome and I am happy to help. Please feel free to follow my Beginners VBA Series here: ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z I hope this helps and thanks so much.
You will want to make sure that customers have unique names, otherwise you won't know which customer you are selecting. I hope this helps and thanks so much.
@@ExcelForFreelancers Oh no. In real life there are a lot of customers with the same name. My selected key will be the unique customer id. Your file is an excellent base for me to upgrade and make some extensions. Thank you.
For sure, you are very welcome. Yes for sure, each customer has a unique key. Another idea is to take that unique key and combine it with the customer name. This may be helpful as well when selecting customers from a drop down list. Thank you for your Likes, Shares & Comments. It really helps.
Hi, I have an Excel workbook with multiple worksheets. On worksheet One, I want to add buttons to click that will take me to the other worksheets. How can I do that? Thanks
Create shapes and put the name of worksheets in them and then use hyperlink option by right- clicking the shape. there you can select the worksheet where you want to go. Hope that helps.
Hi Randy, thanks for all your Training Tuesdays and VBA Sundays. I have an idea for the Simple Invoice . Adding An automated Email Button that will send an PDF Invoice to the customer and also adding a copy of the invoice to a file on your desktop. This is then an easy way to have access to all Invoice records from your desktop. Cheers Glen.
Perfect Idea. I will certainly be adding this for Patreon and RUclips members on Monday. Thanks so much Glen, I really appreciate your continued support.
Hi and thanks so much. Please feel free to check out my Maintenance Manager training here: ruclips.net/video/5hNvxqVNJOY/видео.html I hope this helps and thanks so much.
hi sir...have been learning thru ur videos recently... very helpful.. sir, whatever files u create in excel, can those b converted into a software with minimal effort?? or do u have to do the entire coding in vba to run it like a software.. i m on a project to create a labourer management software with no knowledge on vba... pls guide me
Hi and thanks so much. You will want to keep it all in Excel. Excel is already on millions of machines so it is a perfect platform, so it is already a software and does not need to be 'converted' Also for Labor Management please check out my Hourly Cost Calculator here: ruclips.net/video/_lXdv_1effQ/видео.html I hope this helps and thanks so much.
Hi and thanks so much for your comment. It may be possible depending upon if they have an integrated API. You will have to check with the platform for this. I hope this helps and thanks so much.
Hi and thanks for your comment. Can you let me know which specific links you are having issue with so that I can follow up with them. Feel free to email us here as well shane@ExcelForFreelancers.com I hope this helps and thanks so much.
actually have been designing my excel pages from ur tutorials.. have just started the project...so wanted to know as earlier as possible that even designing userforms and databases in excel can help me create a software application?? if yes, i will continue to design and create using excel n vba.. if not then i will have to learn VBA in details.. quiet difficult task for me.. pls help. me sir
Hi and thanks. Yes for sure. In fact I have some tutorials that focus only on userforms. Feel free to search my channel for "Userform" Thank you for your Likes, Shares & Comments. It really helps.
HI and thanks Peter. Yes for sure it will have automated Invoice #'s and I will be creating it from scratch in the video. I hope this helps and thanks so much.
@@PurpleFurbyif you mean like payments applied to the invoice and such. No, this is just an invoice record. I think he has done other apps that have everything but a lot of these apps require a lot of planning and what kind of functionalities are needed. I decided to go to quickbooks to track my expenses and expenses applied to purchasing supplies and how it gets charged to customers. So I have investment accounts (COGS) that will eventually decrease with the sales of each part. This way you can see if you're profitable. Don't forget to pay yourself as well with labor or your employees so quickbooks can be very useful if used correctly. I currently do it manually and I can see all my financial activities this way. Sometimes my banking statement says something that is not true. My assets are depreciated and I can see that as well.
Hi , Thanks for your comment. You will want to make sure there are at least 2 records when sorting. If there are less than 2 rows you can add If LastRow < 4 then Exit Sub (or something like that) 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
Thanks man, you are great. But sorting after deleting didn't work. I've done exactly what you've said. Even I've copied the source from the original file, but no use. Thanks again.
Hi and thanks for your comment. When it comes to the deleting Macro, you may want to use F8 to step through the code. Also you will want to make sure you are sorting records with at least 2 rows of data. Please also check the range and key to ensure accuracy, 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/XmasSale2024_YTPinnedComm
You are not just doing the right thing by providing free training and study material, you are changing lives.
Thanks mate!
Thank you so very much, I really appreciate that and so happy that I can make a difference. Thanks again
Randy, you are THE BEST for VBA!!! Thanks!!!
Thank you so very much, I really appreciate that Chris
⚡ 𝗦𝗜𝗠𝗣𝗟𝗜𝗙𝗬 𝗖𝗢𝗠𝗣𝗟𝗘𝗫 𝗘𝗫𝗖𝗘𝗟 𝗧𝗔𝗦𝗞𝗦 𝗜𝗡𝗦𝗧𝗔𝗡𝗧𝗟𝗬 𝗪𝗜𝗧𝗛 𝗘𝗫𝗖𝗘𝗟 𝗔𝗜 𝗧𝗢𝗢𝗟𝗣𝗔𝗖𝗞 𝗔𝗗𝗗-𝗜𝗡 👉 www.excelforfreelancers.com/ai-toolpack
Very professional looking invoice !
Thank you so very much, I really appreciate that
Thank you!
For sure, you are very welcome. Thank you for your Likes, Shares & Comments. It really helps.
Thank you Randy for your empowering tutorials. I have been following you for the past 5 years. please could you make a video of invoice and use VBA for the calculation instead of excel formula on the sheet? your help is required.
Thanks you for your support
HI and thanks so much. Yes I could do that. I enjoy the Invoice trainings and they are popular. Can you let me know what advantages doing the calculations in VBA would benefit? This way I can understand and also share those benefits with my followers. I hope this helps and thanks so much.
Thank you so much Randy.
For sure, you are very welcome Syed and thanks for your continued support.
Hi dear Randy and thank you very much on this lesson.
I have suggestion ,can you go deep in VBA functions on some of new lessons.
I mean can you explain us and differentiaet how to use and make proper functions in VBA. It would be great lesson. Thank you very much on your efforts...
Hi and thanks Petar. For sure I can do that and also feel free to check out some of my older videos from scratch as well. t yl
Im amazing following your videos... I'm beginner in excel VBA, so I shall need too much your help
For sure, you are very welcome and I am happy to help. Please feel free to follow my Beginners VBA Series here: ruclips.net/p/PLIBeRriXvKzDTzNp5IME4-oXXCrIjvV4z
I hope this helps and thanks so much.
You are great. But how do i fix it for customers with the same name but different adresses?
You will want to make sure that customers have unique names, otherwise you won't know which customer you are selecting. I hope this helps and thanks so much.
@@ExcelForFreelancers Oh no. In real life there are a lot of customers with the same name. My selected key will be the unique customer id. Your file is an excellent base for me to upgrade and make some extensions. Thank you.
For sure, you are very welcome. Yes for sure, each customer has a unique key. Another idea is to take that unique key and combine it with the customer name. This may be helpful as well when selecting customers from a drop down list. Thank you for your Likes, Shares & Comments. It really helps.
Hi,
I have an Excel workbook with multiple worksheets. On worksheet One, I want to add buttons to click that will take me to the other worksheets.
How can I do that?
Thanks
Create shapes and put the name of worksheets in them and then use hyperlink option by right- clicking the shape. there you can select the worksheet where you want to go. Hope that helps.
Thanks.
Hi and thanks @amjadhasan7278 had the correct answer with hyperlinks to the sheets.
Thank you for your Likes, Shares & Comments. It really helps.
Hi Randy, thanks for all your Training Tuesdays and VBA Sundays. I have an idea for the Simple Invoice . Adding An automated Email Button that will send an PDF Invoice to the customer and also adding a copy of the invoice to a file on your desktop. This is then an easy way to have access to all Invoice records from your desktop. Cheers Glen.
Perfect Idea. I will certainly be adding this for Patreon and RUclips members on Monday. Thanks so much Glen, I really appreciate your continued support.
Hi Sir How are you, Your work is next level. I want to work on a project for my maintenance company 🤔
Hi and thanks so much. Please feel free to check out my Maintenance Manager training here: ruclips.net/video/5hNvxqVNJOY/видео.html
I hope this helps and thanks so much.
hi sir...have been learning thru ur videos recently... very helpful.. sir, whatever files u create in excel, can those b converted into a software with minimal effort?? or do u have to do the entire coding in vba to run it like a software.. i m on a project to create a labourer management software with no knowledge on vba... pls guide me
Hi and thanks so much. You will want to keep it all in Excel. Excel is already on millions of machines so it is a perfect platform, so it is already a software and does not need to be 'converted'
Also for Labor Management please check out my Hourly Cost Calculator here: ruclips.net/video/_lXdv_1effQ/видео.html
I hope this helps and thanks so much.
Amazing, hope the complex invoice coming where vba is there, thankx
HI and thanks. I will be doing all the design and writing all of the code during the tutorial. I am sure you will love it.
Thanks so much
@@ExcelForFreelancers thank u
Cant wait!!!!
Thank you so very much, I really appreciate that. This one is completely from scratch, so I think you will enjoy it.
Is it possible to make those invoices compatible for e-invoicing with Peppol (official e-invoicing platform)?
Hi and thanks so much for your comment. It may be possible depending upon if they have an integrated API. You will have to check with the platform for this. I hope this helps and thanks so much.
I hope it's will be connected with stock
Hi and thanks so much. You can use this for Inventory and stock control as well. I hope this helps and thanks so much.
Hello randy, many download links may be broken, Could you please review and fix those? Thanks!
Hi and thanks for your comment. Can you let me know which specific links you are having issue with so that I can follow up with them. Feel free to email us here as well shane@ExcelForFreelancers.com
I hope this helps and thanks so much.
actually have been designing my excel pages from ur tutorials.. have just started the project...so wanted to know as earlier as possible that even designing userforms and databases in excel can help me create a software application?? if yes, i will continue to design and create using excel n vba.. if not then i will have to learn VBA in details.. quiet difficult task for me.. pls help. me sir
Hi and thanks. Yes for sure. In fact I have some tutorials that focus only on userforms. Feel free to search my channel for "Userform"
Thank you for your Likes, Shares & Comments. It really helps.
will it have automated inv #
HI and thanks Peter. Yes for sure it will have automated Invoice #'s and I will be creating it from scratch in the video. I hope this helps and thanks so much.
Will it have history of invoices?
@@PurpleFurbyif you mean like payments applied to the invoice and such. No, this is just an invoice record. I think he has done other apps that have everything but a lot of these apps require a lot of planning and what kind of functionalities are needed. I decided to go to quickbooks to track my expenses and expenses applied to purchasing supplies and how it gets charged to customers. So I have investment accounts (COGS) that will eventually decrease with the sales of each part. This way you can see if you're profitable. Don't forget to pay yourself as well with labor or your employees so quickbooks can be very useful if used correctly. I currently do it manually and I can see all my financial activities this way. Sometimes my banking statement says something that is not true. My assets are depreciated and I can see that as well.
Sir, there is an error in sorting, after delete the record, the data is not sorting in Invoice Item sheet, please explain how to sort the data .
Hi , Thanks for your comment. You will want to make sure there are at least 2 records when sorting. If there are less than 2 rows you can add
If LastRow < 4 then Exit Sub
(or something like that)
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
Thanks man, you are great. But sorting after deleting didn't work. I've done exactly what you've said. Even I've copied the source from the original file, but no use. Thanks again.
Hi and thanks for your comment. When it comes to the deleting Macro, you may want to use F8 to step through the code. Also you will want to make sure you are sorting records with at least 2 rows of data. Please also check the range and key to ensure accuracy,
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
Sir, listview doesn't work in Microsoft office 2016... please I need help 🙏
Hi and thanks so much. Please make sure you are using a PC and not a Mac and it will work just fine. I hope this helps and thanks so much.