How to Make Data Entry Form in Excel Using Macro in Hindi | Like a Software

How to Make Data Entry Form in Excel Using Macro in Hindi | Like a Software
In this easy tutuorial video you will learn to design a password protected data entry form by using Macro. Only user can view the data storage file. Other person can do enries but not be able to see the storage file.
This is really an amazing data entry form you must learn it.
_______________________________________________________
Download Exercise File:
drive.google.com/file/d/1n8Mp...
_______________________________________________________
Our other most popular videos:
01. How to use Macro in Excel | Amazing use of Macro in Hindi
• How to use Macro in Ex...
02.How to Use Marcro in Excel in Hindi
• How to Use Marcro in E...
03. Stock Management in Excel (Hindi) Part - 2
• Stock Management in Ex...
04. Stock Management in Excel (Hindi) Part - 3
• Stock Management in Ex...
05. How to record macro in MS Excel for doing repetitive calculations (Hindi)
• How to record macro in...
06. How to Automatically Transfer Data from one sheet to another in Excel using macros (Hindi)
• How to Automatically T...
07. How to Move Data Automatically from One Workbook to Another in Excel | Using Macro |
• How to Move Data Autom...
08. Stock Management in Excel (Hindi)
• Stock Management in Ex...
======================================
Please SUBSCRIBE our channel.
Video is published on Powerex by Jitendra
#dataentry
#powerexbyjitendra
#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: kumarjitendra11...
Facebook : / powerex-by-jitendra-10...

[@VisualKreation]

Bahot Bahot Shukriya Sir...Really Helpful Video..TQ

[@SATNAMSINGH-oc6yl]

bhut hi helpful video hai sir.... thank u so much...

[@shaykh_dubai]

Gained some quality knowledge from you sir👍

[@jupitermkk]

Bahut badhiya sir

[@accountingbasicbangla1569]

very nice..That's really helpful sir... Thank you for make it with very simple way..

[@khalidmajeed2886]

sir, mashallah bohat mehnat saay aap naay explain kia haay.,,,,,,,

[@100arunxxx]

Nice presentation for learners

[@delwarhossain7200]

Excellent Boss! Though I am not a Hindi speaking guy but your every word is crystal clear to understand. I love it!!

[@PowerExbyJitendra]

Thanks Delwar ji

[@pankajupadhyay8359]

thankyou for uploding this video ,

[@nagendraprathap9697]

Very useful informative video Sir 👍👍🙏🙏

[@PowerExbyJitendra]

Thanks Nagendra ji

[@AliKhan-om6yd]

Superb ... Very Nice. Stay blessed Thanks

[@PowerExbyJitendra]

Thanks Mukarram Bhai

[@Shree.Krishna.]

Excellent video... Thanks all the best..👍

[@PowerExbyJitendra]

Thanks Prasanta

[@SehrawatFitHealth]

shandar video 🙏

[@PowerExbyJitendra]

Thanks dear

[@muhammadhussainyousaf5581]

Very informative video.

[@PowerExbyJitendra]

Thank you sir

[@shuaibmalik6578]

Bhai very good, very easy method to transfer data. good job.

[@PowerExbyJitendra]

Thanks Shuaib Bhai

[@gyan2byhemu145]

you are a excellent quality teacher

[@PowerExbyJitendra]

Thanks

[@ahsanullah3939]

Very very Nice 👍 sir I Love your work...thanx for uploading such a good video

[@PowerExbyJitendra]

Great thanks from my side

[@Nicky3286]

THANK YOU SIR

[@nileshss9123]

Thank you sir....wao....nice

[@PowerExbyJitendra]

So much thanks Nilesh

[@disauyanmis5933]

Great job! Thanks a lot. Was Always stuck, just understood I need to use “relative references”.

[@PowerExbyJitendra]

Great

[@amigosautomotives876]

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.

[@PowerExbyJitendra]

Thank you so much

[@Grandkidsmovies]

Splendid... Super....

[@PowerExbyJitendra]

Thanks Azhar

[@shanikhan1854]

Most helpful video

[@PowerExbyJitendra]

Thanks khan sahab

[@atiqurrehman1946]

Good night my dear, it's excellent.

[@PowerExbyJitendra]

Thank you sir

[@guljee11]

I tried and ... successful. thank you. Now I'll do it for our school record.

[@PowerExbyJitendra]

Thanks a lot

[@sanathsaja9840]

Good lesson

[@shashinigam007]

Very Practical n useful ..... Like n recommend ur videos in my friends ...... Thankyou very much Sir....

[@PowerExbyJitendra]

Thanks

[@aqeelahmad8237]

Superb Very interesting

[@PowerExbyJitendra]

Thanks Aqeel Bhai

[@naumanvola]

great job keepit up

[@PowerExbyJitendra]

Thanks Nauman

