How to Extract Data and Create Reports Automatically in Excel

Reports | Database | Search by
Click Below link
/ @daoodcomputeracademy3406
How to Create Userform in Hindi Font
• How to create Userform...

[@shakhawathossain1558]

Sir , I am from Bangladesh and like this very much, have a nice time

[@Drkalaamarab]

Excellent 👍 description.
I want more on excel automation please.
Your detailed explanation is awesome .....
Please more on excel automation .....

[@tzitmalerkotla7818]

Thanks bhai, very useful, Now I getting expert in this after watching your priceless videos.

[@ifaniabu]

Assalamu Alaikum Parwes Bhai Jazakallah Kahir very use full am new VBA programmer

[@khalidmajeed2886]

sir your explanation way is too good. Bohat Umdah.

[@AzamKhan-vz5er]

Thank u sir. out standing teaching.

[@vaishaliparekh9848]

This video has helped me a lot amazing

[@amikhimji]

Hi very good video its working perfect thanks

[@ravindrapatel4591]

Excellent work done for report in Excel. If any date control in Excel VBA video available then inform us.

[@snehal4582]

Going a step ahead
Also, Please make a video to perform substraction in each id from last iteration of two columns.

[@arsalaniu]

Nice Video, it is very helpful.
How to do the same if data is in table and want same to be extracted in tabular form.

[@sniperking7555]

Nice explained,it's helpful

[@ytsngroup8257]

السلام علیکم
Bhai apki to sari vedio bahut acchi trike se samajh me ati hai or jaise ap samjhate ho usse to jise excel ki koi knowledge na ho vo bhi Sikh le jaise mujhe excel ke bare sirf itna pta tha ke excel account ke Kam ata- hai kaise ata- hai mujhe nhi pta tha par ab apki vedio dekh kar maine VBA code Sikh Liya hai or form vagerah bhi bna liye hai Mai madarsha me Kam karta hu mujhe apki vedio se Kafi madd Mili shukriya Dil se

[@aanofindia]

Great Job. It's very useful programme. Can you please tell me which screen recorder you use?
Thanks for this video

[@Multanvlogging]

Brother your videos are very helpful, umair from pakistan.

[@daoodcomputers]

Thanks for watching

[@AshishKumar-uk9gi]

Wow, Amazing Sir.

[@daoodcomputers]

Thanks for watching

[@saurabh17sharma68]

1st like bhai
balle balle
nice video

[@daoodcomputers]

Thanks for watching

[@naveedhussain3368]

Sir you have Excellent methodology and way of explaining.. you r the great.. Please, explain can I make separate class registers from main Admission Register by using these VBA method.

[@nextstep2239]

You are best teacher in the world 🥰

[@narendragajbhiye166]

Useful video sir thanks

[@daoodcomputers]

Thanks for watching

[@ahsau2968]

Really helpful , how can i extract data for month.. example i have xls sheet which contain ( Employees name , activities planned for this Financial year , date on which activity is scheduled ) , how can extract activities planned in particular month for particular person..

[@kamalkhaja9508]

Very well explained

[@nasrhorizon6187]

very nice video sir
if i need some solution and tell you want actually i want can you make video on that to me

[@benetcherumannoorkara156]

Use full vedio. I wish to make this one in VBA USERFORM , can I use same code ????????

[@mansoorahmed2484]

Nice Training..!!!

[@daoodcomputers]

Thanks for watching

[@paraskumarsingh3967]

THANKS SIR

[@daoodcomputers]

Thanks for watching

[@rakeshmlearningentertainme6099]

Nice video

[@manishrawal1529]

Please work on multiple pages in multiple sheets

[@yashparekh22]

Bhai what will be the codings to transfer certain data... Not full data of the analysis sheet just the purchases, closing stock consumption part of food, other, disposal of one location to master sheet

[@BpositiveDoctor]

Instead of pressing that button can we AUTOMATE that Macro too? For running automatically?? e.g. Macro will run after fixed interval of time?

[@shakeel447]

Plz upload complete micros training videos.

[@TutanComputerGuide]

Nice video Sir 👍

[@daoodcomputers]

Thanks for watching

[@tajmahel7342]

