How to Save Invoice Data in Excel in Hindi
HTML-код
- Опубликовано: 17 окт 2024
- How to Save Invoice Data in Excel in Hindi
In our last video you learnt how to create a fully automatic tax invoice template in microsoft excel and in this video you will learn to save invoice data automatically for future reference in other excel sheet by using macro. So watch this video in continuity of our last video.
-----------------------------------------------------------------------
Download Our Excel Workbook: https: drive.google.c...
-----------------------------------------------------------------------
Our Popular Videos:
1. How to create GST Invoice in Excel in Hindi | Tax Invoice Template
• How to create GST Invo...
2. Drop Down List In Excel Hindi
• How To Create Auto Upd...
3. Vlookup Formula in MS Excel with Examples
• Vlookup Formula in MS ...
4. Stock Management in Excel (Hindi)
• Stock Management in Ex...
5. Stock Management in Excel (Hindi) Part - 2
• Stock Management in Ex...
6. Stock Management in Excel (Hindi) Part - 3
• Stock Management in Ex...
7. How to Make Data Entry Form in Excel Using Macro in Hindi
• How to Make Data Entry...
8 . How to record macro in MS Excel for doing repetitive calculations (Hindi)
• How to record macro in...
video is created by Jitendra
Published on Powerex by Jitendra
#taxinvoice
#powerxbyjitendra
#excel
Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for 'Fair Use' for purposes such as criticism, comment, news reporting, teaching, scholarship, and research.
Fair use is a permitted by copyright statute that might otherwise be infringing.
Non-profit, educational or personal use tips the balance in favor of fair use.
Contact Us:
Instagram: ...
Facebook : / powerex-by-jitendra-10...
I never saw this kind of teaching method before about Excel. God bless you Sir! ❤
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
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
Hello, your this video is very helpful. I have an additional query, is it possible to print the saved invoices from current position?
Thankyou sir me ise ka solution bahot dino se dund raha tha ❤❤
Thanks a lot 👍
I got it finally what I want... Salute to Google Add sense....and thay to video creator
🙏
खूप सुंदर आणि खूप उपयुक्त व्हिडीओ आहे सर, tx sir
Thank you so much Prabhakar ji
Bohut acha example h sir
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🙏🙏
Sir great information but zero in the invoice also should not be there so what is the formula?
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.
Sir please make a video for pharmacy business.
agar ho old invoice mai kuch change hogo or edit kar na ho to ?
Lookup formula use karke kar sakte ho
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.
Sir kindly make a video for multiple creteria and get data multiple matches
Thank you so much sir
Welcome🙏 ji
Sir please tell me a way to edit older bills other than editing in datasheet please find any way to do it easily
Sir, how to generate sales data from sales invoice wrt products and their quantities?
Mobile apps excel me b Bana do sir
Sir kya aap pdf bhi automatically save honi chahiye aisa video bana sakte hien
Kisi invoice mai two or three or eshe above items hoga toh vo kaise save hoga ? Please batao
How can get the format be protected so that no changes can be made by the user? Except automated generated or data entry
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.
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
Thank u very much sir 😀🤩
Good job 👌
Thanks Sunny
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
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
Aap macro record karne se pahle page setup kar lijiye fir nahi hoga
@@PowerExbyJitendra Sir Phely macri recoard kar liya ab ye problem aa raha he kia mujhy dobara macro recoard karna pary ga.
@@baharali7429 page layout ja kar print area set kariye
Sir agar monthly wise karni ho save
Awesome 🙏👍👍😘
agar hme jo items hai unko kaise krenge agar items 10 hui to
Dear sir, please make a video on GST invoices (multiple rates) and auto save the details of that invoice rate-wise
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
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😥
Please Use Paste Special manually
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
Helpful video was this
Sir plz upload 1st chapter of this video
Thaks
Sir mujhe data sheets me particular bhi add karna he ek se jyada to kese kare.
Sir how to save more than one record of products purchased by a customer in database. U have shown only one record.
Can i get this template please?
Customers ke product details kaha store hota hai...ek customer multiple product khoti da to o sari product kaha milege
Multiple item ke liye bataiye ki save data kaise hoga
Very humble teaching sir 🙏 நன்றி 👍
Thanks for your lovely comment
@@PowerExbyJitendra sir,2 line of record not stored .only first record is storing
Very effective 🎉
Thanks a lot
new invoice k lye error 13 type mismatch ka error a jata hai kindly guide me how to correct?
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?
Very good
Good teaching and not clear video.
Sorry for that
How can save all items quantity of invoice on another sheet
Sir maine coulomb A , B ko merge kiya hai pr new invoice karne main error aa ra
One issue. After running macro the data overwrite in same row, only date column working fine.
Please use 'Use Relative References' while pasting
@@PowerExbyJitendra I did exactly the same u shown in video. But except the date all data are overwritten.
Same issue with me , any solutions?
same problem with my data
Same problem
How to add more brands in one invoice pls instruct
Very good sir.jii
Thank you Deepak ji
Not working save data can you help me sir
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
Great job. How I modify the invoice
you may modify manually
Microsoft Office ka kain version hai ye
In amount coloumn how to hide '0' when 'particular' coloumn are blank.
Sir is in voice ka pdf formate m save kany ka bhi Video bany lpz ya
Ok ji
sir ji mera vba code kaam nahi ker raha hai hamesha erorr araha hai
please help karo sir
agar kisi saved invoice ko edit krna ho to kaise krenge
May the peace, the mercy, and the blessings of Allah be upon you
Same to you my friend
Very nice sir
Thanks ji
Yeh office 2007 pe kaam karega??
Enjamul ji If you are a excel lover please upgrade it. You will feel the difference
Kam toh karna chahiye
यदि हर आईटम जा जी.एस.टी. रेट अलग हो तो क्या करें ?
Sir address ka drown kaise karna
This method only adding one line and reset again. But more value table not adding in the rows and columns
Did you manage to fix this problem bro
Agar line 1 se jayada hogi tb kaise krenge
Ye batao
Very good 👍
Thanks Bhai
Superb sir
but when i press ctrl+down arrow then cursor goes to last cell not down cell
Please watch carefully
Sheet 2 ka upyog???
Particulars Kiun Save nai ho rahy bhai ..?
good video
Thanks Bro
Sir can u give same this software to me
Ek hi invoice me delivery note or proforma invoice kaise banaye or pdf me kaise save kare save d file me Hona chahiye
Online kam karne ke liye website Kaise banaen
Debug error coming, ActiveCell.Offset(1, 0).Range("A1").Select
Hi sir hame kuchh probalam Rahi h
1 problem ha sir.
Agar further invoice ko dekhna ha to kaya karange ?
PDF mai save karke rakh sakte hai
Aur edit karna ho to
@@THERAVITECHNICAL XPS me save kar sakte hain
@@shubhadas2142 will it change in data sheet sir
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....
Applay table format
اسلام علیکم ورحمتہ اللہ وبرکاتہ
Sorry I could not read your comment.
How to save invoice by company name and invoice no both in pdf ,please provide me VBA code
sIRJI tHANKS
nice
Thanks bro
Sheets 2 how make
The address of Ghanta Ghar Meerut is in my Neighbour coz I'm also from Meerut 😅😅
Yah banane ke bad dobara kholne per Kam nahin karta hai kyon
Please save file as Macro Enabled Workbook then it will work
How to convert excel this Invoice with data into html page on button clicked??
final workbook Please...
Kya aap banakar bhi dete hain
Nahi Biplab ji
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.
iske liye aap conditional formatting ka istemal kar sakte hai
@@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
is file mai to koi macro ni h
Please follow video instructions and record macro
plz this video download link
Ji Yadav ji
drive.google.com/file/d/1pErcf5iRC6okGBMwW3Fro7QYbS6l5C3U/view?usp=drivesdk
not working sir
Down arrow ki samj nahi arahi
Pdf me kaise save karenge sir
Thoda wait kar lijiye
@@PowerExbyJitendra Thoda wait krne se pdf me save hojata kya sir ?😂
Ye sab krne k bAd pc restart kro to tmAm butn dis@bLe hoj@te he
Ky@ krye,,.......
Dear Yameen,
You will have to save this excel file as "Excel Macro Enabled Workbook"
Formula bhi to bataye
Rakesh ji last video mai formulas bhi bataye gaye hai aur yadi aap lag se dekhna chahte hai to
1. Vlookup
ruclips.net/video/I_33jLRvqmQ/видео.html
2. Drop down list
ruclips.net/video/YQEGlaghtBI/видео.html
Online kam karne ke liye
same data over written
Sir aapka contact number chahiye thoda sajetion ke liye