Thank you for this gem. I always wonder why don't you use a table to manage your database? I love your content and you inspire me to be more professional on excel 😁
Hi and thanks so much. I do use tables for most of my Dashboard training videos, however, for any other type, I find tables very constricting. They have automation, names, and rules that I don't like very much. Using ranges, i have the ultimate freedom. When it comes to creating dashboards, tables are essential for pivot tables and quick charts and graphs. I hope this helps and thanks so much.
Hello Randy and thank you for your fantastic work. I'm not a "complete newbie" but when I try to increase the decimal places to 4, at the invoice it's possible, but then when I Load the invoice only appears 2 decimals, and that affects the value of the invoice. For sure it's my mistake. but I was checking all macros, name ranges and conditional formattings and I could not get to a solution. Thank you once again for sharing all your expertise. Kinde regards
Hi and thanks very much. In the cell format you can change the # of decimals. I have also responded to your email with the same concern with a screenshot as well. I hope this helps and thanks so much.
Hi Randy thanks very much for your excellent training. Would it be possible to add a schedule for service to complete each invoice? I see this can be useful for a service or repair company.
HI and thanks, I do have a Field service training here: ruclips.net/video/Wlcr5AvDS5k/видео.html Also feel free to check out any one of my scheduling trainings and templates here: I hope this helps and thanks so much.
Hey thank you very much and i really learned a lot from you u are the king of Excel . Please can teach us how to make an Phone App to enter Data to the excel sheet becuase sometimes it feel lazy to open the laptop and enter the Data so can you please try to do this idea its like Enter form in exel but you can do it from Phone
Hi and thanks very much. I have done that in a video training here: ruclips.net/video/YayS7NP_xgY/видео.html and here: ruclips.net/video/WRIBkgF61rc/видео.html I hope this helps and thanks so much.
Hey thanks, unfortunately I'm not a patreon so I followed everything from the video and added some features to it like conditional formatting for the invoice list based on the date so that I can see quickly overdue invoices, PO number, wrote my version of the pdf save (makes a pdf per page then invoke pdftk server to merge them and then delete the temporary pdf), last save date code and last export/print code to compare version and authentication, a button to pull up a userform to add items in the item list sheet amd finally a note field that is on top of the invoice. Next feature I want to add is print/save as pdf a summary invoice from date to date.
Hi and thanks. It looks like you are doing well and making good progress. If you run into any issues or need help, please feel free to post your question 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.
@@ExcelForFreelancers I already am on the group, it helps that I've done some VBA for corel draw before but the videos are great and there's a lot from other tutorials that can be combined to build up the thing.
Wow, Thank you Randy, just what I have been looking for. My Question is how can I set it up that if I type in an item that it automatically fills everything in and if the item doesn't exsist that I can automatically add the new item to my item sheet.
Hi and thanks, that is a nice suggestion and idea. I will add it on as a feature for the update next Monday on our Patreon platform here. Would love to have you join: www.patreon.com/ExcelForFreelancers
Thanks very much. I recorded the video yesterday, and I included your solution and mentioned your RUclips name inside the video. It will be uploaded on Patreon this Monday. Thanks again for the great suggestion
Hi and thanks, this feature is now available on our Patreon Platform for the Updated Dynamic Invoice Designer. You can find your idea completed here: www.patreon.com/ExcelForFreelancers I hope this helps and thanks so much for the nice idea
I will record the 'Restaurant & Cafe Manager' tomorrow and it will be released on January 31st. I am sure you are going to love it. Thanks for the great request.
Hi Randy thanks very much for your video, just a quick question how do I change the currency from Dollars to Euros? In both list and totals on the invoice. Thank you so much.
Hi Kash, yes sure you can. You would want to clear all of the Invoice data and then update your 'Next Invoice ID' formula to =IFERROR(Max(Inv_ID)+1,50) I hope this helps and thanks so much.
Hi randy....nice video.....just a question, can a userform open a file saved in onedrive, update the inside, then clise and save the file? File in onedrive act as a database
Hi and thanks for your comment. Yes it could, but it would be extremely slow. You are better off using text files to sync Excel workbooks. I teach you how to do that in this video: To share and sync your macro-enabled Excel workbook, please watch this training: ruclips.net/video/aKV5seZmiBs/видео.html I hope this helps and thanks so much.
Hi yes certainly, Any USB scanner will act as a keyboard interface so it should work well without too many needed customizations If you need help with this, 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
You can guide me to be a cafe manager, use the shape to draw a table (the number of tables I customize) when I choose a certain table it will show a drink for me to choose (then put all the information to order drinks in 1 board) when the table has selected the dish will be colored differently from the table that has not ordered and has a payment button. After payment, the table will return to its original color. one button can edit previously ordered table, one button to print receipt.
Hi and thanks so much. I do not have it, however I really like the idea, so give me a few weeks and I will try to create it for you in a new RUclips training. Thank you for your Likes, Shares & Comments. It really helps.
Hi Scott. Thanks so much 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 Charlene, This workbook will work with any version of Excel. If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Hi and thanks, yes for sure its possible. You can see my Point Of Sale videos on how to display images, similar to Invoices, here: ruclips.net/p/PLIBeRriXvKzBohiJA68HSrtetepIR4Nna I hope this helps and thanks so much.
Hello Randy, Great job on this video. I have a question, i keep getting this error message The item with the specified name wasn't found on the Worksheet_SelectionChange sub Highlighting Set Cal = Shapes ("Calendar "). I am using the pop up Calendar which i installed properly And from the video tutorials there is a macro link on the PopUpCal macros that enables the Calendar to show on the Invoice sheet. So what seems to be the problem cause i understand that the Calendar shape is on the CalPopUp sheet and not on the invoice sheet. I would really love your response on this error as it is the only error keeping the invoice designer from running. Thank you in advance. Cheers
HI and thanks so much. You can just copy the calendar from the pop-up sheet, into the Invoice sheet and that should solve the issue. It may have been deleted from the Invoice sheet. 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
Can I make it link to my WordPress wocommerce shop product list? That would be nice if it could since WordPress invoice and quotation form was horrible.
Hi and thanks for your comment. Yes you can. I show you how to do that in this video: ruclips.net/video/egzNg7AL7uY/видео.html I hope this helps and thanks so much.
Can you make inventory management with Invoice will be better to update all in one save, update invoices vendor Vendor outstanding and customer payment and edit all in one 😊
HI and thanks very much. Yes i have done that already with my 'Ultimate ERP' template and training here: ruclips.net/video/HE-g2BAC5Ks/видео.html I hope this helps and thanks so much.
Loving your content the moment I came across your channel. I was looking for something in line with credit and savings kind of content, it's for a cooperative. I would love to see content created on that☺
Hi Sandra, thanks so much. I have a few that might help or be customized such as my 'Mini-Accounting training and template here ruclips.net/video/itHilzsUHck/видео.html or personal monthly budget here: ruclips.net/video/gIOj_6mIAR0/видео.html If you are looking for a more customized solution, feel free to email me (Randy@ExcelForFreelancers.com ) I can refer a qualified developer. I hope this helps and thanks so much.
Good day. How can I use this template as a quotation system, but also automatically add a Terms & Conditions Page when printing the quotation to pdf. Is there somebody that can help me with it and what will it cost.
HI Francois, thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com Thanks so much.
HI and thanks so much. You can browse for your own logo when adding a picture to the sheet and remove the old one. I hope this helps and thanks so much.
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.
![Learn How To Create This Amazing Excel Invoice While I Build It From Scratch [Full Training]](http://i.ytimg.com/vi/99xVbVMABJ0/mqdefault.jpg)
📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
WOW Randy ... One click, One Click, One click, this is a super awesome Multi page Invoice ... thank you
Thank you so very much, I really appreciate that Neren. I thought you would enjoy this one
Design of an invoice shows the professionalism of your company…use good colorful paper too.
Thank you so very much, I really appreciate that
Very Very Useful Lesson Sir.
Thank you so very much, I really appreciate that.
Hi Randy, another wonderful project to open this new year
Thank you so very much, I really appreciate that Temyra. Thank you for your Likes, Shares & Comments. It really helps.
Thank you for this gem. I always wonder why don't you use a table to manage your database?
I love your content and you inspire me to be more professional on excel 😁
Hi and thanks so much. I do use tables for most of my Dashboard training videos, however, for any other type, I find tables very constricting. They have automation, names, and rules that I don't like very much. Using ranges, i have the ultimate freedom. When it comes to creating dashboards, tables are essential for pivot tables and quick charts and graphs. I hope this helps and thanks so much.
@@ExcelForFreelancers It does, help thank you a lot 😁
Thanks Randy for this wholesome awesome share. Stay blessed.
For sure, you are very welcome Syed, and thanks so much
wow...thanks Randy...this is very amazing...
You are very welcome and I am happy to help Ayahe
Its amazing on day to day uses..... Thank you Randy
For sure, you are very welcome and glad you enjoyed the training
God bless you my deary brother. Your training is excellent
Thank you so very much, I really appreciate that. Thank you for your Likes, Shares & Comments. It really helps.
Excellent Randy. Looking forward to seeing your training
Thank you so very much, I really appreciate that Ashok :)
all video's very useful . you help me a lot thanks
Glad to hear thata nd thanks so much Osama :)
Your works are very interesting. . and It helps me more..
Thank you so very much, I really appreciate that
That's going to be really nice and interesting. I'm Waiting for and I Wish you an Happy New Year Mr RANDY.
Thank you so very much, I really appreciate that Sebastien, Happy New Year to you as well
Excellent, great work, I need it
Thanks so much. Glad you like it
waiting for the love
Thank you so very much, I really appreciate that
Thank you Randy for such amaizing tutorial! What would be the best solution to add a "Sold qty" column in Items worksheet? Thank you!
Hi and thanks the Qty column is the same so you would just have to update the text in the cell. I hope this helps and thanks so much.
Hello Randy and thank you for your fantastic work. I'm not a "complete newbie" but when I try to increase the decimal places to 4, at the invoice it's possible, but then when I Load the invoice only appears 2 decimals, and that affects the value of the invoice. For sure it's my mistake. but I was checking all macros, name ranges and conditional formattings and I could not get to a solution. Thank you once again for sharing all your expertise. Kinde regards
Hi and thanks very much. In the cell format you can change the # of decimals. I have also responded to your email with the same concern with a screenshot as well.
I hope this helps and thanks so much.
Incredible, seems very interesting. Waiting for the launch.
Thank you so very much, I really appreciate that. I know you will love this one.
@@ExcelForFreelancers thank you mister. Happy new year
Happy New Year to you too
Hi Randy thanks very much for your excellent training. Would it be possible to add a schedule for service to complete each invoice? I see this can be useful for a service or repair company.
HI and thanks, I do have a Field service training here: ruclips.net/video/Wlcr5AvDS5k/видео.html
Also feel free to check out any one of my scheduling trainings and templates here:
I hope this helps and thanks so much.
Hey thank you very much and i really learned a lot from you u are the king of Excel .
Please can teach us how to make an Phone App to enter Data to the excel sheet becuase sometimes it feel lazy to open the laptop and enter the Data
so can you please try to do this idea
its like Enter form in exel but you can do it from Phone
Hi and thanks very much. I have done that in a video training here: ruclips.net/video/YayS7NP_xgY/видео.html
and here: ruclips.net/video/WRIBkgF61rc/видео.html
I hope this helps and thanks so much.
Hey thanks, unfortunately I'm not a patreon so I followed everything from the video and added some features to it like conditional formatting for the invoice list based on the date so that I can see quickly overdue invoices, PO number, wrote my version of the pdf save (makes a pdf per page then invoke pdftk server to merge them and then delete the temporary pdf), last save date code and last export/print code to compare version and authentication, a button to pull up a userform to add items in the item list sheet amd finally a note field that is on top of the invoice. Next feature I want to add is print/save as pdf a summary invoice from date to date.
Hi and thanks. It looks like you are doing well and making good progress. If you run into any issues or need help, please feel free to post your question 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.
@@ExcelForFreelancers I already am on the group, it helps that I've done some VBA for corel draw before but the videos are great and there's a lot from other tutorials that can be combined to build up the thing.
Thank you so very much, I really appreciate that Chris
Wow, Thank you Randy, just what I have been looking for. My Question is how can I set it up that if I type in an item that it automatically fills everything in and if the item doesn't exsist that I can automatically add the new item to my item sheet.
Hi and thanks, that is a nice suggestion and idea. I will add it on as a feature for the update next Monday on our Patreon platform here.
Would love to have you join: www.patreon.com/ExcelForFreelancers
@@ExcelForFreelancers I will definately join but unfortunately will have to watch it when I am able to do so, I am in Australia :)
Thanks very much. I recorded the video yesterday, and I included your solution and mentioned your RUclips name inside the video. It will be uploaded on Patreon this Monday. Thanks again for the great suggestion
Hi and thanks, this feature is now available on our Patreon Platform for the Updated Dynamic Invoice Designer.
You can find your idea completed here: www.patreon.com/ExcelForFreelancers
I hope this helps and thanks so much for the nice idea
Sir, make a video on restaurant management system including daily sales report,invoice,billing,purchase,inventory etc.
I will record the 'Restaurant & Cafe Manager' tomorrow and it will be released on January 31st. I am sure you are going to love it. Thanks for the great request.
Hi Rajib, here is the link to the Restaurant & Cafe Manager scheduled for release tomorrow: ruclips.net/video/p_ATIFfsRjU/видео.html
Hi Randy thanks very much for your video, just a quick question how do I change the currency from Dollars to Euros? In both list and totals on the invoice. Thank you so much.
Hi and thanks yes you would want to change it in the linked cells and in the columns.
I hope this helps and thanks so much.
Hi Randy , its very usefull, i have a question that i can start data with invoice # 90
Hi Kash, yes sure you can. You would want to clear all of the Invoice data and then update your 'Next Invoice ID' formula to =IFERROR(Max(Inv_ID)+1,50)
I hope this helps and thanks so much.
@@ExcelForFreelancers Thanks Sir
Hi randy....nice video.....just a question, can a userform open a file saved in onedrive, update the inside, then clise and save the file? File in onedrive act as a database
Hi and thanks for your comment. Yes it could, but it would be extremely slow. You are better off using text files to sync Excel workbooks. I teach you how to do that in this video: To share and sync your macro-enabled Excel workbook, please watch this training: ruclips.net/video/aKV5seZmiBs/видео.html
I hope this helps and thanks so much.
Thank you in advance ... ;)
Thank you so very much, I really appreciate that
Can we link the invoice to the inventory manager you have and also invoice manager to work with scanner
Hi yes certainly, Any USB scanner will act as a keyboard interface so it should work well without too many needed customizations
If you need help with this, 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
Wow! Dropping gems as always!!
Thank you so very much, I really appreciate that
useful
Thank you so very much, I really appreciate that Osama
You can guide me to be a cafe manager, use the shape to draw a table (the number of tables I customize) when I choose a certain table it will show a drink for me to choose (then put all the information to order drinks in 1 board) when the table has selected the dish will be colored differently from the table that has not ordered and has a payment button. After payment, the table will return to its original color. one button can edit previously ordered table, one button to print receipt.
Hi and thanks so much. I do not have it, however I really like the idea, so give me a few weeks and I will try to create it for you in a new RUclips training. Thank you for your Likes, Shares & Comments. It really helps.
Please also check out this video. It has a few elements of what you requested: ruclips.net/video/gx2R_H_mRO0/видео.html
I am completing programming on this for you, and it will be released on September 31st. Thanks again for the great idea.
@ExcelForFreelancer how do I get some help with some customizations and debugging?
Hi Scott. Thanks so much 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 there, The download won’t work with the newest excel update?
Is there a way around this?
Thank you
Hi Charlene, This workbook will work with any version of Excel. If you have tried to download this workbook using the links but had a problem please email Shane@ExcelForFreelancers.com . Please supply the email you used along with the workbook you are requesting. Thanks for your patience.
Hi Sir Randy. Howdy. Is it possible to add product image to the invoice ? and the image can link to my pc image folder. Thanks
Hi and thanks, yes for sure its possible. You can see my Point Of Sale videos on how to display images, similar to Invoices, here:
ruclips.net/p/PLIBeRriXvKzBohiJA68HSrtetepIR4Nna
I hope this helps and thanks so much.
can t waiting for the launch
Thank you so very much, I really appreciate that Rob. Just a few more hours :)
Hello Randy, Great job on this video. I have a question, i keep getting this error message The item with the specified name wasn't found on the Worksheet_SelectionChange sub
Highlighting Set Cal = Shapes ("Calendar ").
I am using the pop up Calendar which i installed properly
And from the video tutorials there is a macro link on the PopUpCal macros that enables the Calendar to show on the Invoice sheet. So what seems to be the problem cause i understand that the Calendar shape is on the CalPopUp sheet and not on the invoice sheet.
I would really love your response on this error as it is the only error keeping the invoice designer from running. Thank you in advance. Cheers
HI and thanks so much. You can just copy the calendar from the pop-up sheet, into the Invoice sheet and that should solve the issue. It may have been deleted from the Invoice sheet.
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
@@ExcelForFreelancersthank you so much for your response. I really appreciate it.
For sure, you are very welcome
Can I make it link to my WordPress wocommerce shop product list? That would be nice if it could since WordPress invoice and quotation form was horrible.
Hi and thanks for your comment. Yes you can. I show you how to do that in this video: ruclips.net/video/egzNg7AL7uY/видео.html
I hope this helps and thanks so much.
Can you make inventory management with Invoice will be better to update all in one save, update invoices vendor Vendor outstanding and customer payment and edit all in one 😊
HI and thanks very much. Yes i have done that already with my 'Ultimate ERP' template and training here: ruclips.net/video/HE-g2BAC5Ks/видео.html
I hope this helps and thanks so much.
Loving your content the moment I came across your channel. I was looking for something in line with credit and savings kind of content, it's for a cooperative. I would love to see content created on that☺
Hi Sandra, thanks so much. I have a few that might help or be customized such as my 'Mini-Accounting training and template here ruclips.net/video/itHilzsUHck/видео.html
or personal monthly budget here: ruclips.net/video/gIOj_6mIAR0/видео.html
If you are looking for a more customized solution, feel free to email me (Randy@ExcelForFreelancers.com ) I can refer a qualified developer.
I hope this helps and thanks so much.
@@ExcelForFreelancers thank you for your quick response😊
Good day. How can I use this template as a quotation system, but also automatically add a Terms & Conditions Page when printing the quotation to pdf.
Is there somebody that can help me with it and what will it cost.
HI Francois, thanks for the information. There is no doubt we can help you with that. While I am unable to take on any projects I would be happy to refer this out to a qualified developer. Can you please email me all of your specifications in a detailed scope and I can forward it to a developer? Randy@ExcelForFreelancers.com
Thanks so much.
logo is not changing , why?
HI and thanks so much. You can browse for your own logo when adding a picture to the sheet and remove the old one. I hope this helps and thanks so much.
Hello Master, I need its file in excel
Hi Tohiri, you can download this file using the links in the description under the word DOWNLOAD. I hope this helps and thanks.
why I always got debug notification
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.
👍👍👍
Thank you so very much, I really appreciate that Faisal :)
⭐⭐⭐⭐⭐
Thank you for your Likes, Shares & Comments. It really helps Redha