[@Amar-Jeet_Kullu]

Thanks a lot sir. You explained it in a simple and effective way. #AmarJeetKullu

[@PowerExbyJitendra]

Thanks

[@mohammedadeladi1680]

Wawooo great thanks sir

[@PowerExbyJitendra]

Thank You Adel ji

[@mazherali2965]

Great work.😊

[@PowerExbyJitendra]

Thanks

[@deepakdalal8731]

Superb 👌👌👌

[@PowerExbyJitendra]

Thanks 🤗

[@pratapsahoo4157]

Thank you very much for the video, came to know usage of "relative references"

[@PowerExbyJitendra]

Please watch this video : kzbin.info/www/bejne/rZalpnaQjNeWiq8

[@pratapsahoo4157]

please let me know how to edit a previous entry which is found wrong

[@PowerExbyJitendra]

@@pratapsahoo4157 you have to visit to data sheet

[@ynagrajyadav]

Superb sir 👍👍👍

[@bittu25]

Thanks for teaching macro.

[@PowerExbyJitendra]

Thanks

[@bittubhasin4909]

Good sir Thanks

[@PowerExbyJitendra]

Thanks

[@selwynjoseph3717]

Very usefull sir

[@PowerExbyJitendra]

Thanks

[@allaiba.R]

I like u so much Ur Video very Help Full

[@PowerExbyJitendra]

It is so kind of you

[@jayanthamadasekera8248]

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

[@mayuddinsipai4906]

Great sir

[@PowerExbyJitendra]

Thanks ji

[@Sammy-xv7mq]

Sir your video are amazing Very nice and you make everything look easy and so understandable

[@PowerExbyJitendra]

Thank you man I am very happy with your comment.

[@Sammy-xv7mq]

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

[@ujjwalpanda79]

Thanks Dear,

[@PowerExbyJitendra]

You are welcome Abhiraj

[@doloresdsouza5721]

excellent explanation

[@PowerExbyJitendra]

Thanks

[@gajendrasingh9486]

Thank you for useful video...how to get gst number by name and sales invoice by serial number

[@learnteach1228]

Dawood bhai video is very nice but we need how to formulas in macro recording and also with drop down list in excel 2019

[@bhadrabdrshahi5539]

Thank u sir

[@PowerExbyJitendra]

Welcome sir

[@priyavicky3131]

Nice 👌

[@PowerExbyJitendra]

Thanks 😊

[@Amarjit82]

Very useful .

[@PowerExbyJitendra]

Thanks Amarjit ji

[@sagni2980]

Very effective information. Pls make video ,if we record wrong data by mistake, how can we delete and edit from dashboard. Thanks

[@PowerExbyJitendra]

Thanks for your suggestion

[@viswanathancr2801]

good video

[@23129696]

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

[@muhammadmobeen7160]

Excellent

[@PowerExbyJitendra]

Thanks Mobeen

[@truptispassionforcooking3401]

Thanks Sir

[@PowerExbyJitendra]

Thanks a lot

[@kansaram]

Excellent and Very useful tutorial Can you kindly make a video tutorial for how to create POS type cash sale ticket used in almost all business 1) company name and logo 2) ticket number 3) current date with time 4) making manuai or barcode entry of each article (description of as many articles + price including all taxes) 5) subtotal of all articles just in the next line 6) amount of taxe (vat) included in item's price 7) amount paid 8) change to return 9) line of thanks giving / please visit again etc.. 10) create button A) printing the ticket B) to save all contents in a protedted sheet C) clear all contents increasing ticket previous number +1 and modifying date if applicable This will be great help to me as well as to many other people

[@PowerExbyJitendra]

Ok Mahendra ji, Thank you so much for a valuable suggestion.

[@kunalsharma8319]

And sir maine comment me dekha aap reply sabhi ko krte h . That's I liked most. U connect deeply to anyone. I m so urge for waiting ur reply. I m n Sr. Accountant and if I will meet 2 u it's my good luck. # Kunal 🤝 Jitender g.

[@subhasishbhattacharjee8510]

👍 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.

[@muhammadmobeen7160]

All the best

[@PowerExbyJitendra]

Thanks Mobin Bhai. Please continue your support.

[@maheshrajapaksha4672]

Good job

[@PowerExbyJitendra]

Thanks Mahesh ji

[@mahmoudabouzaid8836]

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

[@mezanurshuvo]

thanks

[@PowerExbyJitendra]

Thanks bro

[@md.mominulislam7498]

thank's

[@PowerExbyJitendra]

Thanks

[@wajid_hussain_balouch]

Weldone

[@PowerExbyJitendra]

Thanks

[@VeerMotionGraphics]

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.

[@abuhasanpalash09]

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

[@Im.sarup1111]

Thank you sir. Can you help me,Which screen recorder you have used?

[@alializadeh8195]

