How to Save Invoice Data in Excel in Hindi

  Рет қаралды 199,786

PowerEx by Jitendra

PowerEx by Jitendra

Күн бұрын

Пікірлер: 162
@rananouman3853
@rananouman3853 2 жыл бұрын
I never saw this kind of teaching method before about Excel. God bless you Sir! ❤
@bittujaanmc
@bittujaanmc Жыл бұрын
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 жыл бұрын
🙏
@nandkishoryadu7908
@nandkishoryadu7908 3 ай бұрын
Thankyou sir me ise ka solution bahot dino se dund raha tha ❤❤
@PowerExbyJitendra
@PowerExbyJitendra 3 ай бұрын
Thanks a lot 👍
@prabhakarpawar573
@prabhakarpawar573 4 жыл бұрын
खूप सुंदर आणि खूप उपयुक्त व्हिडीओ आहे सर, tx sir
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thank you so much Prabhakar ji
@nazruddinmi9393
@nazruddinmi9393 2 жыл бұрын
Thank you so much sir
@PowerExbyJitendra
@PowerExbyJitendra 2 жыл бұрын
Welcome🙏 ji
@reliablemerchant7641
@reliablemerchant7641 4 күн бұрын
Good , main issue not addressed Sir, that is I need data base with all items that are in invoice Particular section so that I have full details of items sold in a month kindly share your thoughts and if you have address this option in other videos kindly share link thanks for good video
@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
@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
@SunnyKumar-bb9tr
@SunnyKumar-bb9tr 4 жыл бұрын
Good job 👌
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thanks Sunny
@ShanVijay007
@ShanVijay007 3 жыл бұрын
Thank u very much sir 😀🤩
@usmanfayyaz1549
@usmanfayyaz1549 2 жыл бұрын
Sir please make a video for pharmacy business.
@sharwansinghrajpurohit
@sharwansinghrajpurohit 3 жыл бұрын
Awesome 🙏👍👍😘
@umairayubi5262
@umairayubi5262 9 ай бұрын
Helpful video was this
@single1602
@single1602 7 ай бұрын
Very effective 🎉
@PowerExbyJitendra
@PowerExbyJitendra 7 ай бұрын
Thanks a lot
@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
@Timexworld217
@Timexworld217 3 жыл бұрын
Mobile apps excel me b Bana do sir
@pksirknowledge
@pksirknowledge 3 жыл бұрын
Multiple item ke liye bataiye ki save data kaise hoga
@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
@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
@purnachandrajena4235
@purnachandrajena4235 7 ай бұрын
Good teaching and not clear video.
@PowerExbyJitendra
@PowerExbyJitendra 6 ай бұрын
Sorry for that
@udaykakde4595
@udaykakde4595 Жыл бұрын
Sir great information but zero in the invoice also should not be there so what is the formula?
@shaharyarahmed6124
@shaharyarahmed6124 Жыл бұрын
Sir kindly make a video for multiple creteria and get data multiple matches
@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?
@deepakdalal8731
@deepakdalal8731 3 жыл бұрын
Very good sir.jii
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thank you Deepak ji
@syedmazharhussainshah5268
@syedmazharhussainshah5268 3 жыл бұрын
Very good
@MrPrabhas03
@MrPrabhas03 3 күн бұрын
hello Sir mujhe purchase bill or sales bill jisme multiple item hain unke stock ki inventory kese ker saku jyada me 1-1 item ke baare me bataya he
@a4aj553
@a4aj553 Жыл бұрын
Sir agar monthly wise karni ho save
@sanjeevsharma-yd7pm
@sanjeevsharma-yd7pm 2 жыл бұрын
agar hme jo items hai unko kaise krenge agar items 10 hui to
@aadityadas
@aadityadas Жыл бұрын
Sir, how to generate sales data from sales invoice wrt products and their quantities?
@shamjishamji361
@shamjishamji361 4 жыл бұрын
Very nice sir
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thanks ji
@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
@yogeshbelvalkar
@yogeshbelvalkar Жыл бұрын
sIRJI tHANKS
@amiralicharania5324
@amiralicharania5324 3 жыл бұрын
How to add more brands in one invoice pls instruct
@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🙏🙏
@rizwanahmed6060
@rizwanahmed6060 Жыл бұрын
Sir plz upload 1st chapter of this video Thaks
@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
@nagaraju-yz1qb
@nagaraju-yz1qb 2 жыл бұрын
Sir address ka drown kaise karna
@ADILTRAVEL-k9m
@ADILTRAVEL-k9m Жыл бұрын
May the peace, the mercy, and the blessings of Allah be upon you
@PowerExbyJitendra
@PowerExbyJitendra Жыл бұрын
Same to you my friend
@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?
@muneeswaranmari4564
@muneeswaranmari4564 4 жыл бұрын
Great job. How I modify the invoice
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
you may modify manually
@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
@keshabmaity9436
@keshabmaity9436 Жыл бұрын
Kisi invoice mai two or three or eshe above items hoga toh vo kaise save hoga ? Please batao
@arvindawasthi8710
@arvindawasthi8710 4 жыл бұрын
Very good 👍
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thanks Bhai
@viswanathancr2801
@viswanathancr2801 3 жыл бұрын
good video
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Thanks Bro
@ADILTRAVEL-k9m
@ADILTRAVEL-k9m Жыл бұрын
اسلام علیکم ورحمتہ اللہ وبرکاتہ
@PowerExbyJitendra
@PowerExbyJitendra Жыл бұрын
Sorry I could not read your comment.
@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
@baharali7429
@baharali7429 3 жыл бұрын
Sir is in voice ka pdf formate m save kany ka bhi Video bany lpz ya
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Ok ji
@eduinlight9082
@eduinlight9082 3 жыл бұрын
Sheet 2 ka upyog???
@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 3 жыл бұрын
same problem with my data
@addictingpink17
@addictingpink17 2 жыл бұрын
Same problem
@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 9 ай бұрын
Did you manage to fix this problem bro
@prajapati-ajay224
@prajapati-ajay224 3 жыл бұрын
Sir mujhe data sheets me particular bhi add karna he ek se jyada to kese kare.
@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.
@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
@aiyahsonlineshop965
@aiyahsonlineshop965 7 ай бұрын
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.
@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
@qamarjafri9283
@qamarjafri9283 Жыл бұрын
How can save all items quantity of invoice on another sheet
@mohdsalman5754
@mohdsalman5754 3 жыл бұрын
agar kisi saved invoice ko edit krna ho to kaise krenge
@syedtafiq7972
@syedtafiq7972 3 жыл бұрын
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.
@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
@hritikraj4010
@hritikraj4010 3 жыл бұрын
Not working save data can you help me sir
@ayanmalik6826
@ayanmalik6826 2 жыл бұрын
Microsoft Office ka kain version hai ye
@PREMKUMAR-wb5lj
@PREMKUMAR-wb5lj 3 жыл бұрын
Sheets 2 how make
@sanjeevsharma-yd7pm
@sanjeevsharma-yd7pm 2 жыл бұрын
Agar line 1 se jayada hogi tb kaise krenge
@kishankumarsingh2001
@kishankumarsingh2001 7 ай бұрын
Ye batao
@BharatKumar-fh7ei
@BharatKumar-fh7ei 3 жыл бұрын
In amount coloumn how to hide '0' when 'particular' coloumn are blank.
@allaiba.R
@allaiba.R 3 жыл бұрын
sir ji mera vba code kaam nahi ker raha hai hamesha erorr araha hai please help karo sir
@anilkumar-uc9tt
@anilkumar-uc9tt 11 ай бұрын
Sir can u give same this software to me
@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
@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
@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
@SehrawatFitHealth
@SehrawatFitHealth 4 жыл бұрын
nice
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thanks bro
@deeprajsinghsisodiya8004
@deeprajsinghsisodiya8004 Жыл бұрын
Sir maine coulomb A , B ko merge kiya hai pr new invoice karne main error aa ra
@binarytechsolution4500
@binarytechsolution4500 Жыл бұрын
The address of Ghanta Ghar Meerut is in my Neighbour coz I'm also from Meerut 😅😅
@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
@abdulsalam935
@abdulsalam935 7 ай бұрын
Sir how to save more than one record of products purchased by a customer in database. U have shown only one record.
@AqeelAhmed-d6i
@AqeelAhmed-d6i Жыл бұрын
new invoice k lye error 13 type mismatch ka error a jata hai kindly guide me how to correct?
@patelbakul52
@patelbakul52 11 күн бұрын
S.No automatic fill kaise krte hai
@PowerExbyJitendra
@PowerExbyJitendra 10 күн бұрын
I have a separate video on it please watch
@patelbakul52
@patelbakul52 9 күн бұрын
Ho gaya sir Thank you ❤️
@jayantabhowmick3907
@jayantabhowmick3907 4 жыл бұрын
1 problem ha sir. Agar further invoice ko dekhna ha to kaya karange ?
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
PDF mai save karke rakh sakte hai
@THERAVITECHNICAL
@THERAVITECHNICAL 4 жыл бұрын
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
@casimnazir
@casimnazir 11 күн бұрын
How do we avoid saving the blank invoice? The invoice shouldn't be saved if any cell of the invoice is empty and how we can add the saved invoice data into the invoice format instead of PDF
@SkillswithJawahir
@SkillswithJawahir 11 ай бұрын
Particulars Kiun Save nai ho rahy bhai ..?
@sunilsuwal4812
@sunilsuwal4812 3 жыл бұрын
final workbook Please...
@tamulmilk
@tamulmilk 8 ай бұрын
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?
@mudalivenky1957
@mudalivenky1957 10 ай бұрын
यदि हर आईटम जा जी.एस.टी. रेट अलग हो तो क्या करें ?
@biplabkalita477
@biplabkalita477 3 жыл бұрын
Kya aap banakar bhi dete hain
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Nahi Biplab ji
@santdnyaneshwar9920
@santdnyaneshwar9920 2 жыл бұрын
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 10 ай бұрын
Applay table format
@3007ash
@3007ash Жыл бұрын
Debug error coming, ActiveCell.Offset(1, 0).Range("A1").Select
@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
@PankajSingh-cy4zs
@PankajSingh-cy4zs 2 жыл бұрын
Hi sir hame kuchh probalam Rahi h
@CHHEDILAL261
@CHHEDILAL261 4 жыл бұрын
plz this video download link
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Ji Yadav ji
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
drive.google.com/file/d/1pErcf5iRC6okGBMwW3Fro7QYbS6l5C3U/view?usp=drivesdk
@vimalmathura8999
@vimalmathura8999 2 жыл бұрын
not working sir
@abhichauhan7384
@abhichauhan7384 4 жыл бұрын
Pdf me kaise save karenge sir
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
Thoda wait kar lijiye
@RuchiSharma
@RuchiSharma 4 жыл бұрын
@@PowerExbyJitendra Thoda wait krne se pdf me save hojata kya sir ?😂
@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
@storyworld724
@storyworld724 3 жыл бұрын
is file mai to koi macro ni h
@PowerExbyJitendra
@PowerExbyJitendra 3 жыл бұрын
Please follow video instructions and record macro
@amitmishra1513
@amitmishra1513 4 жыл бұрын
How to convert excel this Invoice with data into html page on button clicked??
@RakeshKumar-cs1mn
@RakeshKumar-cs1mn 4 жыл бұрын
Formula bhi to bataye
@PowerExbyJitendra
@PowerExbyJitendra 4 жыл бұрын
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
@naseemahmad8902
@naseemahmad8902 Жыл бұрын
Online kam karne ke liye
小路飞和小丑也太帅了#家庭#搞笑 #funny #小丑 #cosplay
00:13
家庭搞笑日记
Рет қаралды 13 МЛН
Deadpool family by Tsuriki Show
00:12
Tsuriki Show
Рет қаралды 6 МЛН
Правильный подход к детям
00:18
Beatrise
Рет қаралды 1,9 МЛН
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 895 М.
Automate Invoices in Excel (1-Click Export as PDF)
15:09
Kenji Explains
Рет қаралды 165 М.
Fully Automated Data Entry User Form in Excel | No VBA
29:22
PowerEx by Jitendra
Рет қаралды 314 М.
Automatic Invoice in Excel | Office Work in Excel | Invoice in Excel
30:45
Master Macros in Excel in Hindi | Automate Repetitive Tasks!
31:25
小路飞和小丑也太帅了#家庭#搞笑 #funny #小丑 #cosplay
00:13
家庭搞笑日记
Рет қаралды 13 МЛН