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

[@SATNAMSINGH-oc6yl]

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

[@VisualKreation]

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

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

[@jupitermkk]

Bahut badhiya sir

[@shashinigam007]

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

[@PowerExbyJitendra]

Thanks

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

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

[@pankajupadhyay8359]

thankyou for uploding this video ,

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

[@ynagrajyadav]

Superb sir 👍👍👍

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

[@Amarjit82]

Very useful .

[@PowerExbyJitendra]

Thanks Amarjit ji

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

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

[@ahsanullah3939]

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

[@PowerExbyJitendra]

Great thanks from my side

[@sunilshrestha5073]

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

[@aqeelahmad8237]

Superb Very interesting

[@PowerExbyJitendra]

Thanks Aqeel Bhai

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

[@subhashbaviskar6015]

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

[@nagendraprathap9697]

Very useful informative video Sir 👍👍🙏🙏

[@PowerExbyJitendra]

Thanks Nagendra ji

[@bittu25]

Thanks for teaching macro.

[@PowerExbyJitendra]

Thanks

[@doloresdsouza5721]

excellent explanation

[@PowerExbyJitendra]

Thanks

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

[@Shree.Krishna.]

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

[@PowerExbyJitendra]

Thanks Prasanta

[@accountingbasicbangla1569]

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

[@mazherali2965]

Great work.😊

[@PowerExbyJitendra]

Thanks

[@allaiba.R]

I like u so much Ur Video very Help Full

[@PowerExbyJitendra]

It is so kind of you

[@mohammedadeladi1680]

Wawooo great thanks sir

[@PowerExbyJitendra]

Thank You Adel ji

[@ManojGupta-nl8fj]

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

[@tech-journey2946]

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

[@Im.sarup1111]

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

[@sanathsaja9840]

Good lesson

[@shaykh_dubai]

Gained some quality knowledge from you sir👍

[@disauyanmis5933]

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

[@PowerExbyJitendra]

Great

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

[@maqsoodali3127]

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

[@AliKhan-om6yd]

Superb ... Very Nice. Stay blessed Thanks

[@PowerExbyJitendra]

Thanks Mukarram Bhai

[@muhammadmobeen7160]

All the best

[@PowerExbyJitendra]

Thanks Mobin Bhai. Please continue your support.

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

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

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

[@forgottensharma]

isko save kis format me karna hai.

[@Nicky3286]

THANK YOU SIR

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

[@Grandkidsmovies]

Splendid... Super....

[@PowerExbyJitendra]

Thanks Azhar

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

[@muhammadalamnizamani1087]

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

[@shanikhan1854]

Most helpful video

[@PowerExbyJitendra]

Thanks khan sahab

[@nimeshpateldesad3016]

Sir keyboard se save butan ke se bana te he

[@gajendrasingh9486]

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

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

[@_the_chitransh]

Kya isi trah ka form Google sheets me bhi banaya ja sakta hai?

[@PowerExbyJitendra]

Nahi

[@shivkumar-er8wx]

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

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

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

[@nileshss9123]

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

[@PowerExbyJitendra]

So much thanks Nilesh

[@maheshrajapaksha4672]

Good job

[@PowerExbyJitendra]

Thanks Mahesh ji

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

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

[@RikhiRY]

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.

[@muhammadmobeen7160]

Excellent

[@PowerExbyJitendra]

Thanks Mobeen

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

[@muhammadhussainyousaf5581]

Very informative video.

[@PowerExbyJitendra]

Thank you sir

[@truptispassionforcooking3401]

Thanks Sir

[@PowerExbyJitendra]

Thanks a lot

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

[@akbarhosen5215]

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

[@ujjwalpanda79]

Thanks Dear,

[@PowerExbyJitendra]

You are welcome Abhiraj

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

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

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

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

[@learnteach1228]

boss if formulas are apply its not working in macro; please clear me

[@selwynjoseph3717]

Very usefull sir

[@PowerExbyJitendra]

Thanks

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

[@rimchaudhary8092]

How to join cancel button in this program?

[@viswanathancr2801]

good video

[@mangalsinghchauhan8899]

How to make data uneditable after transpose into database.

[@soorajkumbla888]

Sir macro waala excel sharing mein Rakh sakte hai?

[@PowerExbyJitendra]

Bilkul

[@soorajkumbla888]

@@PowerExbyJitendra thank you for ur prompt reply sir actually mein try Kar Raha Hu Sir is it possible if we run macro from one excel and we get data feed in on other excel?

[@PowerExbyJitendra]

Yes ti is possible. Iske liye aap hamara ye video dekh sakte hai: kzbin.info/www/bejne/mKPShZ6Ye5Z8idk

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

[@nukiereach1181]

When i enter data again my data is not save under the first one. Its duplicate on the first one what shound i do ?

[@princebhatti4937]

A.o.a may jab Bhi data save karta hoo too Jo phly wla data ha wo out ho jata ha aur new data save ho jata ha

[@sunilshrestha5073]

If the wrong entry is submitted then how to correct?

[@md.mominulislam7498]

thank's

[@PowerExbyJitendra]

Thanks

[@NasirKhan-bl3xi]

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

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

[@EarthLearner]

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

[@nilkamalkumar1015]

Sir hospital ke liye ek data entry ka video banaiye

[@PowerExbyJitendra]

Ok ji zaroor

[@SATNatureQuest]

for data entry easy to create thanks but after dataentry any modification correction reqd it will be fetched?

[@PowerExbyJitendra]

it can be manually only

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

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

[@shaileshtapadiya2456]

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

[@PowerExbyJitendra]

Please use 'use relative references'

[@shaileshtapadiya2456]

@@PowerExbyJitendra sir nahi ho raha hai

[@rajvanshi8458]

Sir maine es format me maine sheet to banaya aur micro bhi sahi set kya per ye ek hi cell me entry ho raha hai dusre me nahi ho raha hai

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

[@vikas45000]

Sir My data is not transferred to other sheet. Pls help on this

[@SehrawatFitHealth]

shandar video 🙏

[@PowerExbyJitendra]

Thanks dear

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