Automatic Supermarket Billing Software in Excel-Part2 (Coding)| Point of Sale (POS)| Excel Vazhikati

[@ShyamSundar-xi5kf]

Hi uncle. Thanks for the video uncle. It is working well uncle.

[@GaneshK-np8xg]

Excellent video ji..I have earning automation macro coading in recent times...this was very helpful for me... pls do one video how to connect excel to mainframe..like data fetch from mainframe to and pasted in excel with download and excel data will updated to mainframe. how to find the column level in frame for paste.This will very helpful for all..Importantly connection syntax will explain slowly..Pls plan the video with mutiple part.. Also tell about yourself..which degere which office..and how you learn macro coading..give some tips.. Thanks...

[@excelvazhikati]

Thanks for your valuable comment.. i will plan ASAP for this Content

[@starmobiles8888]

super bro VBA error type mismatch 13 varuthu bro eppdi solve pandrathu

[@excelvazhikati]

Full video parunga brother athukana solution athulaye irukku

[@seyedibrahim2787]

Hi anna print connect or off iruntha pdf ah save agala anna athuku enna Panna anna? Please tell

[@excelvazhikati]

Printer selection la Microsoft pdf ah choose panunga brother,pdf ah save aagum

[@seyedibrahim2787]

Anna just print button ah click pannathum direct ah print aguthu apdi ellana print off by nu show aguthu printer selection option show agala na. Show aga enna panrathu anna

[@excelvazhikati]

Just press Ctrl+p, athula printer choose panidunga.. athukaprum print click panna pdf thaan save aagum

[@seyedibrahim2787]

Thank you Anna. And one more error na total amount, totan qty, payment and balance oda input rupees print la show agala anna

[@excelvazhikati]

Rupees symbol show aagalaya ila amout ye show aagalaya brother

[@mohamednizar1952]

Bro this software does not support for thermal printer. How can I make setting for thermal printer

[@excelvazhikati]

You can adjust your paper sizes in print preview section

[@mohamednizar1952]

Bro, I try it but the bill page can not be fixed all only 3 column is possible to fix the paper size rest of the column can not be printed. My printer every come ec 58 (58inches 2inches)

[@fasilrahman4753]

Bro, i need an help as in beginner of the macrons

[@fasilrahman4753]

i need help with this, says .Range("K" & AvailRow) = 1 this one, yellow mark and can't make to next stage of it, what was the mistake bro please help me.

[@excelvazhikati]

This code available in which part of the program

[@karthikfos1]

Excel வழிகாட்டி Hi ji superb learning i have few doubts 1) after save option : payment cell i10 is not cleared, even if i cancel the bill the same value is showing in i10 2) if i use clear option, the items in the invoice is getting cleared but if i do the same action again k12 to p 12 value is also getting deleted, then row 8, then row 7 the same way all rows are getting deleted in the invoice portion 3) if i want to add 10 qty but added 1 qty first, then do i need to enter same product 9times? 4) balance is showing minus value during the bill entry, it has to show only if i enter the payment 5) i have 5 items in the sales list, but if i enter 6 or 7 in the barcode, the invoice getting error with #NA. 6) sales la 1st invoice value ku mattum bill 1 Oda full amt varuthu, next bill ku full total varla, separate item total thaa save aaguthu. how to solve this Kindly advise for this error

[@excelvazhikati]

I will upload another part video with fix these issues and add more features

[@excelvazhikati]

Eathavathu step miss panirupinga brother, Eathaiyum skip panama try panunga

[@harikarthick3616]

Hi bro Sales la kela irruka line la error kamikethu bro.. Sheet3.range(“A” & last row & “:A” & Lastrow -1 + total row)=.range(“m10”).value Intha line la (error 1004 method ‘range’of object ‘work sheet’failed) varuthu Please ethavathu solution sollunga bro.. Additem,clear item Elam finish pannitan…

[@excelvazhikati]

I’m in native brother., Saturday I’ll post Debug code Sorry for the delay

[@harikarthick3616]

Thank you for your reply brother…naa errors clear pannitan bro..Epo part 3 pannitu irruken innum extra features ad pannuga bro…next video la..Credit customers manage panra Mari ethavathu feature add panna mudiyuma nu sollunga broo..

[@excelvazhikati]

Kandippa brother

[@aslamarshad9609]

​@@excelvazhikatiBro how can we add purchase

[@Makalnanban-ho6vu]

in excel sheet 1 la yanga touch panunalum items douple time enter akuthu

