How to Create A Stylish Invoice and Billing System in Excel

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

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

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.

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

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

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

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?

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

kindly help

Sir,
Please share practice file.

sir we need your this pos

sir we need your pos

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

Awesome tutorial... Clear explaination!!!