Hello Sir मैंने आप का वीडियो देखामैंने आप का वीडियो देखा मुझे बहुत ही अच्छा लगा लेकिन मैं चाहता हूं कि यह बिना बटन के काम करें जेसे ही में डेट सेलेक्ट करु तो डाटा ऑटोमेटिक extract ho k दिखा दे
🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l सर हमारे data में लगभग पंद्रह हजार Items और Items code दिए गए हैं, इस पर auto filter, cell columns row highlights, कैसे लगाए, search बार बार items code wise करना होता है, oracle से item code copy करके इस list मे paste करके check करना होता है, कृपया मार्गदर्शन करे please l मदद करे सर please 🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l
This is Excellent function...CAn u suggest how can i VIEW LATEST DATES WISE DATA AFTER USING FUNCTION (REFRESH) and further how to by default add new items in drop down
In dynamic filter without VBA, how to search two words together in search box, for example if "Deepak type ,it's appear in result, if type "Deepak-Edu-world" in search box, it's not appear in result at all
Hi... I want to develop a small Excel based tool for routine work... Anybody, staying near Electronic City, Bangalore may be of great help from... So that I can have timely interaction in developing the tool.. anybody interested may please respond..
Nice Video , sir one question hi . Old Purchase list hi or new Purchase list me kuch item ke price change huye hi. List bahut lambi hi. To kase change karenge. Advance filter se ho jayega
REALLY VERY HIGH LEVEL KNOWLEDGE ATTAINED IN UNDERSTANDING MACROS & SORTING....I HAVE A QUERY REGUARDING DYNAMIC SORTING WHILE RECORDING A MACRO. IF U CAN PLS HELP ME OUT, IT WILL BE YOUR GREAT KINDNESS.
Dear sir Thank you for your tips It's working But sir when we close and re open the excell the farmula or macro don't activate Please suggest me a solution....
Advance filter me jab paheli bar filter kare to data milta par usme dusra nam badalte he to data nahi dikhata uska problem solve karna plz me Win 10 me office 10 use karta hu
Video is good. But at last when u add a new entry, u showed that filtering date feild. But does the product name u add will show product drop down? May be not, it is not dynamic as like as the video. Thanks 😊
Very nice information brother i am new learner i have it company employees but not my growth my manager many time told me learn you extra knowledge that time give mi promoted so i learn excle thanks you i like this video to support me i have many esseu can you give mi support
Sir aap bahut achcha samjhate hain, sr register jiske page apin button sw change hote jate hain, aur student ka data ek aheet se susri aheet par bane register men fill hota rahta hai, uske liye bhi please video banado.
Bhai deepak ji without vba kha h advance filer aapne macro record kra to h jb hum code direct write kre pata ho to ya rec kre baat to ek hi h vba hi to huaa
Sir Whole sale medicine ke liye GST Invoice tou bana lenge par Purchase entry kese karenge exel pe Or naya batch ka maal kaise Dikhayega sir plzz Talk to me sir nahi tou hum mar
Hi .. Mere pass 1 sheet 10,000 rows (data) 1 sheet hai and another sheet 500 rows (data) ki 1 sheet mai chahtaa hu ki 500 rowr ki sheet me half data hai uski baki half data 10,000 rows ki sheet hai.. Mai eesse filter kaise karsaktaa hun.....?
सर। कृपया बताइये जैसे एक एक्सेल शीट में 50 (आइटम) फ़िल्टर वाला डेटा है। मुझे फ़िल्टर डेटा को एक एक करके प्रिंट देना पड़ता है 50 बार। कुछ ऑप्शन बताइये जिससे सभी डेटा एक साथ प्रिंट हो जाये filter wise ।।
सर मुझे एरियर सीट बनानी है मै चाहता हू कि यदि मै तीन महीने के एरियर का चयन करू तो टैबल मे तीन लाईन मे ही एरियर बने और यदि चार महीने के एरियर का चयन करू तो चार लाईन मे ही एरियर अपने आप अपडेट होकर गणना हो जाये इसके लिए कौनसा फॉर्मूला काम आयेगा। Sir I have to make arrear sheet, I want that if I select three months arrears, then arrears should be made in three lines in the table and if I select four months arrears, then the arrears will be automatically updated and calculated in four lines. Which formula will work for this?
Res Bro 🙏 please upload Vedios on TAX TAXES TAXABLE INCLUDING PAN Previous year Assessment yr how to apply formula VLOOK FUNCTION each and every formulas,having columns PAN NAME ASSESSMENT YEAR SECTION DATE DEMAND IDENT NUMBER DEMAND AMOUNT, PIVOT TABLE FILLTER etc.🕉️🇮🇳☪️✝️☦️🙏
I have 1000 number of data in one sheet ie 1 to 10 standard 100 each, now I have to select top 25 data from each standard and want to paste in different sheets.. In there any shortcut way or formula for this task. Currently I am sorting it from filter menu and paste it to different sheets one by one standard. Please reply
Hello Sir मैंने आप का वीडियो देखा मुझे बहुत ही अच्छा लगा लेकिन मैं चाहता हूं कि यह बिना बटन के काम करें जेसे ही में डेट सेलेक्ट करु तो डाटा ऑटोमेटिक extract ho k दिखा दे
सर मेरा एक प्रश्न का निवारण कीजिए मेरी 33 एक्सेल शीट है वो डिस्ट्रिक्ट वाइज है तो मुझे इस सभी सीट का डाटा ऑटोमैटिकली सब शीटो का डाटा डिस्ट्रिक्ट वाइज आ जाए और में वो 33 सीट में कोई भी डाटा की सीट के डाटा को चेंज करू तो वो अपने आप मास्टर सीट में चेंज हो जाए ऑटोमैटिकली
Sir i have employees who were appointed in the year 1980.,81 85,90 ,97,2000,2003,2007,2017 ,2020 With there there employees id id801274,id816374,id856397,id901281.....…......so on now i have to sort the employee by there year id i.e 81 represent the year of appointment sir, plz sort the employee by there year of appointment i.e is who appointed first is senior by there seniority
Sir mujhe data filter kar ke next sheet Mei chahiye but jias sheet se data chahiye usme ek button create kare or usme micro use karke Saredata next sheet Mei chlajaye
Sir please help me I am stuck with the advance filter, I have huge data but I can not run the formula with advance filter sir what I want is if the logical test is true than pull out the data on another sheet if the condition is fulfilled and run the formula for example if(A1:A50,"2019-20",Z10+B50-C50,ELSEIF(A1:A50,"2020-21",Z10+B50-C50 minus the col value where the condition is "2020-21")) Sir please help me in this formula that I can not run at present
Good morning Sir Ek help Chaie thi !! Jaise main Criteria range suppose 3 Heading leta hu .. Macro ko stop karne se phele M Criteria range par click karke macro ko stop karta hu Toh data sirf vohi ek heading ka record hota hai , bakki 2 heading ka nahi !!! Please help 8954054048
Dear Deepak Sir Guruji, I have learnt much from you. I am a principal in cbse school. Because of your videos I have done Dhamaal several times regarding creating Admit cards and report cards. Thanks guruji.
I have subscribed, my question is, I want to make a custom list seniority wise, like I have four names, anil, sunil, Manish, rakesh, these nAmes are in sîeniority sequence, when I put these names in any table, it should automatically filter , senior should automatically shift to uper cell and junior to below cell,
Hi sir Very nice and awesome video hai.💥💫👍 iss may Total amount ko kaise le. Means data may agar amount hai toh particular date ka Total amt aa jaye. Pls bataye.
Hello. Ur videos are very useful. I like it. Ap ek video or bna dijiye..agr hmare pass excel file me multiple tabs hai for exp 200 tabs h ..or hme beech beech me hi kuch tabs use krni h to baki ki tabs kaise delete hongi one time me..kya iska koi easy way h ?
Mera to dusre sheet ya naye workbook pe advance filter nahi kaam kar rahe.Ek popup box aa rha hai aur usme likga hai ki "you can only filter data to your active sheet."What will I do?
Sar aapka sikhane ka Tarika bahut hi achcha hai aapka yah pura video dekha hai... Bahut hi useful video hai... Lekin ek problem kar dijiye please.. data mein se aapane bataye hue tarike se dusri seat per data filter hoke to aa jata hai Lekin data me Jo repeated Name hote hai vo hamen nahin chahie... Hamen risult me sirf unique name hi chahie to vo kaise ho sakta hai?? please help me..
Mera data hajaro me jata hai, aur usme muze 800-1000 entries ko filter marna hota hai, to kya mai entry type karne ke bajay use copy-paste karke data filter kar sakta hu?????
Agar Mobile or Laptop ka data ek sath nikalna ho to kese karenge...item name increase bhi ho rahe hai or decrease bhi ho rahe hai....har baar alag alag data ko search karna hai...jiske liye hame auto selection karna padega......to uska dynamic kese banayenge....