📅Excel Calendar Pro: Your Solution to Stress-Free Scheduling 👉 rebrand.ly/CalendarPro_PinnedComm
@connief26796 ай бұрын
What a fantastic training!! Between this training and the VBA for Beginners series, I finally finished my first invoice! It looks great! Thank you also for the support from the Facebook Group! 😄😄 I'm ready to learn UserForms next!! Thank you, Randy. A million blessings!!
@ExcelForFreelancers6 ай бұрын
Thank you so very much, I really appreciate that Connie. I am so glad we could help and Congrats on your first invoice. Very well done.
@ambienceprofessional58042 жыл бұрын
thanks a lot. i have a construction company that gives me a headache on paper works everyday. thank you for this.
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome. I am happy to help and share.
@fionathomas67174 жыл бұрын
Thank you so much for all your hard work. You make learning Excel easy. Can you make more from scratch videos. Or videos where you breakdown the functions and formulas. I'm still struggling to understand it all. Thank you again for all you do.
@ExcelForFreelancers4 жыл бұрын
Thank you Fiona, yes I will try. That seems to be the popular opinion so I am going to do my best on this. Much appreciated.
@fanfan6719 Жыл бұрын
applauses for, brillant pronunciation,, content, n flying directly to the results, u got the navy salute.
@ExcelForFreelancers Жыл бұрын
Thank you so very much, I really appreciate that
@cyrillmichaelambe88843 жыл бұрын
Randy thank you for this classes online I have learned a lot from your videos.
@ExcelForFreelancers3 жыл бұрын
You are very welcome Cyrill
@cyrillmichaelambe88843 жыл бұрын
Just from those videos I discovered that I still have a lot to learn to increase my skill.
@ExcelForFreelancers3 жыл бұрын
I am happy I can help. Thank you for your Likes, Shares & Comments. It really helps.
@rubyscupoftea94203 жыл бұрын
THank you so much for this very informative video, i always replay your videos because i am currently working on something and i find your videos very helpful for someone like me. i am interested with all your videos thanks for sharing your knowledge god bless you
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that.
@chandaatanu3 жыл бұрын
Hi Randy, Your video tutorial was excellent and was very simple to understand. I am building an Accounts Payable module on the MS Excel platform purely customised for my own workplace & this has really inspired me. Keep up the good work 👍.
@ExcelForFreelancers3 жыл бұрын
That is really great to hear i am so happy you enjoyed the lesson and it will help you moving forward in your own application. Thanks again.
@instapostercreations28753 жыл бұрын
I can get the dynamic range formulae to work, been try for 3 hours now with no luck...what amazes me is I copied exactly what you did there
@ExcelForFreelancers3 жыл бұрын
Hi and thanks for your comment. Sorry you are having issues can you share the formula or post your 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.
@yourhaven54033 жыл бұрын
I am grateful to have come across your channel. Great work!
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that Cha
@minalharsh36983 жыл бұрын
Great video! 2 suggestions on possible bugs - 1. Message Box displayed even when correct invoice # is entered on new invoice (maybe because inv. row is empty) 2. During Save/Update removing items does not work, only adding new items functionality is built in
@ExcelForFreelancers3 жыл бұрын
HI and thanks so much. I have a lot of those features added in my newest Invoice training here: kzbin.info/www/bejne/pKrNnGqVf5yUlaM
@grisrtcantas44842 жыл бұрын
Hi I solved the first issue which you mentioned by dupplicating the same Invoice_Load () (Copy Paste as Invoice_Load2() ) at the bottom and then: deleting this Part "MsgBox "Please select a correct Invoice #"" and "End IF", then replacing the " Invoice_Load " in the last row of VBA editor Sheet1 (invoice) with the new one : " Invoice_Load2" probably there are better ways to do it, but it works. For your Second issue i don't have a answer, i am just deleting the entry manuelly ,so it is't that big deal for me :D
@terrig57043 жыл бұрын
Randy you are a genius! I know so little about excel. I learn as I go so your video is amazing. I have created my own invoice but your invoice with the customer dropdown box is amazing. I'm just so bad at this that I cannot even add rows at the top to make space to fit my business details without getting an debug error. Your invoice only have the customer and I don't know if I can nicely space it in the merged cell with the invoice heading. Any help for a clueless will be much appreciated. Thank you.
@ExcelForFreelancers3 жыл бұрын
Hi Terri, thanks so much editing and customizing this does require a good deal of VBA knowledge I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/ If you run into a specific issue that you cannot solve please feel free to post screenshots of the issue, along with the details, 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.
@terrig57043 жыл бұрын
@@ExcelForFreelancers thank you very much Randy for offering more help and support but unfortunately I do not have facebook. Thanks for taking the time to respond. I really appreciate it.
@terrig57043 жыл бұрын
@@ExcelForFreelancers Hi Randy I want to add a customer dropdown list like yours on my invoice but when I try like you did at timestamp 14:26 i get errors. I think it is when I try to select the customers when I type in the "offset" part like you did to add the "=Customer_Name". How do you select? What do you mean by "tab out" and "tab back in"?
@ExcelForFreelancers3 жыл бұрын
HI and thanks for your comment. The only form of help and support we have at this time is the Facebook group. Many of our members have created a facebook account just to join the group. Thanks for your understanding
@ryanng3282 жыл бұрын
Thank you for your effort, love from Malaysia
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome and happy to help. You may also like my new one, also from scratch, called Invoice With Profit here: kzbin.info/www/bejne/g6Okd3Z_a6-SiMU
@duskobogos2348 Жыл бұрын
He says: 'Its ALL kind of confusing !!'.....wow wow! a shocker. Honestly, I miss my 80's & 90's... I loved my pen and pencil...what a hassle this is!! Wot Wot? Now I understand, listening to this guy... that Yes.. the humanity is up to ..it.
@ExcelForFreelancers Жыл бұрын
Thank you for your Likes, Shares & Comments. It really helps.
@sanjeebananda3 жыл бұрын
Thank you so very much. Amazing teaching. I learnt a lot today....
@ExcelForFreelancers3 жыл бұрын
For sure, you are very welcome Sanjeev. Please check out our School Management series in which I show you how you can create your own Excel applications, from scratch, in an amazing series right here: bit.ly/SchoolManagerSeries
@ianblake92434 жыл бұрын
Hi all, Thank you all for the opportunity to learn and be able to produce a worthwhile product. I am a 73 year old and have only taken up Excel in the last 15 months to stimulate the brain and fulfill my fascination with VBA. I have made and converted Randy's invoice to a service invoice for my son who is a fiberglass caravan and motor home repairer. I have the invoice up and running with a number of extra requirements in the sales: Insurance - Customer area. My question to you is: To keep invoice rows contained to the least number required for a given quote/invoice, is it possible to add a VBA formula that can automatically increase rows and formulas as required and then when the invoice is saved revert back to the original size invoice. I have managed to insert a manual solution with a button but if there is a solution to my request can you advise me where I may find such information. Many thanks to you all
@ExcelForFreelancers4 жыл бұрын
Hi Ian, thanks so much. I really appreciate your comments. It is a great question for sure. What you can do is create a Shape-based, floating footer, which will be positioned based on the last row of content. This is what I have done for the Invoice that I am designing in the Accounting Application in our Mentorship program. You can find a picture of that Invoice sample here: www.dropbox.com/s/cu61b33iq4rxk1n/Invoice_SS.jpg?dl=0 More information on our Mentorship Program here: bit.ly/MentorProgram_YTComment I hope this helps and thanks so much
@ianblake92434 жыл бұрын
@@ExcelForFreelancers Thank you for your reply, I look forward to seeing your application of the floating footer and trying to use it in my invoice. Meanwhile I will keep on learning more VBA to satisfy my fascination with Excel
@ExcelForFreelancers4 жыл бұрын
Thanks so much Ian. :)
@deepakbhanushali12 жыл бұрын
what a macro hours of work completed in min Sir wonderful , Sir I want to sort all the invoicelist with itemrow that to customerwise and create a pdf for that full year
@ExcelForFreelancers2 жыл бұрын
HI and thanks so much. Can you post more details 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.
@joemanflyer20014 ай бұрын
Nice invoice setup !!
@ExcelForFreelancers4 ай бұрын
Thank you Joe, I am glad I could help
@ma7moudabaza6384 жыл бұрын
thanks a lot Mr.randy for your useful lesson
@ExcelForFreelancers4 жыл бұрын
You are very welcome, and I am happy I could help
@ChillSheiakh3 жыл бұрын
well done, very good training. God bless you
@ExcelForFreelancers3 жыл бұрын
For sure, you are very welcome Mohammad
@harveyblackwood35633 жыл бұрын
Thank you for this tutorial. I did an invoice template in MS Access for my school project and I based it from this tutorial. 🥂
@ExcelForFreelancers3 жыл бұрын
Hi Harvey thanks so much for your comment. Really happy to hear that. Very well done.
@aftabalamkhan729011 ай бұрын
Thanks alot for this amazing tutorial videos. You are excellent. I have no words to praise you. I have one question - In the invoice, an item will be displayed more then one time if same item is sold in quantity more than one. If 3 pcs of a shirt is sold, it is displayed three times in the invoice instead of one time with quantity 3.
@ExcelForFreelancers11 ай бұрын
HI and thanks. Yes you can automatically total items if you like. I show you how to do that in this video kzbin.info/www/bejne/iZPNc5qnr8d0adk I hope this helps and thanks so much.
@sarasilva87443 жыл бұрын
Amazing! I followed your tutorial and everything worked! I even learned new ways to implement code and how flexible vba can be. I am glad I found your videos while browsing new things to try out! Keep up the good work!
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that Sara
@atingodiong1973 жыл бұрын
very good by show how to add new customer detail and new item
@ExcelForFreelancers3 жыл бұрын
For sure, you are welcome. Thank you for your Likes, Shares & Comments. It really helps.
@TheLegend_lab9 ай бұрын
Dear Randy, Majority of video's i have watched so far are more in financials, invoices, and inventories management and they are super great. Can you perhaps, also create the user form database that has got futures like hiding excel after login and show only big rectangle userform, should have with admin status that allows admin to provide new user access to certain information, searchable bar to search for specific employee, hilight raw of data when select employee in database, unable to create a duplicate employees profile due to same employee number, full name, and date of birth, remove inactive raw data of employee by selecting end date eg. Just like when an employee is inactive they should get removed from active list and automatically gets updated in the inactive sheet database and additional column gets added showing inactive, user form should also be able to add new staff, edit, delete entry, dependent dropdownlist, autofill back certain information when selecting employee. That will be brilliance 😊
@ExcelForFreelancers9 ай бұрын
Hi and thanks very much for your suggestions. These would be features for a customized application for a single purpose. You may want to take my Employee Manager training and customize it based on your requirements. With that said I do have a training coming out that is based entirely on a userform here: kzbin.info/www/bejne/b5PMdHWCrKqhna8 I hope this helps and thanks so much.
@عائلةالوزيرى Жыл бұрын
Thank you so much for all your hard work. You make learning Excel easy. but how i get back the previous invoice when i want to print it again for the client or to make any update on it or else
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much. You can add Previous and Next buttons. I show you how to do that in this training: kzbin.info/www/bejne/lZPSpYGaoLetsM0 I hope this helps and thanks so much.
@malakismani3 жыл бұрын
Hello, I love your videos and find them extremely helpful. One question I have is, when I open VB, I try and change the module from “general” to “worksheet” but for some reason the “worksheet” option does not pop up. I tried to still do the code but it won’t work. What do I do? Thank you
@ExcelForFreelancers3 жыл бұрын
Hi thanks so much 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 30,000 Members who would love to help you with this. Thanks so much.
@Snowdrift0638 Жыл бұрын
I'm having this same problem. I just requested to join the group, hopefully there was a resolution to this problem.
@awildalpz2 жыл бұрын
Hello. God bless you. Thank you for offering this video. It’s detailed and what I’d want to have. However, I got stuck with adding Address 1 and 2. It doesn’t show. I’ve checked repeatedly if I miss something in the coding but I didn’t. So, do you offer services to create this and if so, how much?
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much. If you have just a single issue, you can post that 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. If you would to create a custom solution, 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.
@BB-bs7hm3 жыл бұрын
Is this invoice system associated with barcode field... to make it work easier with barcode scanner.... do you work in the future with MS access or only with excel..... to be honest with you. ... you exceptional and your ideas is different... top notch Mister Randy
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that. You an add any bar code to any field simply by changing the font to a bar code font. This way the Invoice # can be changed to a bar code. I exclusively work with Excel only. Thank you for your Likes, Shares & Comments. It really helps.
@saulcampos44043 жыл бұрын
Hi Randy can you start adding a small part at the beginning where you show the finished product's functionalities. I find myself having to scroll through the video to see if certain methods are included
@ExcelForFreelancers3 жыл бұрын
HI Saul, thanks for your comment. I do that mostly now with my newer videos, where I use a sample workbook to show all the features, before closing it and working on a blank one. Make sure to check out the POS With Inventory video launching in 14 hours right here: kzbin.info/www/bejne/iZPNc5qnr8d0adk
@chrisfotoglidis4374 жыл бұрын
Very intersting. Nice Work.
@ExcelForFreelancers4 жыл бұрын
Thank you very much. I do appreciate that Chris
@chanmonanrie68983 жыл бұрын
Thank you so much for your prompt responses to my previous questions - you guys were able to fix my problems with the INVOICE. However, I'm now having trouble making show up the DESCRIPTION, QTY, PRICE on the INVOICE whenever I click the ITEM (they did show up before), these strings no longer show up. What should I do?
@ExcelForFreelancers3 жыл бұрын
Hi and thanks make sure that the Invoice Load is set to False within VBA. Please download my sample and use that for comparison . I hope this helps and thanks so much.
@AdeKaryadi3 жыл бұрын
Nice tutorial, thanks
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that.
@wlondoner3 жыл бұрын
What an amazing totorial. Thanks so much for your time. I wonder if you have a another totorial that shows the invoice been paid. If paid, payment confirmation will be generated and ready to be emailed otherwise it will show payment overdue. I look forward to your reply. Many thanks again
@ExcelForFreelancers3 жыл бұрын
Hi and thanks for the great suggestion. I am currently working on a School Manager series (here bit.ly/SchoolManagerSeries ) However when I finish that I would like to do an Automated Time Tracking & Billing application that would track time, billing & payments with a similar invoice. Please keep watching the videos and I will get this done soon. Thanks again.
@wlondoner3 жыл бұрын
@@ExcelForFreelancers yesss i will definitely keep watching. i can re assure that you have another committed subscriber.
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that.
@shiningstars25732 жыл бұрын
Hello sir thank u so much: Sir can I make a video on Excel that has the following features: 1.where we can make automatic invoice like above. 2.where items automatically deduct in stock sheet. 3. Where we will write hsn code of item and all the details of that item will automatically be showed. I mean to say that it must be like an application that comes on net.
@ExcelForFreelancers2 жыл бұрын
Yes sure you can do all of that, No problem at all. IF you need help with this, feel free to request help 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.
@khidhirmohd54112 жыл бұрын
Hi, Tq for the video, I've love and learned much through your training. But still need to figure out one thing, what is the formula for the Range combination eg: .Range("B" & MonthRow & ":H" & MonthRow).Value if the Item cells on your receipt are merged with other colums, let say B through F columns are merged in the formula above. Thanks in advance
@ExcelForFreelancers2 жыл бұрын
Hi and thanks very much. When you have merged cells, you will want to use the upper left cell for formulas. When you are clearing merged cells you must use the upper left and the lower right. 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
@khidhirmohd54112 жыл бұрын
@@ExcelForFreelancers sry what i meant was B through F -->Row not colums, are merged, my bad
@ExcelForFreelancers2 жыл бұрын
Can you please post your detailed question, 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.
@fernandogonzalez5714 жыл бұрын
Simply Amaizing thank you for share your knowledge
@ExcelForFreelancers4 жыл бұрын
Thank you very much. I do appreciate that.
@rashida77774 жыл бұрын
I am just in ann excel precursor class...OMG! I am terrified now!
@ExcelForFreelancers4 жыл бұрын
HI and thanks so much for your comment. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
@salesdepartment68672 жыл бұрын
Thank you for your explanations. I would like to know if you have a special video with an excel file por quantity, gross weight, net weight, carton size, what we call packing list , thanks a lot, and have a nice day
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much,. I do not have a video on this specific items however you can download this application using the link in the description and add these additional features.
@wndmiles2 жыл бұрын
Wow! You really know your stuff! Unfortunately, I do not. I’m a beginner in an office where I need to learn how to do this. Your over my head here and moving way to quickly for me. Do you have beginner tutorials that can bring me up to speed?
@ExcelForFreelancers2 жыл бұрын
Hi and thanks for your comment Wanda. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
@wndmiles2 жыл бұрын
@@ExcelForFreelancers You really do care! You’re not one of those that puts info out there and then leave us dummies hanging. Thank you for your quick response! I will investigate the info you sent me. Thank you!
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome Wanda. Happy to help
@maiphuc42254 жыл бұрын
Nice work. Keep it up😊
@ExcelForFreelancers4 жыл бұрын
Cam On Em :)
@JamesWilliams-gx3rr2 жыл бұрын
Hi Randy, I stumbled on your video and it's amazing. I am half way through following along building this. I think I need help making the tool that I am envisioning though. Can you tell me what's the best way to find someone like you to develop a quoting tool/invoice tool that is customized to my needs? If you are interested, let me know. Thanks!
@ExcelForFreelancers2 жыл бұрын
Hi James, thanks so much and glad you love the training. The best way would be to write up a detailed scope of your requirements then email them to me along with your budget. I can then forward it to a qualified developer. Randy@ExcelForFreelancers.com I hope this helps and thanks so much.
@manibbt0073 жыл бұрын
hi sir thanks for your hard work to teach us. please give formula to add discount tab at different percentage. Thank you sir. God lees you
@ExcelForFreelancers3 жыл бұрын
Hi and thanks, please see my updated POS training on how to add discounts here: kzbin.info/www/bejne/iZPNc5qnr8d0adk I hope this helps and thanks so much.
@manibbt0073 жыл бұрын
@@ExcelForFreelancers Thanks a lot sir
@shekhsadi3 жыл бұрын
it's very helpful-thank sir
@ExcelForFreelancers3 жыл бұрын
For sure, you are very welcome Shekh
@leighannmurdoch58042 жыл бұрын
Love the video and thank you, but I have one question. My print port blew and I am waiting on the path. I am unable to run the program. Can you assist in fixing this problem till I get my part please.
@ExcelForFreelancers2 жыл бұрын
Hi and thanks you will want to set your default printer to a different printer in your computer settings. I hope this helps and thanks so much.
@geoffrosaliejackson9580 Жыл бұрын
Hi I have used this program to create invoices it is fantastic, I need save my invoices as PDF and then want to send the PDF attached to an email automatically can this be achieved??
@ExcelForFreelancers Жыл бұрын
HI and yes, it can, you can check out this video here: kzbin.info/www/bejne/lZPSpYGaoLetsM0 I also show you how to email this on my Patreon channel here: www.patreon.com/ExcelForFreelancers
@ictassistant75293 жыл бұрын
thanks so much for this tutorial. my only question is how do you add an option for print preview, so that you can see the how the printout is before printing?
@ExcelForFreelancers3 жыл бұрын
Hi and thanks very much for your comment. You can add something like this: Worksheets("Sheet1").PrintPreview I hope this helps and thanks so much. Thank you for your Likes, Shares & Comments. It really helps.
@ictassistant75293 жыл бұрын
@@ExcelForFreelancers thanks so much
@ExcelForFreelancers3 жыл бұрын
For sure, you are very welcome
@joshuakasase96252 жыл бұрын
Wonderful work
@ExcelForFreelancers2 жыл бұрын
Thank you so very much, I really appreciate that Joshua
@uclevan10024 жыл бұрын
Thank you so much . I'm from vietnam's fan
@ExcelForFreelancers4 жыл бұрын
Cam On Em. I live in Da Nang. Nice to have you here.
@surendramajeti96283 жыл бұрын
Very nice explanation .please share this sample template 😊
@ExcelForFreelancers3 жыл бұрын
Hi, you can download this file using the links in the description above with either your email or Facebook Messenger. I hope this helps and thanks.
@johnballo24024 жыл бұрын
What about not print it but send it to clients email. It would be cool. In by the way nice job sir and soon I will be purchasing that 100 workbook... and one more question sir... when I get it can I resell one of those applications... ? Thank you.
@ExcelForFreelancers4 жыл бұрын
Hi John thanks so much and I am really glad you like it. In my Mentorship Program I am creating a comprehensive Invoice in which you can email, send, save as picture, pdf, or Excel as well as duplicated it and make recurring. It is also fully customizable. Feel free to join us here: bit.ly/MentorProgram_YTComment Concerning the resale of the applications, yes you are allowed to customize and resell the applications as you wish, however you will want to fully check for issues and customize them as well before putting them on the market.
@mariiopara86802 жыл бұрын
Hi John can I buy the template for the invoice app you discuss in the mentorship programme direct from you?
@nextgene-motors29223 жыл бұрын
This is so beautiful. Thanks Randy for this amazing video.
@ExcelForFreelancers3 жыл бұрын
For sure, you are very welcome, I am happy to help.
@nextgene-motors29223 жыл бұрын
@@ExcelForFreelancers thank you sir... thank you for your valuable reply and time,,,
@nextgene-motors29223 жыл бұрын
@@ExcelForFreelancers sir i want to create a excel invoice for retail shop. Could you please share any link that have inventory stock also... That is very helpful for me...
@ExcelForFreelancers3 жыл бұрын
This Invoice from scratch will work just fine for you, then you can add any features you want onto it. Thanks again.
@BassamThebian8 ай бұрын
Many thanks for this video, really great. one question though, when doing the dynamic list as you described it's still showing blank rows. any reason?? would very much appreciate your answer on this.
@BassamThebian8 ай бұрын
please note I have formulas in those rows, would that effect?? what can I do?
@ExcelForFreelancers8 ай бұрын
Hi and thanks very much if you have formulas in these rows, and they are returning nothing you can use a slightly different formula, something like =Offset(Sheet1!Range($A$1,,,50-Countblank(Sheet1!$A$1:$A$50),1) This will subtract the # of blank cells from the total cells in your range. Just update the Sheet names and ranges 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
@BassamThebian8 ай бұрын
Many thanks in deed. I will try it for sure.
@BassamThebian8 ай бұрын
Thank you, it worked perfectly.
@ExcelForFreelancers8 ай бұрын
Thats great to hear. I am glad it helped
@mdkamruzzaman63982 жыл бұрын
Thank you so much for your hard work. ❤️❤️❤️
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome. I appreciate that.
@fsfu100 Жыл бұрын
great video as usual - i need an invoice format with the following: - individual product tax rate (uk VAT) - dynamic invoice length (not pre-determined ) - multi currency capability - product price bands according to customer type (wholesale, retail, or customer specific) can you help?
@ExcelForFreelancers Жыл бұрын
HI , 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.
@aminuddinbaharom Жыл бұрын
Hi Randy, This is a great tutorial and helps us do better in our work. I have a question. How can I do that if I want to have a specific Invoice running number? let's say, instead of 1, I like the running number to be INV-001 as an example. Please help.
@ExcelForFreelancers Жыл бұрын
Hi and thanks so much for your suggestion. If you want a different type of invoice # you can use an extra column. One column to keep the numerical invoice # and another column to keep the alphanumeric Invoice #. On new Invoices you can use VBA to combine the text with #'s to create the desired Invoice #. I hope this helps and thanks so much.
@yahyaramadhan26983 жыл бұрын
Hi Randy What a perfect POS system you created from scratch. How else can you link it up with a stock system in the same worksheet. For example as I prepare the receipt, and change quantities, I would like it to reduce stocks and give me alerts when quantities are below minimum.
@ExcelForFreelancers3 жыл бұрын
Hi and thanks so much for your comment. I am glad you liked the training. This automated Purchase Order may help you with that right here: kzbin.info/www/bejne/aXPVpJapetGhbc0 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
@JanBolhuis10 ай бұрын
This is a great tutorial. Thank you very much.
@ExcelForFreelancers10 ай бұрын
For sure, you are very welcome Jan. I am happy to help and share. I have a brand new Invoice from scratch coming out next week which will include Installment payments. Thank you for your Likes, Shares & Comments. It really helps.
@AmirSina2 жыл бұрын
Hi Randy, this tutorial is amazing. thank you for all your time and effort creating it and it's so generous of you, making them available for free. I have question: in the invoice it's been assumed that the customer database is already available. what if we start the customer list from scratch and adding them while we create the invoice. i.e. building up the customer list. how can we do that?
@ExcelForFreelancers2 жыл бұрын
Hi that is a great question. I solve that issue in this training: kzbin.info/www/bejne/g6Okd3Z_a6-SiMU Also, another issue I will solve next week is: 'What if the invoice items create multiple pages?' I will create a new training video next week to solve that problem I hope this helps and thanks so much.
@macman0077473 жыл бұрын
Another great lesson Randy, thanks!
@ExcelForFreelancers3 жыл бұрын
Thank you so very much, I really appreciate that Rob and always appreciate your help and support.
@hydrogenperoxide48484 жыл бұрын
This tutorial was amazing, I like your each video. I have taught a lot from your videos. I have a question about this invoice , hope you will help me. What if my invoice items exceed than the number of rows i have allotted to them..? How can we make that dynamic so that where my invoice items end, the subtotal and total automatically come under that.?
@ExcelForFreelancers4 жыл бұрын
Hi and thanks for the great question. In my Mentorship Training I show you how to create a dynamic invoice with unlimited rows with a floating footer, where I am creating an entire accounting application including Inventory, Purchases, Dashboard, Multi-User sharing & sync and a ton more. You can learn more about the program here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
@hydrogenperoxide48484 жыл бұрын
Excel For Freelancers Thank you Randy☺️
@tobayekaina86104 жыл бұрын
Hi Randy thanks for sharing
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome Tobaye. I think you will enjoy this one as it starts with a blank Invoice. This is a far simpler Invoice template that what we are creating in the Accounting application, but its a great foundation to build on.
@blancawilhelm76653 жыл бұрын
Hi Randy, i would like to learn more about how to create a more templates, more about macros and formulas, can you training me? i created this invoice but something when wrong can you take a look of what i did?
@ExcelForFreelancers3 жыл бұрын
Hi Blanca, Thanks so much for your comment. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
@MrDinhoR2 жыл бұрын
Great Video.. Just one question. how to add a email button, so the invoice can be sent to customers email address (of Customers "Sheet5") instead of printing it>>>>
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much. You can print it to PDF and then Attach it in an email. Next week (May 24th, I will have another Invoicing video that shows how to create a Multi-page invoice) In this video I will also show you how to email an Invoice. I hope this helps and thanks so much.
@alfredreloj6834 жыл бұрын
Great video, Randy!
@ExcelForFreelancers4 жыл бұрын
Glad you enjoyed it Alfred :)
@tonydao18283 жыл бұрын
Thank you for much for this tutorial. my only question is how do you do a quick search in the customer name?
@ExcelForFreelancers3 жыл бұрын
HI Tony thanks so much. You can use an advanced filter to search for a partial name. I show you how in this video: kzbin.info/www/bejne/j6amo3iNipeHo5I
@chanmonanrie68983 жыл бұрын
Your video have been a great help to my small business. One thing I'd like to learn is how to change the INVOICE No. 1 in your video to my preferred INVOICE No. 210001. Would you show me how to do this?
@ExcelForFreelancers3 жыл бұрын
Hi and thanks very much. We use the Max formula to generate the next Invoice #'. If you clear out any existing invoice data you can generate the next Invoice # for 210001 using this formula =Iferror(Max(InvNumb)+1,"210001") Just update the variable according to your named ranges for Invoices. 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
@yosef-yosef94144 жыл бұрын
great video, very informative for all excel users. do you have a Video for VBA excel tutorial? i hope you'll gonna have
@ExcelForFreelancers4 жыл бұрын
Hi thanks I have over 140 videos on my channel, many of which are intermediate. (The Channel 'Excel VBA is Fun' is a great channel that is a bit more basic. I hope this helps and thanks. I will usually cover more advanced VBA because there are already thousands of videos on VBA basic training my videos are often more advanced. Thank so much.
@yosef-yosef94144 жыл бұрын
@@ExcelForFreelancers Excel VBA is Fun
@ExcelForFreelancers4 жыл бұрын
Yes it is and it is a great channel for sure. I am sure you will like it to learn the basics. Also WiseOwlTraining is a really great channel to learn the basics also.
@sandilekhumalo56934 жыл бұрын
i can't wait for a day where i will be as incredible as you with excel.
@ExcelForFreelancers4 жыл бұрын
Thanks so much. For sure you will be. Keep up the great work.
@munnamazi61152 жыл бұрын
absolutely amazing
@ExcelForFreelancers2 жыл бұрын
Thank you munna, Thank you for your Likes, Shares & Comments. It really helps.
@medkari4 жыл бұрын
thanks Mr RANDY
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome Med
@wymes13 жыл бұрын
I tried this oder form. Works great. Only this is, you can't delete an invoice once it's created.
@ExcelForFreelancers3 жыл бұрын
Hi and thanks so much, and glad you like it. You are welcome to add the delete feature and download my version. I often leave off components in order to challenges students to add them to increase their skills. Thank you for your Likes, Shares & Comments. It really helps.
@wymes13 жыл бұрын
@@ExcelForFreelancers thanks so much. I appreciate the challenge. As a novice, that barely understands the pseudo, i was scared to mess something up beyond recovery.
@ExcelForFreelancers3 жыл бұрын
Thanks so much. Sometimes the best way to learn is to mess things up then try to fix them again. :)
@varismashkuli60364 жыл бұрын
Thanks Randy
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome Varis
@ProHack_GR13 Жыл бұрын
Hi.. really cool, one question! It would be nice to only allow to print an invoice when it has been saved. This way you can't send out any invoice that was not saved. Any suggestion on how to fix that, i'm struggling on that.
@ProHack_GR13 Жыл бұрын
And one more.. if you dont add any data to the invoice it stil saves it. It would be nice if it doesnt allow you to save the invoice when it is a blank invoice.
@ExcelForFreelancers Жыл бұрын
Yes sure, you can. Just check the cell that displays the row number of the invoice, if it is blank, that means the invoice has not been saved yet, and you can require the user to save it before printing. You can also check the last row of data, if it is the same as the header row, you can ask the user to add an item before saving the Invoice. I hope this helps and thanks so much.
@upaliwijeratne869610 ай бұрын
This Invoice is very nice creation. I want to how can I restrict the entries in cells which are not meant for data entry please
@ExcelForFreelancers10 ай бұрын
Hi and thanks very much. You can go to the cell properties and make sure the cell is locked and then protect the sheet. I show you how to do this in this training: kzbin.info/www/bejne/hImxcmWrrqisgNE I hope this helps and thanks so much.
@rayl10434 жыл бұрын
Thanks, Sir, I need your help. I'm new to excel, but with the help of your video, I have created an auto repair invoice. When add a new customer and save the data the template close and the save one open. I have lost many invoices trying to write over a spare one. How do I keep this from happening?
@ExcelForFreelancers4 жыл бұрын
Hi Ray its hard to tell. Make sure you are saving it as an xlsm file and also save your workbook before running any macros. 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 25,000 Members who would love to help you with this. Thanks so much.
@laurellsnailsandcare2 жыл бұрын
This is a great video, but I can’t seem to get the macros to work. It keeps saying duplicate declaration in current scope
@ExcelForFreelancers2 жыл бұрын
Hi Laurell's, 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.
@magichands19824 жыл бұрын
How did you get your selected row and column identifiers to be yellow instead of gray? Thanks for these videos by the way, I watch a few everyday!
@ExcelForFreelancers4 жыл бұрын
Hi Robert, thanks very much for your comment. I just colored the background cell yellow, There is no conditional formatting on that. In the video coming this Tuesday I will do another from scratch so you can follow along as well. This upcoming week i will be showing you how to create Work Orders and sync with Mobile Staff.
@magichands19824 жыл бұрын
I meant the color of the cells you have selected, not the cell it'self but the identifier at the top and far left of the screen indicating which cell you have selected. Mine is gray, is there a way to change it to the yellow like you have? And that sounds great! looking forward to the new lesson!
@ExcelForFreelancers4 жыл бұрын
Hi Robert, to change the selected cells when a user selects a row i used a conditional formatting with a formula such as =$B$3=Row() Then when a user makes a selection change the row color will change based on the applied format in the conditional formatting. You can learn about that here: kzbin.info/www/bejne/bILKqmSOi6-Mnrs
@upaliwijeratne869611 ай бұрын
Hi Nice Vedio However I can not find worksheet object in VB Object menu when I try select it. Pls advise me
@ExcelForFreelancers11 ай бұрын
HI and thanks very much. The worksheet object is only available in the worksheet code (not in a module) so in VBA you would want to right click the sheet and click View Code in order to select the worksheet objects and then your workhseet event. I hope this helps and thanks so much.
@Hussainlhr2 жыл бұрын
Thanks a lot. will you please guide me. I just need that invoice number should start from 1 again next day with the date change plz help me to do so.
@ExcelForFreelancers2 жыл бұрын
HI and thanks you can run an if statement checking on the previous Invoice Date and if the current date is not the same as the previous date then show the current date. 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
@sphiwemthimunye52014 жыл бұрын
Thank you so much for amazing skill.
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome, I am glad I can help. Thank you for your Likes, Shares & Comments. It really helps.
@evanturner30464 жыл бұрын
having troube getting the addresses to populate. I'm not very familiar with macros, but i am following all your steps and keeping line for line.
@ExcelForFreelancers4 жыл бұрын
Hi Evan thanks so much for following. 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 30,000 Members who would love to help you with this. I have a free VBA course taught by MVP Sumit Bansal on my site right here: www.excelforfreelancers.com/enroll-in-the-free-excel-vba-course-by-mvp-sumit-bansal-of-trumpexcel/
@robertbateman36653 жыл бұрын
Question: What happens if the invoice migrates into multiple pages? Printing and recalling the invoice? Curious thought. I really like your videos. Thanks.
@ExcelForFreelancers3 жыл бұрын
Hi and thanks so much Robert. Multiple pages is not a problem. You can determine the last row using xlup then set the print range dynamically within the code. 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
@alistairscott92163 жыл бұрын
Hi, I have watched your video, I am a bit rusty with Excel. I have entered text and cell info verbatim in Macro and Cell "E4" and "E5" are still blank when I go back to invoice view, to see if it's working, (The address box is still empty after double clicking in the cell. What Am I doing wrong? I have made my works sheet the same as yours to the Letter. Cheers Alistair
@ExcelForFreelancers3 жыл бұрын
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 40,000 Members who would love to help you with this. Thanks so much.
@sheikhified4 жыл бұрын
Thanks again Randy
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome
@RealSuperNintendan4 жыл бұрын
Hello my friend. I am just wondering what program or app you use to record your screen? Also, what microphone (or headset?) do you use? And finally, what program do you use to put it all together?
@ExcelForFreelancers4 жыл бұрын
Hi and thanks for your comment and question. For the recording I use Camtasia Student Microphone i use Yetti Blue. And to edit it and put the video together i also use Camtasia Studio for that. I hope this helps and thanks.
@andrewbartlett8244 жыл бұрын
Love watching learning well in lock down, I have created the invoice and macro but on my true ,fales dose not work as it should as sometimes it reads ture ,ture or false, false which will not allow me to crate a new invoice and not ad items unless I manually change them any idea why
@ExcelForFreelancers4 жыл бұрын
Hi and thanks for your comment. It would be difficult to know what is causing the issue unless we see your code. 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
@nenylee60733 жыл бұрын
Hi sir please make video how to create quotation,invoice & delivery order (items & customer list ) using excel Please.....
@ExcelForFreelancers3 жыл бұрын
Hi and thanks. I have all of that already. Please search my channel. I hope this helps and thanks so much.
@karemapringle19463 жыл бұрын
Really appreciate these video's learnt a lot
@ExcelForFreelancers3 жыл бұрын
For sure, you are very welcome Karema
@deenwayztrading32622 жыл бұрын
Hi Randy, How do we store each invoice in google drive with one click? If you have done video for that please send the link. Thanks
@ExcelForFreelancers2 жыл бұрын
Hi and thanks so much. You can download the Google Drive application for your computer and simply safe the Invoice as a PDF in that folder. I hope this helps and thanks so much.
@deenwayztrading32622 жыл бұрын
@@ExcelForFreelancers Thanks a lot Randy It works. Thanks for teaching us.
@renatajesus67693 жыл бұрын
Hi! Hope everything is perfect for you. I've seen practically every Excel for Freelancers video. I would like to know how I can get to learn how to make the invoice program and how much ...
@ExcelForFreelancers3 жыл бұрын
HI Renata, thanks so much. It is free, you can download this application using the links in the description and follow this video to make the Invoice program. Thanks again.
@majedshareif36114 жыл бұрын
Nice to listen that. Thank you Manger. And I appreciate your efforts for all that is made.
@ExcelForFreelancers4 жыл бұрын
For sure, you are very welcome Majed and thanks so much.
@abirmahmud31154 жыл бұрын
Thank you for the nice tutorial. If I want to delete an item from loaded invoice what are the steps we needed?
@ExcelForFreelancers4 жыл бұрын
Hi you can add an inline button to remove or add new. You can use this training here to help you: kzbin.info/www/bejne/roC6e3yifJ2Le6c Thanks for the great question. I am also teaching a comprehensive Invoice with all of these features in my Mentorship Program here: bit.ly/MentorProgram_YTComment
@riyaa80613 жыл бұрын
Very Useful, It would great, If you could provide delete invoice item event, Can you assist me that same..
@ExcelForFreelancers3 жыл бұрын
Hi and thanks so much for your comment. When deleting an invoice item you would just have to delete the original database item based on the database row. I am teaching full Invoicing features in my Mentorship Program here: www.excelforfreelancers.com/product/excel-for-freelancers-mentorship-program/
@rofiqulislam75442 жыл бұрын
Nice video ❤️❤️
@ExcelForFreelancers2 жыл бұрын
Thanks for the visit. I really appreciate that Rofiqul
@seanfletcher76592 жыл бұрын
Hello Randy. Awesome tutorial! I made it about 15 minutes in when I realized that the version of excel that Ian using doesn’t have the name manager function under the formula toolbar. Wondering if there is a work around for said issue? Please advise. Thanks!!!
@ExcelForFreelancers2 жыл бұрын
Hi Sean, thanks very much. Is that a Mac version? I have heard that some versions of Mac's dont have name managers. Perhaps a different version or OS would be better if this is the case. I hope this helps and thanks so much.
@seanfletcher76592 жыл бұрын
@@ExcelForFreelancers Yes, It is on an older mac. Think the version of Excel I am running is 2011. I can see the name manager Icon but it is grey and can't select it. Sad to hear, Oh well. Thanks anyway Randy, i'll try on a newer computer
@gutangerine3 жыл бұрын
Thanks for such a great tutorial! I am walkthrough it and practising, only to find that I am stuck at the first Macro where the customer details don't pull up themselves..... wondering what went wrong in my script.....
@ExcelForFreelancers3 жыл бұрын
Hi, Thanks for your comment and I am glad you enjoyed the training. 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.
@lemyul2 жыл бұрын
thanks
@ExcelForFreelancers2 жыл бұрын
For sure, you are very welcome and happy to help.
@musedeeknasr82974 жыл бұрын
very helpful work but i have a question when i put the codes to show the address like you explained it doesn't work with me like it did with you any help with that? notice i'm excel amateur
@ExcelForFreelancers4 жыл бұрын
Hi its no problem. These things take time, and we are happy to help. Can you share a screenshot of your code, along with the detailed issue in our Excel For Freelancers Facebook Group here: bit.ly/groupexcel . We have 25,000 members and would love to help you though this.