Thanx

[@PowerExbyJitendra]

Welcome

[@kunalsharma8319]

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?

[@PowerExbyJitendra]

Dear Rajan great thanks for your lovely compliment and kind support

[@arvindawasthi8710]

👍👍👍👍👍👍🙏

[@PowerExbyJitendra]

Thanks Arvind ji

[@netkingmahin]

nice

[@PowerExbyJitendra]

Thanks Mahin

[@maqsoodali3127]

Sir good job .lekan sir print ka tarka zara batho plz

[@farihah791]

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

[@subhashbaviskar6015]

Sir, data entry main date aur drop down list auto hosakti kya? aur data date wise sort kaise hoga

[@Infotainment_official101]

Sir my entry format is already made on the sheets where I want data to enter by using Dashboard sheet. But Sir I have formulas in my data sheets. How to translate the Data from Dashboard while actual data sheets has formulas. Kindly guide me in this respect. And my data sheets are more than one like April, May soon to March. By using the dashboard I want to fill data in the respective months. Kindly help me out

[@ManojGupta-nl8fj]

Sir kya intery ke liye sabhi cells ko krambaddh ek ke niche ek hona jaruri hai?

[@biswajitkaran89]

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.

[@PowerExbyJitendra]

Biswajit ji please save the file as Excel Macro Enabled Workbook it will definitely work next time

[@yaseryasu7145]

@@PowerExbyJitendra can you explain in details. Mathematic calculations

[@somrattelecom]

Awesome vedio for data entry sir. Please tell me how to edit data entry information in this sheet

[@PowerExbyJitendra]

Valid suggestion

[@sunilshrestha5073]

Can we keep icons on the desktop of this excel like other software where we can open directly?

[@somrattelecom]

Sir please make a vedio for data editing

[@PowerExbyJitendra]

Ok ji Sirajul

[@qaisarshehzad9620]

Sir, You have done a great Job. Can you Tell me how to save this file.

[@PowerExbyJitendra]

Save it as Excel Macro Enabled Workbook

[@NasirKhan-bl3xi]

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

[@shaikhfiroz4007]

Sir can you send a vedio for medicine billing invoice in excel & link with stock, sales & purchase.

[@usama8464]

I also need what u have questioned.

[@Educationknowledge23]

Wow..... very useful video sir.... but data mistake entry hogaya to edit karke correct kaise karein sir ? Plz

[@PowerExbyJitendra]

You may use data validation to avoid mistakes.

[@sndeshpande9462]

If I want to do multiple product entry in one invoice then how can program. Can you please let us know

[@PowerExbyJitendra]

You may design entry format as per your requirements

[@BharatKumar-fh7ei]

Super. Not necessary for userform.

[@PowerExbyJitendra]

Thanks ji

[@aleemshaikh669]

Awesome✓✓✓✓ Bt Sir Save Data ka button fix ho jayega ya move hoga place se bcz shape tool se draw kiya gaya hai.

[@PowerExbyJitendra]

Thank you Aleem bhai

[@aleemshaikh669]

@@PowerExbyJitendra Save data buttone will move on place or not

[@PowerExbyJitendra]

@@aleemshaikh669 it can move

[@muslimsunity6967]

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

[@tssddqqsdi9010]

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

[@stairsofsuccess6216]

sir plz automate school management all areas excell main bnana sikha dain. i m from pakistan. kiya ye window 10 main features hain ya hr aik main

[@PowerExbyJitendra]

Hi dear It works in ms office version above 2007

[@learnteach1228]

BOSS EXCELLANT BUT WE NEED IMPROVE THIS SHEET VIDEO WITH DROPDOWN LIST ALONG WITH PHOTO SAVING ALSO

[@PowerExbyJitendra]

Thanks bro

[@dhanrokaha2941]

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

[@muhammadzabeehullah3298]

Plz bro gave details of first sheet entry

[@nilkamalkumar1015]

Sir hospital ke liye ek data entry ka video banaiye

[@PowerExbyJitendra]

Ok ji zaroor

[@muhammadalamnizamani1087]

Akhri Cell me se data save karnay k liye enter use karna chahye na ka mouse,

[@arunsharma07]

I followed your video but when I'm making another entry it getting replaced by previous one instead of palcing data below that cell

[@akbarhosen5215]

how to entry various product from only one invoice? (without repeat or fill up whole from or dash)

[@shivkumar-er8wx]

sir jee data entry form me igst cgst sgst bhi add karake bataye

[@NasirKhan-bl3xi]

Ek prog sir banayen Kai his Mai create adding delete save kaise Karen bataon sir ek prog bhi banaon sir

[@whatsappstatusguru1768]

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 ?

[@PowerExbyJitendra]

Aap entry format apni zaroorat ke hisab se hi design kariye

[@muslimsunity6967]

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