Thanks for the tutorial! It would be interesting to learn how to automate the invoice Numbers as well and avoid dupes.. 😊
@microsoft-certified-trainer
6 ай бұрын
I think you should use CTRL+SPACE after typing beginning of variable name instead of typing its manually to avoid typos
@andre6543
3 ай бұрын
*Using Excel for Mac* I am running into an issue with creating the PDF export in Visual Basic. When I click to run the code I receive the following error message: "Run-time error '1004': Application-defined or object-defined error The code has been typed exactly as it is on the video. Not sure what I'm doing wrong. Can someone help correct the error?
@armoghanshahid4605
3 ай бұрын
Hey, it was very helpful. Can you upload the file that you edited, for reference? It'll be a great help. Thanks
@keithhobbs
3 ай бұрын
Sub PDF() Dim invoice_number As Long Dim Name As String Dim file_path As String Dim file_name As String invoice_number = Range("G4") Name = Range("D5") file_path = "C:\Users\Hobbs\Desktop\Desktop\pivotal\Invoices\" file_name = invoice_number & " _" & Name ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, ignoreprintareas:=False, Filename:=file_path & file_name End Sub
@paklibas2514
6 ай бұрын
Please add "Amount in words" line in the invoice. It's an integral part of invoice.
@i.5mviews923
6 ай бұрын
Pls go to chatgpt type prompt spellnum vba code , copy it and open your f11 vba editor go to insert module , paste there.
@KenjiExplains
6 ай бұрын
Interesting. I had only seen that in checks, didn't realize it was a big thing with invoices! Thank you for your suggestion.
@robparker1625
6 ай бұрын
I am accountant and have never seen this in words. Is this country specific?
@darkace0387
6 ай бұрын
Same I am a budding chartered accountant and have yet to find a client that uses "Amount in words" as an integral part of their invoices :/
@sean89n
5 ай бұрын
We use it on our invoices, I’ve never had an explanation why, it seems like a legacy item to me though as they do feel dated.
@Agilebeast21
2 күн бұрын
Hi Kenji, could explain how you would export invoice(s) or a formatted form(loan draw cover sheets, conditional liens, unconditional liens) that kind of works in a reverse order to the data entry to printed area and flows through the log with the data starting in a table/log and runs through row by row where the formulas populate the print area (like your invoice template) and goes through to the next row down and repeats the process until the last line in your log. So new 6 lines of row entries in your log create 6 invoice PDFs? This would really help me in my line of work where I either enter data into a table or log or manipulate data from somewhere else and paste into a log or table and it creates forms in PDFs with a formulaic naming convention.
@kennguru
6 күн бұрын
Maybe my version of excel has a bug as I keep getting referenced back to the invoice spreadsheet even after selecting the columns in the customer spreadsheet...any solutions?
@abdulhamidalhaddadi2255
2 ай бұрын
Great idea, my invoice number as a data validation manually update. my question is: 1. Can I stop duplicated such as, not used again? 2. how can merge this lesson with this lesson "kzitem.info/news/bejne/to6wtaB4gpGLnmU" in one Thank you
@byLokie
4 ай бұрын
Ha. I made this invoice (with my own custom design) for a friend. Followed your instructions and code but when she loaded the invoice onto her laptop the address cells controlled by the xlookup function failed. Turned out her excel version was 2019 so xlookup was not recognised had to use vlookup. But she is happy and is productive.
@Amyayisha
7 күн бұрын
Using Window, Followed everything. Getting an error Run-time error'-2147024773(8007007b) Document not saved. what am i doing wrong? Please help
@younusfarid3947
2 ай бұрын
click sales and print invoice in warehouse automatically. Sale from shop 🛒. Print invoice print to warehouse automatically . 🤔
@aziz10_
3 күн бұрын
thankful for the useful content. and the great work with the montage thing, simple & clean
@matlholelosaba4977
6 ай бұрын
Worked like a charm. Thank you. Now I must just find a way to get it to warn me before overwriting the file.
@KenjiExplains
6 ай бұрын
Thank you for watching :)
@academyofmaths8624
5 ай бұрын
Dear Kenji, you show what I want to do in Excel. I appreciate your effort and the method you present. Stay blessed.
@harrydhinjan7446
4 күн бұрын
hi how can i add button to clear name and amount on merged cells to start new invoice.
@TomStoutPhotography
3 ай бұрын
I am on a Mac, when I try this Excel prints the invoice and doesn't save the invoice. Any suggestions? Here is the code I'm using: path = "Volumes/Invoices/" ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, ignoreprintareas:=False, FileName:=path & fname
@cookingwithfluffytiny4371
9 күн бұрын
How to reverse the invoice fields into excel row data neatly
@sibusisomabhena9952
2 ай бұрын
Hi I Created an invoice form and linked it with the PDF Print Button now I get this error what can I do. Windows("Data Entry.xlsx").Activate
@ojordine5116
2 ай бұрын
This is awesome Kenji.. thank you.. especially the exporting to PDF.. How do you automate the invoice number?
@landryilunga1818
20 күн бұрын
is the invoice number dynamic?
@gova3vardhan
6 ай бұрын
How can I upload any PDF/Word file in a dedicated Excel cell and share the sheet with a team, so they can access the file I uploaded?
@mugerwaferryl213
6 ай бұрын
i like your lessons bro i have learned a lot from you
@KenjiExplains
6 ай бұрын
Thank you!
@jslee1294
6 ай бұрын
I was using Mac that does not work as expected. VB’s file_path command doesn’t work as expected. Can you fix this problem?
@MuhammadAli-su3oo
Ай бұрын
Your content is amazing always. Fast forward but understandable. 1 thing you must tell how can I prevent to generate duplicate Invoice Numbers? Thanks
@LivingGuy484
2 ай бұрын
Can you make a macro that lets you open up the "Save As" dialog box, but in specific folders? I usually press F12 to navigate between my invoice and estimate folders, but it would be somewhat convenient to speed it up a little
@albertocollazo9986
4 ай бұрын
Kenji, thank you for the tutorial. Followed you steps and it works fine producing a .pdf file of the invoice. When I close the the Invoice.xlsm file containing the macro and reopen it in a new Excel session, the macro does not run anymore. In fact the macro appears to run but it does not produce neither any .PDF output nor it gives any errors. Any ideas what the issue could be? Thank you in advance
@Kuwait99
4 ай бұрын
About the invoice number how i can make automatic make list numbers like the first person 1001 second person 1002 and more..
@AshokKumar-hd7pz
5 ай бұрын
Hello Kenji, I am great fan of yours and learned lot of excel formulas by seeing your vedios. Now i need a help hope you would help me in our office we have a daily tracker in that we have 12 agents and works in 24/7 shifts we work on incident tickets as soon as the ticket arrives we have enter the ticket number in that sheet and change the color of the cell manually according to the time the ticket arrived for eg. if ticket came in between 8am to 9 am it will be green if it is between 9 am to 10 am then red if it is between 10 am to 11 am then purple so on so instead of changing the color manually i need a formula or a steps so based on current time when the data entered into a cell the color should change please suggest Thanks, Ashok Kumar B.N
@byLokie
4 ай бұрын
Scuzie the pun but this tutorial is on the money. Thank you For a small business doing 3 to 5 invoices a week. Could you make a new workbook every month and use individual sheets for individual invoices ? So create a new invoice you open the book (Month). Copy last invoice sheet to new sheet. Then make new invoice Oh but I guess the date will change on all sheets created to the newest date opened.
@13mowe
Ай бұрын
👍👍 it's good enough for me . Is there anyway to do macros on android or apple with 365 live ?
@jslee1294
6 ай бұрын
Sadly, my mac does not store file into the directory but print the hard copy through my printer… dang it. Can you help to fix this problem?
@SyedRiaz-m7g
6 ай бұрын
I don't see Xlookup formula in 2016.
@rudylevarity4375
Ай бұрын
Kenji. Awesome as usual. I added an IFERROR. You may want to consider adding some sample projects so enthusiast can build their resume portfolios. I watch you daily. Keep up the awesome work, Sir!
@MoraTara
5 ай бұрын
Hello, thank you for the video. I need help, please What should we do? If the site requires you to log in first, then scrape the data from it after that
@tauqirabbas27
2 ай бұрын
is there any way to create batch printing or batch converting to pdf of all of the invoices?
@dairysmoreta6108
2 ай бұрын
How can i fix the invoice date to reflect month, day, year? the current layout has it as day, month, year > : O
@korysnyi_excel
6 ай бұрын
You can do pdf without macros, just click File/Export
@ExcelPowerPythonHub
5 ай бұрын
Also we can add code in VBA to export ActiveSheet.ExportAsFixedFormat xlTypePDF, ThisWorkbook.Path & "/" & Filename & ".pdf", , , False
@sandyj4766
5 ай бұрын
Hi Kenji, I was following through your steps on inputting the XLOOKUP formula however the value returned was #NAME ERROR even though i followed your instructions exactly. Any advice on this?
@theminista4499
5 ай бұрын
try colon instead of coma or vice versa
@עינבשםטוב-פ7צ
3 ай бұрын
HI DOES IT SUPPORT HEBREEW OR ARABIC-P10X
@christopherdomnic1009
4 ай бұрын
How to get Summary of invoices
@zishanshaikh1451
Ай бұрын
How to do Automate the process of records the product name and price
@ConceptCubes
4 ай бұрын
Hi Kenji, I want to insert product images next to product name in my invoice, Can you please help me with that ? I will be having a sheet named "Products" in which I will manually save allmy products name with their respective images in the next cell.
@joykingsley4830
8 күн бұрын
You can create an extra sheet named products with 2 columns, title one column product name, and the other column product image, then insert each image to its corresponding product name. In the invoice, you will have to add extra columns for the product name and photo. In your product name column in the invoicing sheet, use data validation to make a list (copy and paste from your products sheet) and then use the vlookup fomular in the product image column to automatically fill the corresponding image when a product name is chosen
@germaingyesah5724
3 ай бұрын
I am challenged getting the developer with excel online
@kankiritharan3418
14 күн бұрын
Stay blessed Guruji 🙏
@robparker1625
6 ай бұрын
I would also add the customer’s payment terms and xlookup those too.
@madhawaVJ
4 ай бұрын
VB program not running. no errors. any tip for that ?
@ksh7690
4 ай бұрын
Can I export a data from this instead a pdf?
@ling79790
2 ай бұрын
i need help on doing invoices, can u help me ?
@adamkabango6836
5 ай бұрын
Thumbs up Kenji...... you make things look so easy to do and follow.
@ihabziyad8611
5 ай бұрын
Good job , we need to excel for bookkeeping please
@thirdyleoalmardahilig7237
6 ай бұрын
Marry me Kenji 😘😘😘
@josephbaba111
6 ай бұрын
Thank you Kenji for this, very instructive!
@exceltips.andtricks
5 ай бұрын
❤
@elkiszabala4236
6 ай бұрын
Just Great Keep it up !!!
@KenjiExplains
6 ай бұрын
Thank you for your message, will do!
@vipulagarwal7320
5 ай бұрын
That was dope! Thanks Kenji 💪
@suriyaprakashk3219
4 ай бұрын
Thank you sir
@camlex6310
5 ай бұрын
This is super helpful!! Thanks
@ornelfranck
4 ай бұрын
Nice
@Burnthesof
6 ай бұрын
can you do other way around too? From PDF to excel? E.g we get invoices via e-mail and they need to be saved + put in an excel table
@KenjiExplains
6 ай бұрын
Interesting, I've yet to try but probably there's a way with VBA!
@Burnthesof
6 ай бұрын
@@KenjiExplains would be awesome will save me many hours of work! But haven’t been able to figure it out! But I am no wizard with excel and VNA
@ExcelPowerPythonHub
5 ай бұрын
Using Power Query it is possible kzitem.info/news/bejne/lpWqsaGCf5Zjp6gsi=yQSjuKhcqXIus98h
@ksltechnology
3 ай бұрын
thank you for sharing
@KenjiExplains
3 ай бұрын
Thanks for watching!
@Abdullah_Khaled
5 ай бұрын
God Bless you man!
@Luciano_mp
6 ай бұрын
Good... Thank you.
@abdulsalam935
6 ай бұрын
Sir, how to save the invoice data
@hrugla
5 ай бұрын
Please note that using Excel for invoicing is prohibited in a lot of countries! There is at least in Europe very strong regulations to what kind of software you can use for invoicing.
@XCELRTECHNOLOGY
5 ай бұрын
Reason?
@oliverschulz1623
4 ай бұрын
European regulations demand that finalized invoices cannot be changed after being created. With Excel, you cannot guarantee that, because you can always go back, open the file and change the numbers around. That is why you'll have to use specialized software in a professional setting
@rahma22221
4 ай бұрын
That is why there is export to pdf for reason
@hrugla
4 ай бұрын
@@rahma22221 that is not enough by most EU nations regulations (don't know about rest of the world but I would assume it is the same). The original file is not aloud to be able to changed. The document also HAS to be autonumnerated.
@hrugla
4 ай бұрын
@@XCELRTECHNOLOGY in addition to previous answer sooner countries like France Poland Hungary Italy (and I presume more to come) you have to invoice as e-invoices that is sent directly to government.
@nhiecopaclibare4146
6 ай бұрын
Thank you! Finally! Hahaha! 👏
@KenjiExplains
6 ай бұрын
Thanks for watching :)
@willzinner8813
6 ай бұрын
very interesting thanks
@KenjiExplains
6 ай бұрын
Glad you enjoyed it
@successandlifestyle
6 ай бұрын
Great explanation.
@KenjiExplains
6 ай бұрын
Glad it was helpful!
@shivalikbakshi24
6 ай бұрын
THAT'S SO COOOOL !!!!!!!!
@KenjiExplains
6 ай бұрын
thank you!
@preetshah3793
6 ай бұрын
Make a video on sql
@KenjiExplains
6 ай бұрын
I made one last week check the bio
@preetshah3793
5 ай бұрын
@@KenjiExplains yes I watch your video it's was great video please make more on sql thank you.
@JayJayRonRon
4 ай бұрын
I'm your newly subscriber congrats ! You are so great in excell.... I hope I can learn this exercise 😅
@elliottdavis4306
6 ай бұрын
Anyone have any tips on automating a pdf invoice directly into quickbooks desktop? I’m able to get the pdf details into excel using power automate but I have not been able to import that info into quickbooks desktop
@ConceptCubes
4 ай бұрын
Open QuickBooks and navigate to the File menu Select Utilities, then Import, and click Excel Files If the Add/Edit Multiple List Entries window appears, select NO Follow the wizard in importing files Choose the type of data QuickBooks opens a formatted Excel spreadsheet Enter your data, save the file, and close it You’ll be given the option to Add My Data Now Check results and open Data in QuickBooks Click Close once done
Пікірлер: 105