Magical SearchForm in Excel | No VBA |

Поділитися
Вставка
  • Опубліковано 25 сер 2024
  • Magical SearchForm in Excel | No VBA | @PowerExbyJitendra
    "Unlock the secrets of Excel with the Magical SearchForm! In this easy tutorial, discover how to create a powerful SearchForm in Excel that will transform your data management experience.
    Learn step-by-step as we guide you through the process of setting up this magical tool, allowing you to efficiently search and organize your data like never before. Say goodbye to endless scrolling and hello to a more streamlined and enchanting Excel experience! 🚀📊 Don't miss out - watch now and elevate your spreadsheet skills to new heights!"
    ✅For more videos please subscribe our channel: / powerexbyjitendra
    Sample workbook:
    ==============================
    docs.google.co...
    ==============================
    Playlists of our top videos:
    1. Stock Management System in Excel
    • Stock Management Syste...
    2. Advanced Excel Formulas
    • Advanced Excel Formulas
    3. Awesome MS Word Videos
    • MS Word
    4. Conditional Formatting in Excel
    • Conditional Formatting
    5. Data Entry Form
    • Data Entry Forms
    6. Custom Number Formatting Tricks
    • Custom Number Formatting
    7. Recent Uploads
    • Recent Uploaded Videos
    8. Best Excel Shortcut Keys
    • Best Shortcut Keys in ...
    9. Power Query Tutorials
    • Advanced Excel Power Q...
    10. MIS Report in Excel
    • MIS Report
    11. Excel PivotTable
    • Excel Pivot Table
    12. Task Tracker or To-Do List
    • Task Tracker or To-Do ...
    13. Excel for Accounting
    • Excel for Accounting
    14. Excel Lookup Functions
    • Excel Lookup Functions
    15. Filter
    • Filter
    -------------------------------------------------------------------
    Video is created by Jitendra
    Published on Powerex by Jitendra
    Language of this tutorial is Hindi.
    #searchform
    #powerxbyjitendra
    #excel
    Subscribe on Telegram:
    t.me/powerexby...
    Contact Us:
    Instagram: ...
    Facebook : / powerex-by-jitendra-10...
    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.
    Thanks