[@mohamednizar1952]

Bro, I have an error message that View code selection change If range("d12"). value "" then range("e12"). select end if If range("e12"). value "" then range("g12"). select end if if range("g12"). value " " then range("i12"). select Call add_item end if the problem is the cursor move right and left continually then I got an error message please check it and send me solution.I need the format that if I hit the enter, the cursor move to right side automatically.

[@rajivgandhiprakash5700]

Brother na differently try pan varala bro. na vanthu first Date, S.No, Product Name, quantity,Batch No, Name. Sales la automatic ha save aagala bro coding la error varuthu. Sheet3.Range("A" & Lastrow & ":G" & Lastrow - 1 + Totalrow) = .Range("E" & Firstrow & ":J" & avilrow).Value . entha eadathula varuthu bro. pls help me

[@excelvazhikati]

Kindly contact me on WhatsApp [phone]

[@vimalsidhartha7625]

TYPE MISMATCH 13 VARUTHU Numb = Range("k" & availrow -1).Value+1 Itha line la yellow colour line highlights aguthu error so enna pannaum

[@mayanthemaster7721]

Same

[@dhanapalgovindaraj2112]

Hi bro i have some problem is coming 1. i entered the bill i select the save the bill option amount and qty is correctly saved in sales sheet, but i give the bill to print , print is correctly, but that data is stored in sales sheet is different( Total amount is double the bill amount + no of qty)

[@ShyamSundar-xi5kf]

Uncle but if we add more than 1 items then it is showing and adding a single piece rate uncle

[@ShyamSundar-xi5kf]

What shall I do uncle ?

[@excelvazhikati]

I can’t understand what is the issue.. By my understanding I think you ask about, same item scanned 2time but not added quantity and add another row… Is it right??

[@excelvazhikati]

If above statement is true, Kindly watch part-3 video for the answer

[@ShyamSundar-xi5kf]

No uncle

[@ShyamSundar-xi5kf]

Quantity is added but the total is constant for a single item

[@sabinathb2649]

Bro thermal printer la print varuma

[@excelvazhikati]

Hmm work aagum brother

[@sabinathb2649]

Bro file aa mail Ku send panuvangala

[@excelvazhikati]

Full file send pananum na Pay pananum brother..eathavathu particular place la issue na solunga naan help pandran

[@sabinathb2649]

@@excelvazhikati evlo amount bro

[@excelvazhikati]

Entha Change um illana nenga kudukuratha kudunga brother

[@vimalsidhartha7625]

Hello sir ennku s.no change aga mudiyala same 1 and 1 tha varuthu so help pannugaa

[@excelvazhikati]

Kindly follow steps as given in video.. don't miss any step

[@vimalsidhartha7625]

@@excelvazhikati sir neega sonna Ella step follow panna ellma wrk aguthu ennku neega panna code appdiya send pannuga na mistake enga panna pakkura and try pannra video la enna coding type pannika atha send pannuga Add item Sales Clear bill Print

[@sundarpaper2009]

ProductRow = Range("i12:i999").Find(what:=productname, after:=Range("i12"), lookat:=xlPart, LookIn:=xlValue, searchorder:=xlByRows, searchdirection:=xlPrevious, MatchCase:=False).Row hi i got error in this line the msg showing "productrow=empty" pls explain

[@abdullasardhar5812]

