Thank you so much Sir. This video is very much essential, important and helpful for all MS Excel Macro lover. This is an extraordinary task that is automatically hidden entry sheet after each entry.
Thank you so much for your quick response. Well done and very good design. I would like to make a request if you can insert caption in english it will help a lot for every body out side India
Bahut acha laga prog mujhe sir but is Mai mujhe agar baad Mai kuch aur bhi addition karna hai to kaise Karen sir aur delete kaise Karen yeh bhi batayen sir
Sir, Can I please ask if you have a video about food cost & pricing Same format as the stock version So you also give training sir Please advise Thank you sir
hello and thanks for this useful videos i'm asking about adding bottom for Search about data at specific date or specific name and what about print this data after search
Costing sheet banani hai jisma kuch data fixed hote hai jo hide rakahana hota hai or khuch entry karne se kisi product ka price nikal jaye to usko kaise banaye pl
Hello Jitendra ji I am follow your guide line a did but i save data and next reopen and enter data and save can not save, can not see the macro display how can i adjust please let me know
Thank you i Watched the video...? I am from Bangladesh. I want to talk with you about the data entry sheet. I want to more update like percent calculation system and including invoice
Sir mene apka video dekhake ye full formate bana liya ekdam easily. Ab agar hamnko customer ke name wise alag se uska month vise bill banaha ho to hum kese bana shakte hai ?
Thanks for the video, however how do i add a table and it works the same? I’m trying to use this for logging orders from customer and have a table but its not working
👍 one question, i have a format where data is getting transfer, but data locking is not happening, if I press delete button data get deleted. Hiding the sheet option i don't require. Please help out in this subject. Your way of explaining is very appreciable. Thank you.
hello bro ihave a problem when i tries to record an other record the system gives me an error of Run time error ''9'' and subscript out of range plz let me know the solution
Good Presentation, anybody can easily understand how to work in excel. Thank you for uploading this kind of video and helped many people in their regular admin work.
Sir, very very amezing , interesting and informative that I not seen before. But Sir , two quetions -1) how can I open the Data Entry Dashboard in the next time after closing and 2) how can I calculate the mathematical operations . Sir , please response.
dear am working at a small shop of cloths, i want to maintain daily reecord with add buttons in relevent feilds and payments as well will you plz help me out. waiting for your helpfull response
Thank you so much Sir. This video is very much essential, important and helpful for all MS Excel Macro lover. This is an extraordinary task that is automatically hidden entry sheet after each entry.
sir, mashallah bohat mehnat saay aap naay explain kia haay.,,,,,,,
I tried and ... successful. thank you. Now I'll do it for our school record.
Thanks a lot
Bahut badhiya sir
bhut hi helpful video hai sir.... thank u so much...
Bahot Bahot Shukriya Sir...Really Helpful Video..TQ
Superb sir 👍👍👍
aapki video se kamyabi mili zabardast 31224
Bhai very good, very easy method to transfer data. good job.
Thanks Shuaib Bhai
Very Practical n useful ..... Like n recommend ur videos in my friends ...... Thankyou very much Sir....
Thanks
thankyou for uploding this video ,
Superb
Very interesting
Thanks Aqeel Bhai
Thank you so much for your quick response. Well done and very good design. I would like to make a request if you can insert caption in english it will help a lot for every body out side India
you are a excellent quality teacher
Thanks
Very useful informative video Sir 👍👍🙏🙏
Thanks Nagendra ji
Excellent video... Thanks all the best..👍
Thanks Prasanta
Very very Nice 👍 sir I Love your work...thanx for uploading such a good video
Great thanks from my side
Great work.😊
Thanks
Splendid... Super....
Thanks Azhar
Very useful .
Thanks Amarjit ji
All the best
Thanks Mobin Bhai.
Please continue your support.
Wawooo great thanks sir
Thank You Adel ji
Thanks for teaching macro.
Thanks
Bahut acha laga prog mujhe sir but is Mai mujhe agar baad Mai kuch aur bhi addition karna hai to kaise Karen sir aur delete kaise Karen yeh bhi batayen sir
excellent explanation
Thanks
Superb ... Very Nice. Stay blessed Thanks
Thanks Mukarram Bhai
very nice..That's really helpful sir... Thank you for make it with very simple way..
Good job
Thanks Mahesh ji
Good lesson
I like u so much Ur Video very Help Full
It is so kind of you
Excellent Boss! Though I am not a Hindi speaking guy but your every word is crystal clear to understand. I love it!!
Thanks Delwar ji
Sir your video are amazing
Very nice and you make everything look easy and so understandable
Thank you man
I am very happy with your comment.
Sir, Can I please ask if you have a video about food cost & pricing
Same format as the stock version
So you also give training sir
Please advise
Thank you sir
Most helpful video
Thanks khan sahab
Gained some quality knowledge from you sir👍
Very effective information.
Pls make video ,if we record wrong data by mistake, how can we delete and edit from dashboard.
Thanks
Thanks for your suggestion
Superb 👌👌👌
Thanks 🤗
Thank you sir....wao....nice
So much thanks Nilesh
Sir good job .lekan sir print ka tarka zara batho plz
Weldone
Thanks
Very informative video.
Thank you sir
THANK YOU SIR
Excellent
Thanks Mobeen
shandar video 🙏
Thanks dear
great job keepit up
Thanks Nauman
good video
Thanks Sir
Thanks a lot
Very usefull sir
Thanks
sir i have little bit issue .auto data save is start but not in next row. just save on first row . can you give me advice about that
Thanks a lot sir. You explained it in a simple and effective way.
#AmarJeetKullu
Thanks
Can we keep icons on the desktop of this excel like other software where we can open directly?
hello and thanks for this useful videos i'm asking about adding bottom for Search about data at specific date or specific name and what about print this data after search
Sir hospital ke liye ek data entry ka video banaiye
Ok ji zaroor
Great sir
Thanks ji
Thanks Dear,
You are welcome Abhiraj
Good night my dear, it's excellent.
Thank you sir
sir how serial number automatic change kese hoga isme q k jo entry kar raha he use to nhi pa ta hoga k ab konsa serial type karna he
Dear,
Is it possible the same entry form for more distributor having data save in separate sheet and also search option to retrieve data for search.
Thank you for useful video...how to get gst number by name and sales invoice by serial number
Dawood bhai video is very nice but we need how to
formulas in macro recording and also with drop down list in excel 2019
Nice 👌
Thanks 😊
Good sir
Thanks
Thanks
sir jee data entry form me igst cgst sgst bhi add karake bataye
Sir, You have done a great Job. Can you Tell me how to save this file.
Save it as Excel Macro Enabled Workbook
Akhri Cell me se data save karnay k liye enter use karna chahye na ka mouse,
Costing sheet banani hai jisma kuch data fixed hote hai jo hide rakahana hota hai or khuch entry karne se kisi product ka price nikal jaye to usko kaise banaye pl
Great job! Thanks a lot. Was Always stuck, just understood I need to use “relative references”.
Great
Sir, data entry main date aur drop down list auto hosakti kya? aur data date wise sort kaise hoga
I followed your video but when I'm making another entry it getting replaced by previous one instead of palcing data below that cell
Sir kya intery ke liye sabhi cells ko krambaddh ek ke niche ek hona jaruri hai?
Hello Jitendra ji I am follow your guide line a did but i save data and next reopen and enter data and save can not save, can not see the macro display
how can i adjust please let me know
Thanx
Welcome
Ek prog sir banayen Kai his Mai create adding delete save kaise Karen bataon sir ek prog bhi banaon sir
Well Explained... Is there is option to get drop down while doing data entry. And if we want to modify the data, how we can do
isko save kis format me karna hai.
Sir keyboard se save butan ke se bana te he
Thank you i Watched the video...? I am from Bangladesh. I want to talk with you about the data entry sheet. I want to more update like percent calculation system and including invoice
Wow..... very useful video sir.... but data mistake entry hogaya to edit karke correct kaise karein sir ? Plz
You may use data validation to avoid mistakes.
Kya ye chij hum ms office 2007 me kar sakte he ya nahin.
Thank you sir. Can you help me,Which screen recorder you have used?
Thank u sir
Welcome sir
Sir I can tried, micro also recorded but entry in second page in first line, when we are doing second entry such entry replace on first row
Please use 'use relative references'
@@PowerExbyJitendra sir nahi ho raha hai
Sir mene apka video dekhake ye full formate bana liya ekdam easily.
Ab agar hamnko customer ke name wise alag se uska month vise bill banaha ho to hum kese bana shakte hai ?
Aap entry format apni zaroorat ke hisab se hi design kariye
Sir file open kar rehe hai to security warning macros have been disable ke option s aa raha hai is me enable nahi aaraha hai solution batao
Go to File/Excel Option --> Trust centre --> Setting --> Macro Setting --> Enable Macro
Thank you very much for the video, came to know usage of "relative references"
Please watch this video :
ruclips.net/video/weBuCZWrcTM/видео.html
please let me know how to edit a previous entry which is found wrong
@@pratapsahoo4157 you have to visit to data sheet
Super.
Not necessary for userform.
Thanks ji
HI Bro .... when I run the macro, it overwrites the data on the existing row in the datasheet.... please guide me where I m doing mistakes.
SAME here
nice
Thanks Mahin
Kya isi trah ka form Google sheets me bhi banaya ja sakta hai?
Nahi
Thanks for the video, however how do i add a table and it works the same? I’m trying to use this for logging orders from customer and have a table but its not working
for data entry easy to create thanks but after dataentry any modification correction reqd it will be fetched?
it can be manually only
👍 one question, i have a format where data is getting transfer, but data locking is not happening, if I press delete button data get deleted. Hiding the sheet option i don't require. Please help out in this subject. Your way of explaining is very appreciable. Thank you.
hello bro
ihave a problem when i tries to record an other record the system gives me an error of Run time error ''9'' and subscript out of range plz let me know the solution
how to entry various product from only one invoice? (without repeat or fill up whole from or dash)
Good Presentation, anybody can easily understand how to work in excel. Thank you for uploading this kind of video and helped many people in their regular admin work.
Thank you so much
Sir, very very amezing , interesting and informative that I not seen before. But Sir , two quetions -1) how can I open the Data Entry Dashboard in the next time after closing and 2) how can I calculate the mathematical operations . Sir , please response.
Biswajit ji please save the file as Excel Macro Enabled Workbook it will definitely work next time
@@PowerExbyJitendra can you explain in details. Mathematic calculations
Sir can you send a vedio for medicine billing invoice in excel & link with stock, sales & purchase.
I also need what u have questioned.
dear am working at a small shop of cloths, i want to maintain daily reecord with add buttons in relevent feilds and payments as well will you plz help me out. waiting for your helpfull response
Grand salute what a nice explanation. Sir I m ur fan now. Excel to ab apki hi video se sikhunga. But how can I contact u?
Dear Rajan great thanks for your lovely compliment and kind support
How to make data uneditable after transpose into database.
Awesome✓✓✓✓
Bt Sir Save Data ka button fix ho jayega ya move hoga place se bcz shape tool se draw kiya gaya hai.
Thank you Aleem bhai
@@PowerExbyJitendra Save data buttone will move on place or not
@@aleemshaikh669 it can move