КОМЕНТАРІ • 52

  • @sanjeevkalyan3428
    @sanjeevkalyan3428 6 днів тому

    Very Helpful vidoe thank you

  • @ashutoshshukla8588
    @ashutoshshukla8588 12 днів тому

    Sir kindly enter any value in text box and count before this this entry already data available

  • @imranshahid9617
    @imranshahid9617 7 місяців тому

    Sir very nice information you are providing and in also very nice way.

  • @Dedevilofficial
    @Dedevilofficial 7 місяців тому +1

    awesome thanks sir very informative video ❤❤

  • @Dedevilofficial
    @Dedevilofficial 7 місяців тому +1

    sir mini banking system bnana ho excle per to kasy bnay jis ma client ka account opened kerny ke information name email phone number photo add kery .phir client ke bank ma dep osit payment information transaction information sab kouch. please create video . assignment ma na complete kerni ha. please create video

  • @opgamerhacker2780
    @opgamerhacker2780 7 місяців тому

    Sir is mai koi naya data add karen jis mai niche add ka button bhi ho aur sath mai edit ka bhi possible hai sir

  • @JK-jo7by
    @JK-jo7by 6 місяців тому

    Sir namelist ki range badani ho to kya kare aur data ke liye bhi please

  • @mm1074040
    @mm1074040 7 місяців тому

    Excellent work sir❤

  • @mdekram9177
    @mdekram9177 5 місяців тому

    More than awesome

  • @imranshahid9617
    @imranshahid9617 7 місяців тому

    Nice information

  • @hluteachhangte7636
    @hluteachhangte7636 5 місяців тому

    very helpful, but i have a problem when there is two or three different persons with same name in the list. When search it only shows the person who is first in the list. How can i solve this problem?

  • @kamrulislam3238
    @kamrulislam3238 5 місяців тому

    This format will support Google Sheet?

  • @ZahoorAhmed-oj2cd
    @ZahoorAhmed-oj2cd 10 днів тому

    Sir datatable ki samj nhi aya kindly rehnumaye kare

  • @anadkatpriyank4726
    @anadkatpriyank4726 7 місяців тому

    Dear sir thank you so much for this video..❤
    I have a query
    In this search form i made one box of date.
    The problem is when date is not in database so in the box i see the sample date so plz help for this. How i can remove this.

  • @bdtiwari05
    @bdtiwari05 7 місяців тому

    Dear sir 🙏 can you Make a video (in continuation to your previous video on cash receipt and payment ) on Day book with cash n transfer transaction(example-bank and interbank transactions) and ultimately these transaction will reflect in to (up to 20 + or more) various different ledger and lastly in General ledger balance book (balance sheet ) like any Bank books. Pls reply

  • @kamraniqbal9609
    @kamraniqbal9609 7 місяців тому

    New data entry karna ho to woh show ho ga kya ans plzzzz

  • @musavvaralisaiyed8119
    @musavvaralisaiyed8119 12 днів тому

    इस फॉर्म में सिर्फ नाम से ही सर्च होगा? या दूसरी डिटेल्स से भी सर्च कर सकते है?

    • @nanhe1216
      @nanhe1216 9 днів тому +1

      Only name

    • @atanuroy3548
      @atanuroy3548 7 днів тому

      सिर्फ नाम से ही search होगा.

  • @HardeepSingh-zd1ge
    @HardeepSingh-zd1ge 7 місяців тому

    Sir ji Excellent video tusi name te search kiti hai eh same formula contact te search work nahi kar reha ji please request a sir ji same search contact list te v video upload kareyo ji

    • @PowerExbyJitendra
      @PowerExbyJitendra  7 місяців тому

      Please watch this video:
      ua-cam.com/video/8jhxr6i-r1Y/v-deo.htmlsi=0HGrxE-BecTSelZu

  • @LEARNWITHPASSIONGK
    @LEARNWITHPASSIONGK Місяць тому

    Sir agar database me 2 name same hai to kaise search hoga

  • @sajidbpl1
    @sajidbpl1 Місяць тому

    developer tab excel not showing listfillrange in excel 2016

  • @mdmahibulislam8691
    @mdmahibulislam8691 7 місяців тому

    ❤❤❤❤❤❤❤❤❤❤❤❤❤Nice

  • @MANAVSARKAR-jc9kp
    @MANAVSARKAR-jc9kp Місяць тому

    well

  • @ManojGupta-nl8fj
    @ManojGupta-nl8fj 4 місяці тому

  • @MOVIESHUB96k
    @MOVIESHUB96k 7 місяців тому

    Sir, made serch from in vba user form

  • @Irfan.Realtor
    @Irfan.Realtor 6 місяців тому

    Duplicate name ko search me kese layen

  • @cbcoksa8626
    @cbcoksa8626 2 місяці тому

    if employees more than 1 with the same name .... ?

  • @martandpangrekar2628
    @martandpangrekar2628 7 місяців тому

    Sir ye search date dusre sheet pe save hone ke liye kya kare

    • @PowerExbyJitendra
      @PowerExbyJitendra  7 місяців тому

      Ye pahle se hi saved hai

    • @martandpangrekar2628
      @martandpangrekar2628 7 місяців тому

      @@PowerExbyJitendra Jo data, data sheet se data search form pe aa raha hai yo data alag se dusre sheet pe kaise ho ye bataye please

  • @khaplwaziristan
    @khaplwaziristan 7 місяців тому

    Sir power point mai intezar krun ga mare pass 2 month hai pr mai jaun ga gao waha pr net kam nai kr raha .

  • @dejenealemu1292
    @dejenealemu1292 17 днів тому

    Dear power don't work your vlookup formula #N/A