ProductRow = Range("n13:n999").Find(What:=Product, After:=Range("n13"), Lookat:=xlPart, LookIn:=xlValues, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row

[@pavigamer9020]

Without any item if we click cancel bill or clear item the above row is cleared fully for that how to freeze it??

[@excelvazhikati]

Automatic Supermarket Billing Software in Excel (POS)-Part4 Q&A for Comments kzbin.info/www/bejne/f3nLgaWgpq10ms0

[@ulaganathana9451]

I have a dry fruits and nuts retail shop. I have to supply min 50g to 5 kg.. How to comply the same coding..

[@geniustutorials885]

Hi brother you are doing well... I would like to suggest you, please make with VBA problems solution. Also make one part not in 3-4 part...BECAUSE In last 3 part you have changed the column and command. Please make one video with great value

[@excelvazhikati]

I was planned 1part but most of our subscribers feels to be split video so

[@geniustutorials885]

@@excelvazhikati OK you can process with same sheet and describe errors also English language including your language. Thank you for your cooperation and support

[@excelvazhikati]

Ok Brother, thanks for your valuable feedback

[@mohamednizar1952]

Bro, If I select print option then I I will check the sales record the total amount is incorrect and calculate all items and quality column also. Please you check it again Thanks

[@anandannad20]

Super video pro

[@excelvazhikati]

Thanks Brother 🥰

[@rajivgandhiprakash5700]

close panitu open pana work aagamatikuthu ethanala

[@excelvazhikati]

Coding work aagalaya or Excel ye work aagalaya brother

[@pcirmultimedia3352]

Brother , bill no error varuthu

[@excelvazhikati]

Athukana explanation video laye iruku brother skip panama full ah parunga

[@zafirahfathimahr9905]

Bro qty 2 mrp 10 s.Price 10 total 10 can't change Bro total 20 varala

[@excelvazhikati]

Kindly watch part3 for your answer

[@nammaoorusocialmedia1512]

Syntax error kattuthu Sheet3.range ":a" ithu mistake kattuthu

[@logurangasamy2170]

Unga video romba use full ah iruku..but unga video la Quantity change pandrapa total value change agalai..athuku solution kodunga.

[@excelvazhikati]

Kindly check next parts for your doubts

[@balajik.rajagopal800]

Good Evening Bro may i get file format

[@excelvazhikati]

File not for free brother., Step by step tutorial given. If still need you have to pay for excel file.

[@balajik.rajagopal800]

@@excelvazhikati how much bro

[@excelvazhikati]

₹750 brother... without any modification. If anything you want to modify or fully you want to change charges may varry.

[@anandannad20]

Scale ⚖️ wait ulla varatha paththi solluga pro

[@excelvazhikati]

Puriyala brother.. eathula weight varum

[@vimalsidhartha7625]

Quality and price is increased some time how we do coding change price and customer name and details also store means so usefull also

[@excelvazhikati]

I will upload another part from this video to add customer details, Charts and mush more things... and coming to your comment, You can Add or Modify Price or Product name easily in Items Worksheet

[@vimalsidhartha7625]

@@excelvazhikati I try in my laptop I didn't change s.no and Add item coding page I did one error how I correct I didn't know pls help me

[@excelvazhikati]

This is a Coding for Add_item, u can check with this code, and change your Ranges Sub Add_item() Dim AvailRow As Long Dim Numb As Integer AvailRow = Range("M9999").End(xlUp).Row + 1 If Range("f5").Value > 0 Then Range("f9").Value = 1 'Qty End If If Range("M" & AvailRow - 1).Value "Sno" Then Numb = Range("M" & AvailRow - 1).Value + 1 Else: Numb = 1 End If Product = Range("f7").Value Set Search = Range("n13:n999").Find(Product) If Search Is Nothing Then GoTo Add: ProductRow = Range("n13:n999").Find(What:=Product, After:=Range("n13"), Lookat:=xlPart, LookIn:=xlValues, SearchOrder:=xlByRows, SearchDirection:=xlPrevious, MatchCase:=False).Row If Search "" Then GoTo Add1: Add1: Range("O" & ProductRow) = Range("O" & ProductRow) + 1 'Qty Range("R" & ProductRow) = Range("O" & ProductRow).Value * Range("Q" & ProductRow).Value 'Total Range("F5:G5,F9:G9").ClearContents If Range("F5").Value = "" Then GoTo finish: Add: With Sheet1 .Range("M" & AvailRow) = Numb .Range("N" & AvailRow) = .Range("F7").Value 'Item Name .Range("O" & AvailRow) = .Range("F9").Value 'Qty .Range("P" & AvailRow) = .Range("F11").Value 'MRP .Range("Q" & AvailRow) = .Range("F13").Value 'Sales Price .Range("R" & AvailRow) = .Range("F9").Value * .Range("F13").Value 'Total .Range("F5:G5,F9:G9").ClearContents End With finish: End Sub

[@vimalsidhartha7625]

80% na try panna ellma ok achi but last stage la ennku clear bill kudutha coding panna appro clearbill icon click panna appro ennku s.no products name la pochi and na return try pannuvaa 👍

[@excelvazhikati]

Puriyala brother

[@karthikfos1]

Ji waiting for next video!!! Yeppa upload panuvinga?

[@excelvazhikati]

ASAP brother..,

[@karthikfos1]

@@excelvazhikati ji, seekaram adutha video va upload pannunga, 1week aaga poguthu

[@excelvazhikati]

Wednesday upload pandran brother

[@karthikfos1]

Ji.. Wednesday mudunjuthu..

[@excelvazhikati]

Due to personal reasons can't take video.. today Night definitely will upload

[@lastdrop5880]

Best video thumbs up. Thanks for your valuable Tutorial. But one mistake Quantity increase aahum pothu Amount same value la irukke. So amount um increase aahanum athukku eppadi coding eluthuvathu endu sollungo.

[@excelvazhikati]

You can add this code on Sub Add_Item() Add1: Range("O" & ProductRow) = Range("O" & ProductRow) + 1 'Qty Range("R" & ProductRow) = Range("O" & ProductRow).Value * Range("Q" & ProductRow).Value 'Total Range("F5:G5,F9:G9").ClearContents Qty Code already Entered,next line add Total code to rectify the issue

[@excelvazhikati]

kzbin.info/www/bejne/r6HYgJhpYragia8

[@segars2248]

Number button add pannurathu eppadi

[@excelvazhikati]

I will add this option in Upcoming video

[@anandannad20]

Pro PDF LA our bill eduthiga athula total amount varla pro

[@excelvazhikati]

Intha video la irukura sila Corrections and innum sila features oda next video koodiya seekiram upload pandran brother

[@maavaikmvr]

hi ungada video nalla irunthuchu anal athula sinna sinna pilai irukku atha eppadi sari seivathu endu solli tharuvingala

[@educateyourself412]

Enaku run pana bill la varave ila

[@excelvazhikati]

Kindly check full video without skip

[@geniustutorials885]

Can you make one video with English language?

[@vimalsidhartha7625]

All r done bro i do it thanks for your video and if qty is increase means the price is not change for ex we enter 2 qty for 1 qty price is 50 means we enter 2 qty means the price is 100 but there qty is changing but price is not so make a video bro and if one product Is sales means in inventory the qty will be decrease but that not happen in that so pls how we do

[@excelvazhikati]

You can add this code on Sub Add_Item() Add1: Range("O" & ProductRow) = Range("O" & ProductRow) + 1 'Qty Range("R" & ProductRow) = Range("O" & ProductRow).Value * Range("Q" & ProductRow).Value 'Total Range("F5:G5,F9:G9").ClearContents Qty Code already Entered,next line add Total code to rectify the issue

[@vimalsidhartha7625]

@@excelvazhikati qty code is enter in next line I didn't understand how we change the available qty in inventory

[@rockentertainment6908]

Excel file send link kuduga ji

[@excelvazhikati]

Naan innum monetize aagala brother so free ah ipothaiku ennala kudukka mudiyathu sorry

[@achieverselectrical5485]

program sub add error show

[@ravikiranreddy5179]

hi total amount formula error

[@thaminnsr1]

Any one please send part 3 videos

[@excelvazhikati]

kzbin.info/www/bejne/r6HYgJhpYragia8

[@mayanthemaster7721]

Please sent marcos code

[@jmanjunathreddy4226]

🤩🤗🤗

[@anburajmoovendhar992]

Sry to say this... Lot of confusions... And not clearcut definition Bro...

[@excelvazhikati]

Thanks for your feedback brother... If you're a beginner to vba coding u can't understood so.... Poga poga paligidum brother.. enakum starting la apdithaan irunthuthu

[@anburajmoovendhar992]

@@excelvazhikati k Bro.. Any other method to create billing software.??

[@excelvazhikati]

Without vba coding u can't create software in Excel

[@anburajmoovendhar992]

@@excelvazhikati vba coding course upload pandringala Bro?

[@excelvazhikati]

Naan plan paniruken koodiya seekiram start pandran brother

[@VStudios2024]

Bro... indha file...a mail pana mudiyuma. [e-mail]

[@thaminnsr1]

Bro enakum Intha file venum Bro

[@omsakthicomputer5407]

Lastrow = sheets("sales").range("e9999").End(xlUp).Row + 1 Run time error 9 subscript out of range (Comes) Save Bill Error Please Solve The Error...

[@rexyrowdybaby9809]

PLZHELP BELOW SHOWN RUN TIME ERROR 1004 METHOD RANGE OF OBJECT WORKSHEET FAILED FOR BELOW CODE Sheet5.Range("A" & LastRow & ":A" & LastRow - 1 + Total Row) = .Range("L7").ValueRUN TIME ERROR 1004 METHOD RANGE OF OBJECT WORKSHEET FAILED FOR BELOW CODE Sheet5.Range("A" & LastRow & ":A" & LastRow - 1 + Total Row) = .Range("L7").Value

[@Makalnanban-ho6vu]

hi sir, bar code select panuna billing la items two time visiable akuthu please help