timestampe: 7:19
y=sheet1.range("A100"
//you can also use column reference ,A:A

[@nageshwarsoni6712]

Very nice sir

[@ComputerGyanGuruji]

nice video sir

[@daoodcomputers]

Thanks for watching

[@nageshwarsoni6712]

Sir I want to run user form directly in desktop and excel worksheet hide.

[@vivekgupta6553]

Please add some feature like extract data 01 sheet to another sheet with 02 conditions (party name and date range ie start date and last date) just like party wise statement generation.

[@skexcelexpert8021]

Nice video sir 👌👌

[@daoodcomputers]

Thanks for watching

[@rajumasih234]

Nice one sir

[@daoodcomputers]

Thanks for watching

[@jibantaranga4988]

can you do a favor for me? how can write a VBA code for subtracting the time interval between 8 hours of working a person using the input access of user from
6:00Am to 2:00Pm
2:00Pm to 22:00PM
22:00Pm to 6:00Am

[@sK_YasH_7773]

बहोत ही बढ़िया सर जी,,,,हा सर यूजर फॉर्म को डायरेक्ट डेस्कटॉप से रन कैसे कर सकते है सर ,,,,,ओर उसमे फीड डेटा डायरेक्ट एक्सेल फ़ाइल में बिना फ़ाइल को ओपन करे सेव हो जाये सर,,,,इसके लिए कोई vedio बनाओ सर plz

[@aswinks8532]

नमस्ते sir
आप के वीडियो देख कर मैं एक स्कूल सॉफ्टवेयर बनाना चाहता था, और इस चीज केलिए वह रुक गया था ।
Thanks sir...

[@daoodcomputers]

Namaste

[@dharmendrayadav-bw2gp]

Nice video.

[@daoodcomputers]

Thanks for watching

[@alsiddiquegraphics9343]

In this formula can we get the multiple columns data . E.g columns 1,3,10 to 20 . ThanksMr.

[@daoodcomputers]

yes its multiple

[@PradipDas-wb5my]

Bionary plan kaise banate he usi per ek video banaye..

[@anshutyagi4348]

What command should be given if I want to extract data in New sheet??

[@skexcelexpert8021]

Sir VBA ke video sir aur banaye apke video bahut hi useful hai.

[@daoodcomputers]

Thanks for watching

[@asifsirquba]

Sir school ke students ka data jo section wise hota hai agar ek sath ho to us ko kis tarha karenge misal
1st section a
1st section b
Students ki list nikalni hoti plz video dalen

[@nayazahmedahmed6323]

wow great

[@daoodcomputers]

Thanks for watching

[@usmanansari8501]

NYC information

[@daoodcomputers]

Thanks for watching

[@shahzadisrani2616]

Sir Inplace of ID, I use name of Customer because of I sort out by name & ID is not sorted out due to the name of Customer & it gives errors in x side after dim z & my file name is Invoice & I am making current month ledger so can you please add date from - to in it for making easy.
Can you please suggest?
Thanks

[@moesadr3342]

I have a dynamic database table with many columns and rows and would like to have a Macro that can create a printable report for me. The report needs to be showing only a few columns and those records who have certain criteria ( filtered). Like the stage is "Open" and Rank is " A", and/or ............. Wondering if you might have a template to share. Please advise.

[@enaveenkumar4761]

HI, If You have template please share to me also

[@moesadr3342]

@@enaveenkumar4761 I was asking you ????

[@MrShahed1985]

nice

[@daoodcomputers]

Thanks for watching

[@FarahVision]

Excel me PIVOT TABLE me SLICER use krna batayein... SLICER me kis trah data extract krty hain ? complete video btayein plzzzz in detail

[@sagardas877]

Can you please show this without using VBA code only through mecro recoding

[@subhaansayyed3670]

Bohot sahi video hai bhai i need your contact info

[@yuniqb1]

grocery shop ki inventory maintain karne ke liye koi userform banaye jisme sell purchase ke sath customer ka record bhi maintain kiya ja sake..

[@wisdom_stream]

Agar id ke jaga name lekhy awr detail show ho jai to code me kiya changes lazmi hay

[@sanjoydutta4340]

Hi Sir, how can I select 2 Range at a time. I want to run the report by ID 1 to ID 2. I want to see how many entries are done from ID 1 to ID2 by one click.

[@daoodcomputers]

Watch Part 2 of Extract Data Video

[@hamzamehmood3112]

@@daoodcomputers plz send a li k of 2nd video

[@mahaboobhossain5076]

I HAVE A PROBLEM IN HIGHLIGHTING CELL--SUPPOSE I HAVE 12 MONTHS SALARIES OF 12 PERSON. I WANT TO HIGHLIGHT INDIVIDUAL PERSONS SALARIES FROM JANAUARY TO DECEMBER. I HAVE MADE A DROP DOWN LIST FOR PERSON EACH. DROP DOWN LIST FROM THE MONTH STARTING AND DROP DOWN LIST OF MONTH OF TO. IF I WANT TO SEE THE INDIVIDUALS PERSON SALARY JANUARY TO JUNE THE SALARY SHOULD BE HIGHLIGHTED FOR THE MONTHS THAT I WANT TO SEE. I HAVE USED OFFSET FORMULA ,SUM FORMULA AND MATCH FORMULA IN THE TOTAL AMOUNT .PLZZZZZZ HELP ME BROTHER TO SOLVE IT. I WILL BE GREATFUL TO U ALWAYS

[@haqobatil9832]

Asslam Allekum sir i want to use this queries but with copy from one sheet to another sheet. then what is the query

[@daoodcomputers]

Walekum Assalam

[@md.ismailansari135]

Sir mera mobile sop hai uske liye bataiye purchase sell stok profit Los ye kaise bane ga

[@user-mn6wq9nx3p]

मदद करना संभव है। 10 कर्मचारियों के लिए उपस्थिति और अनुपस्थिति फॉर्म तैयार करना आवश्यक है, और प्रत्येक महीने में उपस्थिति के दिनों और अनुपस्थिति के दिनों की संख्या को वर्ष के महीनों की संख्या से अलग-अलग गणना करना आवश्यक है। बहुत-बहुत धन्यवाद

[@vijaysiwahiya]

Bhai same ek Aisha formula do ki same file main kisi 2 date ki range ke beech ka data or mr.a ka puri sheet ka data ek side aajaye

[@kumar99nirmal]

sir kaise koi party k naam se 2 date k bichme kitna stock hai with product all extract kare? plz help me.

[@riazkhan9666]

Sir how to create Auto Ladger
As we Ad Account in chart of account

[@satyajit2019]

Hello
One webpage has some data like name phone and address
I want this data copy and paste one Excel sheet with a header
Is that possible ???? please reply

[@daoodcomputers]

Its Possible

[@satyajit2019]

@@daoodcomputers sorry to say that data comes from a image and paste a excel sheet

[@muhammadmubeen8982]

Hi Dear Perwez!
if we want to sort out data according to ID and also selected one date .. is it possible ..?? if it can does then help me how it can..Plz plz plz ans me ...

[@daoodcomputers]

Thanks for watching

[@muhammadmubeen8982]

@@daoodcomputers daood bhai mene jo question pocha hai please us se related Video bnaen plz .. yar date aor ID Dono se data sort out krna hia mje plz

[@virenderkamboj4176]

Sir sheet me serial number age peche ho gyy unhein serial me lne ke liye kya kre

[@musatenginkeri1823]

Hello sir, How to extract another sheet form sheet1 to sheet2

[@hirendrashriwas8021]

Sir muje same data extract krna hai but drop down list se pls help.🙏

[@ytsngroup8257]

Sir maine apki bahut sari vedio dekhi hai or unse aik Aisa VBA form tyar Kiya hai jisses Mai Apne madrse ka Sara hisab rkhta hu but aik problem hai ki extract data creat report Ko date by date kaise bnaye

[@pancux670]

This is what I was searching for. But first line of code is showing error which starts with x= and ends in .Value
Pls check

[@daoodcomputers]

pura code likho comment me

[@dcpofficemumbai5664]

call data analyse karne ke liye formulas batao

[@sattarlakhana6736]

Pakistan mey it kee talim mey jo classes mey log dakhla letey hain to accaont 3 Mahoney ka cores batata jata hay mugàr
Account ka sujject hee nàhin sikhayajata
Muzeed do mAh kee fees bharney ko mujbur Kiya jata hay to suchai honestly to dharee kee dharee rahejatey hain
Janab indiamey waydey key mutabiq dikha diya jata hay janab

[@nilimasenapati6660]

Namaskar sir.
I tried my best but could not do it.
How to get data from date to date if date is placed under different column in the data base as per the provision . Example
Suppose in the patient data base there are 80 column . Like if a pt visit in April 15 and 30 then the two visit is recorded under two separate column against a row to avoid multiple id entry or to make the id fixed for a patient ;
Each rows is reserved for a pt to record their data and it consists 80 cells under 80 column including date. It is in sheet 1.
Sheet 5 is VBA coding sheet.
Get the data from One date to another date.
But I don't want all records to be reflected.
Particular data under particular column along with the date should be displayed when I run the macro.
Example
column 32 to 61 for date entry.
1 to 31 patient different data.
I want if I run macro in sheet 5 .under column A the date even if there is a twice or more visit of pt will be displayed without duplicacy and some other data under 11 different column to it which is not in order like 2,3,4,5,6,7,8,9 in sheet 1.
How to do it sir
Plz I utterly request you to assist me
Top most urgent for me. If u permit I may send the file.plz respond sir your consideration is highly solicited.

[@islamicworld2561]

Date to date data serch karnya ka b bta do please

[@aftabsabeel8561]

Salam parvez sb yar hame ek chota sa parogram sikhado medical store ke leye mehrabani hogy Allah Hafiz

[@rakeshkabre8447]

Report ko second sheet me dekhna ho to uski coding kis prakar rahegi

[@AhmadKhan-mg3lc]

Aslam O Aalikom G kase hy ap muje
Sir ye bate ke excal sheet ka backup kase lange ?
&
Salary sheet ko copy karne ke bad formula kase ate hy me ne ik salary sheet banye hy but os ko copy karnr ke bad formula un active hojate hy?
Reply must

[@manojsable8482]

Sir muze vba software Estimate bananaa hai.jo 1 code me puraa datarow 1 ke niche 1 aaye pls give idia or ph no

[@aslamkhan-xk9pf]

I want to learn VBA

[@vikashgupta415]

Sir ji ye video thik see samjh nhi paya plz ek baar aur bana ke bata dena

[@daoodcomputers]

Thanks for watching

[@hemanthrajesi]

Thank u sir, but ek sheet se dusre sheet ko kaise karskthahi sir

[@daoodcomputers]

Thanks for watching
yahi tarika hai

[@AshishYadav-xg3hj]

Another sheet ke liye kaise karenge

[@sarfrazawan6370]

Dear Pervaiz, i have tried to extract data but failed can you please help me where i am getting mistake.

[@daoodcomputers]

Thanks for watching
watch steps of the video

[@sarfrazawan6370]

@@daoodcomputers yes i have done thank you.. but another i had already saved file . i tried to apply this formula on that file but failed. first i saved as and saved in enable mircro type and applied the formula but nothing outcome...please guide or give your email so that i can forward that file.

[@siddheswarimatlasentar6129]

नॉर्मल no gst इनवॉइस auto save kase banaya jata hi

[@m.faraz.qureshi9258]

bhai inventory stock ki report k bary m btao yr plz

[@daoodcomputers]

Thanks for watching
Jaldi hi batayenge

[@haidaralitiger7788]

Sir Assalam alaikum

[@daoodcomputers]

Walekum assalam
Thanks for watching

[@nassirmuhammadrafique8752]

can u plz set total amount on extrect deta plzzzzzzzzz

[@daoodcomputers]

Thanks for watching
Use Sumif Formula

[@excelshambhu]

Sir aapne ek cell ko search kiya hai uske badle do cell ka search ho sakta hai

[@daoodcomputers]

Thanks for watching
do cell ko search karne ke liye dusri command deni hogi

[@excelshambhu]

@@daoodcomputers command konsi likhani hai

[@sanjeevgajmir9402]

Extract data sheet VBA code share karo please

[@sandeep-vc6pp]

Sar Mujhe ID ke dwara 1 date se dusre date ke bich ka data chahie to kaise karenge please batayega Sar Mere Liye bahut hi jaruri hai

[@SparkFunnyClips]

السلام علیکم
داود بھائی آپ سے یہ پوچھنا تھا کہ ایک ہم اگر ادارے چلا رہے ہو جس سے ہمارے پاس مختلف ڈونر ہوں جس سے ہم کسی کی ہیلپ کر رہے ہیں اور ہم یہ حساب کتاب رکھیں۔ کہ کس نے اس اس فرد کے لیے کتنی رقم بھیجی اور ہم نے اس کووہ رقم دی۔ اور اس سے ہم نےکتنا سامان خریدا اس کے لئے اور ہم ان کو دے رہے ہیں مختلف اسکیم میں دوست کا حساب کتاب ہم کیسے رکھیں گے۔

[@Zunaid]

Asa software kasa bana ga

[@daoodcomputers]

Thanks for watching

[@avyanshsystemhightech3610]

Mujhe data materials stock sheet Bana ke dena

[@daoodcomputers]

Thanks for watching

[@suhanenteprises6819]

Very nice

[@MithileshKumar-vi4eg]

यदि कई सेलस् मे डाटा हो रो वाईज तब हम डेट के अनुसार डाटा कैसे प्राप्त करे? प्लीज बताए।

[@daoodcomputers]

Thanks for watching

[@daoodcomputers]

Thanks for watching

[@neerajk49]

code to past kar deji sir

[@ramanjeet1111]

copy & past vbs code

[@rafiulalam3883]

Hi, Sir I am Rafi

[@daoodcomputers]

Thanks for watching