How to Save Invoice Data in Excel in Hindi

  Рет қаралды 196,036

PowerEx by Jitendra

PowerEx by Jitendra

Күн бұрын

Пікірлер: 156
@rananouman3853
@rananouman3853 2 жыл бұрын
I never saw this kind of teaching method before about Excel. God bless you Sir! ❤
@nandkishoryadu7908
@nandkishoryadu7908 2 ай бұрын
Thankyou sir me ise ka solution bahot dino se dund raha tha ❤❤
@PowerExbyJitendra
@PowerExbyJitendra 2 ай бұрын
Thanks a lot 👍
@bittujaanmc
@bittujaanmc 11 ай бұрын
Bohut acha example h sir
@prempman
@prempman 3 жыл бұрын
I got it finally what I want... Salute to Google Add sense....and thay to video creator
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
🙏
@prabhakarpawar573
@prabhakarpawar573 3 жыл бұрын
खूप सुंदर आणि खूप उपयुक्त व्हिडीओ आहे सर, tx sir
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thank you so much Prabhakar ji
@nazruddinmi9393
@nazruddinmi9393 Жыл бұрын
Thank you so much sir
@PowerExbyJitendra
@PowerExbyJitendra Жыл бұрын
Welcome🙏 ji
@ronitbohra
@ronitbohra Жыл бұрын
Hello Sir, I Have Made A Excel Invoice As You Guided, But I Have A Small Question Can We Assign All This Macros In 1 Single Button, Like I Want The Data Of Invoice To Be Saved On Another Sheet, With The Simultaneous Print Commannd, Save As Pdf Command & New Invoice Command, Please Help
@bilalrazaabdulrauf3203
@bilalrazaabdulrauf3203 3 жыл бұрын
good job boss!!! is there any way to prefix any unique code for invoice number and if we will add print and save command will data still save like now
@SunnyKumar-bb9tr
@SunnyKumar-bb9tr 3 жыл бұрын
Good job 👌
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks Sunny
@single1602
@single1602 6 ай бұрын
Very effective 🎉
@PowerExbyJitendra
@PowerExbyJitendra 6 ай бұрын
Thanks a lot
@ShanVijay007
@ShanVijay007 3 жыл бұрын
Thank u very much sir 😀🤩
@sharwansinghrajpurohit
@sharwansinghrajpurohit 3 жыл бұрын
Awesome 🙏👍👍😘
@umairayubi5262
@umairayubi5262 8 ай бұрын
Helpful video was this
@Sheik41
@Sheik41 2 жыл бұрын
Very humble teaching sir 🙏 நன்றி 👍
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Thanks for your lovely comment
@Sheik41
@Sheik41 2 жыл бұрын
@@PowerExbyJitendra sir,2 line of record not stored .only first record is storing
@usmanfayyaz1549
@usmanfayyaz1549 2 жыл бұрын
Sir please make a video for pharmacy business.
@RafijurRahman
@RafijurRahman Жыл бұрын
Hello, your this video is very helpful. I have an additional query, is it possible to print the saved invoices from current position?
@udaykakde4595
@udaykakde4595 Жыл бұрын
Sir great information but zero in the invoice also should not be there so what is the formula?
@purnachandrajena4235
@purnachandrajena4235 5 ай бұрын
Good teaching and not clear video.
@PowerExbyJitendra
@PowerExbyJitendra 5 ай бұрын
Sorry for that
@deepakdalal8731
@deepakdalal8731 3 жыл бұрын
Very good sir.jii
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thank you Deepak ji
@syedmazharhussainshah5268
@syedmazharhussainshah5268 3 жыл бұрын
Very good
@deepakbhanushali1
@deepakbhanushali1 2 жыл бұрын
agar ho old invoice mai kuch change hogo or edit kar na ho to ?
@rajikulislam9360
@rajikulislam9360 Жыл бұрын
Lookup formula use karke kar sakte ho
@ADILTRAVEL-k9m
@ADILTRAVEL-k9m Жыл бұрын
اسلام علیکم ورحمتہ اللہ وبرکاتہ
@PowerExbyJitendra
@PowerExbyJitendra Жыл бұрын
Sorry I could not read your comment.
@Bharatiya_Brothers
@Bharatiya_Brothers 2 жыл бұрын
Sir please tell me a way to edit older bills other than editing in datasheet please find any way to do it easily
@shaharyarahmed6124
@shaharyarahmed6124 Жыл бұрын
Sir kindly make a video for multiple creteria and get data multiple matches
@s-tech3176
@s-tech3176 2 жыл бұрын
any one face problem, you must click Ctrl button plus down row the frist time only and then just use right arrow without Ctrl button . it will work fine
@shamjishamji361
@shamjishamji361 3 жыл бұрын
Very nice sir
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks ji
@aiyahsonlineshop965
@aiyahsonlineshop965 6 ай бұрын
hi, I've tried this formula for my purchase order form the recording was successful, except the data or details saves in the same cell spot/row only. how can i fix this. thank you.
@spn360
@spn360 Жыл бұрын
Sir, In this video while recording macros you are copying data from a single cell in Sheet1 and pasting in a single cell in Sheet2. But my question if---- The data is in Merged Cell in Sheet1 how to copy it to a single cell in SHeet2 while recording macros.
@Timexworld217
@Timexworld217 3 жыл бұрын
Mobile apps excel me b Bana do sir
@hiteshjangid572
@hiteshjangid572 Жыл бұрын
Sir kya ye save data button exe 2007 me ban sakta h kya. Kyoki usme 1 sheet se 2 sheet par jakar work nahi ho pa raha, please reply🙏🙏
@aadityadas
@aadityadas Жыл бұрын
Sir, how to generate sales data from sales invoice wrt products and their quantities?
@pksirknowledge
@pksirknowledge 3 жыл бұрын
Multiple item ke liye bataiye ki save data kaise hoga
@vismeetbhawar4102
@vismeetbhawar4102 Жыл бұрын
How can get the format be protected so that no changes can be made by the user? Except automated generated or data entry
@arvindawasthi8710
@arvindawasthi8710 3 жыл бұрын
Very good 👍
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks Bhai
@a4aj553
@a4aj553 Жыл бұрын
Sir agar monthly wise karni ho save
@abdulsalam935
@abdulsalam935 6 ай бұрын
Sir how to save more than one record of products purchased by a customer in database. U have shown only one record.
@vaseemirfan9401
@vaseemirfan9401 3 жыл бұрын
Hi good nice work, but i need help, if multiple particular with same invoice and date hoe we have to save data. Please confirm as soon as possible
@viswanathancr2801
@viswanathancr2801 3 жыл бұрын
good video
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks Bro
@rizwanahmed6060
@rizwanahmed6060 Жыл бұрын
Sir plz upload 1st chapter of this video Thaks
@keshabmaity9436
@keshabmaity9436 Жыл бұрын
Kisi invoice mai two or three or eshe above items hoga toh vo kaise save hoga ? Please batao
@santoshdengle5024
@santoshdengle5024 Жыл бұрын
Sir kya aap pdf bhi automatically save honi chahiye aisa video bana sakte hien
@catanmaypatra4648
@catanmaypatra4648 3 жыл бұрын
Dear sir, please make a video on GST invoices (multiple rates) and auto save the details of that invoice rate-wise
@rupendersharma975
@rupendersharma975 Жыл бұрын
Sir product ki jagah par aap bill format iss tarah se banaie ki SRN CNS NO PARTY CNS NO FROM TO. WT RATE HAMALI PARTY HAMALI TOTAL
@sanjeevsharma-yd7pm
@sanjeevsharma-yd7pm 2 жыл бұрын
agar hme jo items hai unko kaise krenge agar items 10 hui to
@ADILTRAVEL-k9m
@ADILTRAVEL-k9m Жыл бұрын
May the peace, the mercy, and the blessings of Allah be upon you
@PowerExbyJitendra
@PowerExbyJitendra Жыл бұрын
Same to you my friend
@baharali7429
@baharali7429 3 жыл бұрын
Sir is invoice k sath Jo Button banae hean un ka bhi print sath nikal ata he matalb aik page py invoice dosry page py wo Button print Hojaty hein in ka koe Hal batin plz
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Aap macro record karne se pahle page setup kar lijiye fir nahi hoga
@baharali7429
@baharali7429 3 жыл бұрын
@@PowerExbyJitendra Sir Phely macri recoard kar liya ab ye problem aa raha he kia mujhy dobara macro recoard karna pary ga.
@shubhadas2142
@shubhadas2142 3 жыл бұрын
@@baharali7429 page layout ja kar print area set kariye
@muneeswaranmari4564
@muneeswaranmari4564 3 жыл бұрын
Great job. How I modify the invoice
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
you may modify manually
@amiralicharania5324
@amiralicharania5324 3 жыл бұрын
How to add more brands in one invoice pls instruct
@biswajitray5850
@biswajitray5850 3 жыл бұрын
Customers ke product details kaha store hota hai...ek customer multiple product khoti da to o sari product kaha milege
@mohamedafzer6719
@mohamedafzer6719 Жыл бұрын
Can i get this template please?
@prajapati-ajay224
@prajapati-ajay224 3 жыл бұрын
Sir mujhe data sheets me particular bhi add karna he ek se jyada to kese kare.
@qamarjafri9283
@qamarjafri9283 Жыл бұрын
How can save all items quantity of invoice on another sheet
@syedtafiq7972
@syedtafiq7972 2 жыл бұрын
hello sir. mera data ik hi row mai save hojata hai . invoice ki details change kar kya bhi backup sheet me same row ma data ajata hai.
@rosomoybordoloi5826
@rosomoybordoloi5826 3 жыл бұрын
One issue. After running macro the data overwrite in same row, only date column working fine.
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Please use 'Use Relative References' while pasting
@rosomoybordoloi5826
@rosomoybordoloi5826 3 жыл бұрын
@@PowerExbyJitendra I did exactly the same u shown in video. But except the date all data are overwritten.
@pathanrageeb
@pathanrageeb 3 жыл бұрын
Same issue with me , any solutions?
@syedtafiq7972
@syedtafiq7972 2 жыл бұрын
same problem with my data
@addictingpink17
@addictingpink17 2 жыл бұрын
Same problem
@AqeelAhmed-d6i
@AqeelAhmed-d6i Жыл бұрын
new invoice k lye error 13 type mismatch ka error a jata hai kindly guide me how to correct?
@BharatKumar-fh7ei
@BharatKumar-fh7ei 3 жыл бұрын
In amount coloumn how to hide '0' when 'particular' coloumn are blank.
@baharali7429
@baharali7429 3 жыл бұрын
Sir is in voice ka pdf formate m save kany ka bhi Video bany lpz ya
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Ok ji
@alizasarker4374
@alizasarker4374 2 жыл бұрын
When I press this Ctrl+alt+v there doesn't show this paste special all options. How can I enable this.... For this problem I can not work.... Please sir tell me😥
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Please Use Paste Special manually
@alizasarker4374
@alizasarker4374 2 жыл бұрын
Thank you sir. Sir I want to know another thing from you....how can I find old invoice information by search....if I search with invoice no and than all information will be show invoice form...How cal I do this sir? Is there any way? If you have any vedio in this topic please tell me sir....if you don't have any vedio in this this topic please do it sir.... It will be helpful for us.... Thank you sir
@SehrawatFitHealth
@SehrawatFitHealth 3 жыл бұрын
nice
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks bro
@yogeshbelvalkar
@yogeshbelvalkar 11 ай бұрын
sIRJI tHANKS
@nagaraju-yz1qb
@nagaraju-yz1qb 2 жыл бұрын
Sir address ka drown kaise karna
@tamulmilk
@tamulmilk 6 ай бұрын
Data store by assign macro but show only one row, data doesn't store row by row How to data store row by row please help me?
@eduinlight9082
@eduinlight9082 3 жыл бұрын
Sheet 2 ka upyog???
@hritikraj4010
@hritikraj4010 2 жыл бұрын
Not working save data can you help me sir
@ruhaibmalik8247
@ruhaibmalik8247 2 жыл бұрын
This method only adding one line and reset again. But more value table not adding in the rows and columns
@Jarmy95
@Jarmy95 8 ай бұрын
Did you manage to fix this problem bro
@superintendenttalala5623
@superintendenttalala5623 3 жыл бұрын
Superb sir but when i press ctrl+down arrow then cursor goes to last cell not down cell
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Please watch carefully
@deeprajsinghsisodiya8004
@deeprajsinghsisodiya8004 10 ай бұрын
Sir maine coulomb A , B ko merge kiya hai pr new invoice karne main error aa ra
@allaiba.R
@allaiba.R 3 жыл бұрын
sir ji mera vba code kaam nahi ker raha hai hamesha erorr araha hai please help karo sir
@mohdsalman5754
@mohdsalman5754 3 жыл бұрын
agar kisi saved invoice ko edit krna ho to kaise krenge
@sarjeraonikam693
@sarjeraonikam693 Жыл бұрын
How Detail Bill With All Item Save & How it Detail bill view when Party name is selected if party purchase no of time with diff. Date & Invoice
@sanjeevsharma-yd7pm
@sanjeevsharma-yd7pm 2 жыл бұрын
Agar line 1 se jayada hogi tb kaise krenge
@kishankumarsingh2001
@kishankumarsingh2001 5 ай бұрын
Ye batao
@EnjamulBiswas
@EnjamulBiswas 3 жыл бұрын
Yeh office 2007 pe kaam karega??
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Enjamul ji If you are a excel lover please upgrade it. You will feel the difference
@shubhadas2142
@shubhadas2142 3 жыл бұрын
Kam toh karna chahiye
@PankajSingh-cy4zs
@PankajSingh-cy4zs 2 жыл бұрын
Hi sir hame kuchh probalam Rahi h
@ayanmalik6826
@ayanmalik6826 2 жыл бұрын
Microsoft Office ka kain version hai ye
@SkillswithJawahir
@SkillswithJawahir 9 ай бұрын
Particulars Kiun Save nai ho rahy bhai ..?
@mudalivenky1957
@mudalivenky1957 9 ай бұрын
यदि हर आईटम जा जी.एस.टी. रेट अलग हो तो क्या करें ?
@anilkumar-uc9tt
@anilkumar-uc9tt 10 ай бұрын
Sir can u give same this software to me
@naseemahmad8902
@naseemahmad8902 Жыл бұрын
Online kam karne ke liye website Kaise banaen
@Yashkumar31938
@Yashkumar31938 3 жыл бұрын
Ek hi invoice me delivery note or proforma invoice kaise banaye or pdf me kaise save kare save d file me Hona chahiye
@PREMKUMAR-wb5lj
@PREMKUMAR-wb5lj 3 жыл бұрын
Sheets 2 how make
@3007ash
@3007ash Жыл бұрын
Debug error coming, ActiveCell.Offset(1, 0).Range("A1").Select
@binarytechsolution4500
@binarytechsolution4500 Жыл бұрын
The address of Ghanta Ghar Meerut is in my Neighbour coz I'm also from Meerut 😅😅
@santdnyaneshwar9920
@santdnyaneshwar9920 Жыл бұрын
Sir, Save Data ko 2-4 time lagatar click karenge to sab wrong ho jayega... same row update nahi hoga.. karke dekho... video tutorial bhi perfect hona chahiye....
@epfoconsultancyhyderabad1784
@epfoconsultancyhyderabad1784 9 ай бұрын
Applay table format
@jayantabhowmick3907
@jayantabhowmick3907 3 жыл бұрын
1 problem ha sir. Agar further invoice ko dekhna ha to kaya karange ?
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
PDF mai save karke rakh sakte hai
@THERAVITECHNICAL
@THERAVITECHNICAL 3 жыл бұрын
Aur edit karna ho to
@shubhadas2142
@shubhadas2142 3 жыл бұрын
@@THERAVITECHNICAL XPS me save kar sakte hain
@Bharatiya_Brothers
@Bharatiya_Brothers 2 жыл бұрын
@@shubhadas2142 will it change in data sheet sir
@Akku786khan
@Akku786khan 2 жыл бұрын
Yah banane ke bad dobara kholne per Kam nahin karta hai kyon
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Please save file as Macro Enabled Workbook then it will work
@sunilsuwal4812
@sunilsuwal4812 3 жыл бұрын
final workbook Please...
@biplabkalita477
@biplabkalita477 3 жыл бұрын
Kya aap banakar bhi dete hain
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Nahi Biplab ji
@storyworld724
@storyworld724 2 жыл бұрын
is file mai to koi macro ni h
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Please follow video instructions and record macro
@Yashkumar31938
@Yashkumar31938 3 жыл бұрын
How to save invoice by company name and invoice no both in pdf ,please provide me VBA code
@faizanbasharat6899
@faizanbasharat6899 Жыл бұрын
Down arrow ki samj nahi arahi
@vimalmathura8999
@vimalmathura8999 2 жыл бұрын
not working sir
@amitmishra1513
@amitmishra1513 3 жыл бұрын
How to convert excel this Invoice with data into html page on button clicked??
@pkshah2606
@pkshah2606 3 жыл бұрын
Aap ne video to acha banaya hai lekin adhura hai. Aap add or save karna batate ho lekin wohi sheet me duplicate na ho uske liye kya karna hai wo nahi batate to fir fayda kya. Agar duplicate ho jayega kaise maloom padega.
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
iske liye aap conditional formatting ka istemal kar sakte hai
@pkshah2606
@pkshah2606 3 жыл бұрын
@@PowerExbyJitendra sir maine wo bhi try kiya lekin relative reference hone ki vajase nahi hua.lekin conditional formatting VBA code me kaise denge pata nahi. Agar aap wo bata sake to it will be good for me & others
@CHHEDILAL261
@CHHEDILAL261 3 жыл бұрын
plz this video download link
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Ji Yadav ji
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
drive.google.com/file/d/1pErcf5iRC6okGBMwW3Fro7QYbS6l5C3U/view?usp=drivesdk
@naseemahmad8902
@naseemahmad8902 Жыл бұрын
Online kam karne ke liye
@abhichauhan7384
@abhichauhan7384 3 жыл бұрын
Pdf me kaise save karenge sir
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thoda wait kar lijiye
@RuchiSharma
@RuchiSharma 3 жыл бұрын
@@PowerExbyJitendra Thoda wait krne se pdf me save hojata kya sir ?😂
@RakeshKumar-cs1mn
@RakeshKumar-cs1mn 3 жыл бұрын
Formula bhi to bataye
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Rakesh ji last video mai formulas bhi bataye gaye hai aur yadi aap lag se dekhna chahte hai to 1. Vlookup kzbin.info/www/bejne/f5CWZJ2Ch9uko7M 2. Drop down list kzbin.info/www/bejne/j4KoeJ-XnM2neKs
@yameenabbasi227
@yameenabbasi227 3 жыл бұрын
Ye sab krne k bAd pc restart kro to tmAm butn dis@bLe hoj@te he Ky@ krye,,.......
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Dear Yameen, You will have to save this excel file as "Excel Macro Enabled Workbook"
@qamarjafri9283
@qamarjafri9283 Жыл бұрын
same data over written
@totalkids9723
@totalkids9723 3 жыл бұрын
Sir aapka contact number chahiye thoda sajetion ke liye
Fully Automated Invoice Generate with Database and PDF of invoice in Excel 2023
37:09
Learn MS Skills with Faizan
Рет қаралды 102 М.
Sigma baby, you've conquered soap! 😲😮‍💨 LeoNata family #shorts
00:37
ЗНАЛИ? ТОЛЬКО ОАЭ 🤫
00:13
Сам себе сушист
Рет қаралды 2,6 МЛН
Kluster Duo #настольныеигры #boardgames #игры #games #настолки #настольные_игры
00:47
Всё пошло не по плану 😮
00:36
Miracle
Рет қаралды 3,8 МЛН
Fully Automated GST Invoice in Excel with Auto Save PDF and Data Backup
46:51
Sigma baby, you've conquered soap! 😲😮‍💨 LeoNata family #shorts
00:37