How to Create A Stylish Invoice and Billing System in Excel

[@ContemporaryW]

I am a beginner... thank you so much sir

[@happy-life5]

Thank you for sharing the video. I can learn a lot functions from the tutorial. Keep going! 👍

[@bigboss-ph3bu]

Sir very useful I loved it

[@กากาแาแาก]

How can u create delete button that when u delete selected rows that it delete only text in sales receipt not the hole whole row

[@vivekjain8793]

Hi sir, may you halp me for when i scan product and show product name which filled in next row. What is tha formula?

[@happyhaus7417]

Awesome tutorial... Clear explaination!!!

[@burhonburhonov9711]

Hi my delete button is deleted my whole rows not only my sales receipt but Also my button's side

[@LesibaMaphoso-j6d]

Hi Sir. This tutorial attracted me. Good and educational. I just got stuck when I have to do "Control+Shift+Down button" and typing "LastCel" in the cell. When I go to View and Immediate WIndow + question, it reveals that my next empty cell is "10" instead of "12". All procedure followed.

[@excel-tutorial]

Hi, Thank you for watching my tutorial. First, I assume that "LastCel" = "LastCell". Second guess would be that there is no values from your last cell untill "LastCell", inbetween cells. If both are correct, I cannot guess the root cause. Maybe, run line by line. check whether or not it print the value correctly in the cells.

[@LesibaMaphoso-j6d]

Data reflects in K10 and K11 once. From there it reflects again in K10 and does not move to the next column (K11) and further, therefore maintaining that the Product (K9) is always the Offset. Oh! how I wish I can bridge this. I like this program a lot.

[@gerancemdm3747]

Best video, best teacher I'm really satisfied for all this job cell names make the difference Thank's

[@eduardogonzalez5400]

Thank you for sharing it. It helped me remember exel. I have a question. How can I print in a thermal matrix printer?

[@LesibaMaphoso-j6d]

This is my coding: Sub Shoping_Basket() rowNum = [LastCell].End(xlUp).Row + 1 'MsgBox "Testing" Range("K" & rowNum) = [Product_Name] Range("M" & rowNum) = [Price] Range("L" & rowNum) = [Quantity

[@AmeerShaw]

hello, every time i download the file it says that the macros aren't available is that an issue from my side or are you not giving them away?

[@AkashaRaj-pd2mz]

sir we need your this pos

[@nix-x8s]

How can I fix the error "Method 'range of object'_Worksheet' failed while debugging this code If Dir(Sheet2.Range("D" & [Product_ID] + 1).Value, vbDirectory) "" Then?? I keep getting that error

[@gayustambunan6250]

This is so cool 🏆🏆

[@mpl5070]

Can you show how to do payment for visa please?

[@upierre6218]

Hi, thanks for your time and your teaching methods. But I have got some challenges: 1. How do you coding VBA such as: IF RANGE NOT EMPTY THEN EXIT SUB? 2. FOR CORRECTION SUB; HOW TO SOLVE THE ISSUES WHERE SOME VALUE HAVE BEEN LOADED BY VLOOKUP FORMULA? HOW TO INSERT VLOOKUP FORMULA INTO VBA CODES?

[@excel-tutorial]

Hi UPierre, Thanks a lot for your comments. 1. How do you coding VBA such as: IF RANGE NOT EMPTY THEN EXIT SUB? If [name box] "" Then Exit Sub You can use the RANG instead of [name box]. 2. I think that it would be a good idea: not mix between worksheet formula and vba code at the same time. So, the below one would be one of possible options. HOW TO INSERT VLOOKUP FORMULA INTO VBA CODES? Application.WorksheetFunction.VLookup(a, b, c) a,b,c would be the same manner as the normal VLOOKUP FORMULA parameters. Have a nice day...

[@lavishluxury7875]

Hi can we have the template please

[@qhelaniqhelani9060]

Hie. Thanks for the tutorial. My "store and next sub" is multiplying all the receipt data by 9 kindly help

[@excel-tutorial]

Hi there, Thanks a lot for your comment. Please find the following code below. I hope that this might help you out. Sub Store_and_Next() rowNum2 = [LastCell2].End(xlUp).Row + 1 rowNum = [LastCell].End(xlUp).Row all_Item = rowNum - 9 'Grabbing Receipt info into Sale History sheet 'i.e. Select Range "A2:A9" Sheet3.Range("A" & rowNum2 & ":A" & rowNum2 + all_Item - 1).Value = [Receipt_Num] Sheet3.Range("B" & rowNum2 & ":B" & rowNum2 + all_Item - 1).Value = [Date] Sheet3.Range("C" & rowNum2 & ":C" & rowNum2 + all_Item - 1).Value = [Cashier] 'All Other Product Sale information Sheet3.Range("D" & rowNum2 & ":G" & rowNum2 + all_Item - 1).Value = Sheet1.Range("K10:N" & rowNum).Value 'Hide the Foot Note On Error Resume Next Sheet1.Shapes.Range(Array("FootNote")).Select Sheet1.Shapes.Range(Array("FootNote")).Visible = msoFalse 'Clean-up existing inputs [All_Receipt].ClearContents Call Clear_Settings Sheet1.Shapes.Range(Array("Selected_Picture")).Select Selection.Delete 'New Receipt Number [Receipt_Num] = WorksheetFunction.Max([All_Row2]) + 1 ActiveWorkbook.RefreshAll End Sub

[@rajibhasan8883]

Sir, Please share practice file.

[@excel-tutorial]

Hi Rajib Hasan, Thank you for your comment. You can find the link for downloading the practice file for the tutorial in description part.

[@AkashaRaj-pd2mz]

sir we need your pos

[@excel-tutorial]

Hi Akasha Raj, Thank you for your comment. You can download the practice file for this tutorial in the description section.

[@profitsdaily9]

"If you do what you always did, you will get what you always got." _Anonymous

[@TonyLaforest-m9m]

Hi, I watched your video and found it very interesting. I would like to "Buy you a Coffee" and obtain your application and the accompanying files but do you have another method of payment besides Visa. Do you have an email address I can etransfer to

[@bishwajitmadhubisu1427]

Hi Sir. This tutorial attracted me. Good and educational. I just got stuck when I have to do "Control+Shift+Down button" and typing "LastCel" in the cell. When I go to View and Immediate WIndow + question, it reveals that my next empty cell is "10" instead of "12". All procedure followed