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.c...
_______________________________________________________
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: ...
Facebook : / powerex-by-jitendra-10...

[@khalidmajeed2886]

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

[@guljee11]

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

[@PowerExbyJitendra]

Thanks a lot

[@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

[@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

[@SATNAMSINGH-oc6yl]

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

[@shashinigam007]

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

[@PowerExbyJitendra]

Thanks

[@VisualKreation]

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

[@jupitermkk]

Bahut badhiya sir

[@100arunxxx]

Nice presentation for learners

[@maqsoodali3127]

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

[@gyan2byhemu145]

you are a excellent quality teacher

[@PowerExbyJitendra]

Thanks

[@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

[@shuaibmalik6578]

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

[@PowerExbyJitendra]

Thanks Shuaib Bhai

[@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

[@pankajupadhyay8359]

thankyou for uploding this video ,

[@subhashbaviskar6015]

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

[@gajendrasingh9486]

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

[@ahsanullah3939]

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

[@PowerExbyJitendra]

Great thanks from my side

[@nagendraprathap9697]

Very useful informative video Sir 👍👍🙏🙏

[@PowerExbyJitendra]

Thanks Nagendra ji

[@bittu25]

Thanks for teaching macro.

[@PowerExbyJitendra]

Thanks

[@mohdarmugaan7418]

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

[@aqeelahmad8237]

Go to File/Excel Option --> Trust centre --> Setting --> Macro Setting --> Enable Macro

[@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

[@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.

[@aqeelahmad8237]

Superb
Very interesting

[@PowerExbyJitendra]

Thanks Aqeel Bhai

[@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

[@Shree.Krishna.]

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

[@PowerExbyJitendra]

Thanks Prasanta

[@muhammadalamnizamani1087]

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

[@Amarjit82]

Very useful .

[@PowerExbyJitendra]

Thanks Amarjit ji

[@doloresdsouza5721]

excellent explanation

[@PowerExbyJitendra]

Thanks

[@accountingbasicbangla1569]

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

[@shaykh_dubai]

Gained some quality knowledge from you sir👍

[@Nicky3286]

THANK YOU SIR

[@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

[@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

[@ynagrajyadav]

Superb sir 👍👍👍

[@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

[@maheshrajapaksha4672]

Good job

[@PowerExbyJitendra]

Thanks Mahesh ji

[@nilkamalkumar1015]

Sir hospital ke liye ek data entry ka video banaiye

[@PowerExbyJitendra]

Ok ji zaroor

[@sanathsaja9840]

Good lesson

[@allaiba.R]

I like u so much Ur Video very Help Full

[@PowerExbyJitendra]

It is so kind of you

[@NasirKhan-bl3xi]

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

[@disauyanmis5933]

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

[@PowerExbyJitendra]

Great

[@mohammedadeladi1680]

Wawooo great thanks sir

[@PowerExbyJitendra]

Thank You Adel ji

[@mazherali2965]

Great work.😊

[@PowerExbyJitendra]

Thanks

[@truptispassionforcooking3401]

Thanks Sir

[@PowerExbyJitendra]

Thanks a lot

[@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.

[@wajid_hussain_balouch]

Weldone

[@PowerExbyJitendra]

Thanks

[@Amar-Jeet_Kullu]

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

[@PowerExbyJitendra]

Thanks

[@shivkumar-er8wx]

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

[@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

[@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

[@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.

[@AliKhan-om6yd]

Superb ... Very Nice. Stay blessed Thanks

[@PowerExbyJitendra]

Thanks Mukarram Bhai

[@shanikhan1854]

Most helpful video

[@PowerExbyJitendra]

Thanks khan sahab

[@sunilshrestha5073]

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

[@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.

[@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

[@ManojGupta-nl8fj]

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

[@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

[@muhammadmobeen7160]

All the best

[@PowerExbyJitendra]

Thanks Mobin Bhai.
Please continue your support.

[@Grandkidsmovies]

Splendid... Super....

[@PowerExbyJitendra]

Thanks Azhar

[@ravikaushik533]

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

[@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

[@Im.sarup1111]

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

[@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

[@viswanathancr2801]

good video

[@md.mominulislam7498]

thank's

[@PowerExbyJitendra]

Thanks

[@muhammadmobeen7160]

Excellent

[@PowerExbyJitendra]

Thanks Mobeen

[@kingcinema5295]

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

[@mohammadjaved5205]

Sir kiya aap mere liye ek formula create kar sakte hai
Column and cell A1 main value hai 202 or column and cell A2 main value hai 200 agar A2 value 200 se below hoti hai to kuch popup ya color highlight alert dikhna chahiye
Dusri bat yeh hai ke same cell or column main agar value 304 or 300 ho to bhi popup ya color alert dikhna chahiye
Pls formula ya vba code bataye,,, thanks

[@BharatKumar-fh7ei]

Super.
Not necessary for userform.

[@PowerExbyJitendra]

Thanks ji

[@nileshss9123]

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

[@PowerExbyJitendra]

So much thanks Nilesh

[@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.

[@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

[@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

[@muhammadhussainyousaf5581]

Very informative video.

[@PowerExbyJitendra]

Thank you sir

[@ujjwalpanda79]

Thanks Dear,

[@PowerExbyJitendra]

You are welcome Abhiraj

[@alializadeh8195]

Thanx

[@PowerExbyJitendra]

Welcome

[@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

[@akbarhosen5215]

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

[@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

[@nimeshpateldesad3016]

Sir keyboard se save butan ke se bana te he

[@yadavdinesh]

सर जी क्‍या इस प्रकार की शीट में सीरीय नम्‍बर साथ में ओटोमेटीक जरनेट नही हो सकता है क्‍या सर प्‍लीज इस पर विडीयो देवें।

[@selwynjoseph3717]

Very usefull sir

[@PowerExbyJitendra]

Thanks

[@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.

[@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

[@pratapsahoo4157]

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

[@PowerExbyJitendra]

Please watch this video :
czcams.com/video/weBuCZWrcTM/video.html

[@pratapsahoo4157]

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

[@PowerExbyJitendra]

@@pratapsahoo4157 you have to visit to data sheet

[@deepakdalal8731]

Superb 👌👌👌

[@PowerExbyJitendra]

Thanks 🤗

[@SehrawatFitHealth]

shandar video 🙏

[@PowerExbyJitendra]

Thanks dear

[@atiqurrehman1946]

Good night my dear, it's excellent.

[@PowerExbyJitendra]

Thank you sir

[@SantoshSharma-ty6bh]

I created one file and set micro but not working from last 3 days i m trying. where i m doing mistek, i don't know.
MICRO-
Sub Ent()
'
' Ent Macro
'
'
Range("D3:D21").Select
Selection.Copy
Sheets("Inword_Data").Select
Range("A1").Select
ActiveCell.Offset(1, 0).Range("A1").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Rows("2:2").Select
Application.CutCopyMode = False
Selection.Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
Range("A2").Select
Sheets("INWORD").Select
Selection.ClearContents
Range("D3").Select
End Sub
please guide me.

[@tech-journey2946]

Kya ye chij hum ms office 2007 me kar sakte he ya nahin.

[@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

[@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

[@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

[@sajidibrahim376]

Kindly support to understand, if we need to make any addition in dashboard, then do we have to repeat the whole process??? means I want to add something new in Dashboard, which is already working...

[@alanrashid9037]

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.

[@muhammedjarvis9799]

SAME here

[@mangalsinghchauhan8899]

How to make data uneditable after transpose into database.

[@forgottensharma]

isko save kis format me karna hai.

[@dillipmoharana1731]

One invoice contains more items, guide how to enter n number of items automatically