How To Automatically Transfer Data To Another Sheet In Excel || Using Advanced Filter
ฝัง
- เผยแพร่เมื่อ 13 ก.ย. 2024
- How To Automatically Transfer Data To Another Sheet In Excel || Using Advanced Filter How To Automatically Transfer Current Dates Data Daily basis To Another Sheet In Excel without visual basis vb. using the dynamic advanced filter and a small recorded macro. macro will do same advanced filter task again and again and macro will automatically run each time when worksheet will be open. this video is helpful if you want to transfer data automatically daily basis according to dates. how to automatically transfer Save data from one sheet to another in excel hindi - in excel 2007 2010 2013 2016 without any formulas just using macro and advanced filter in excel. transfer data from one excel worksheet to another automatically.
#TransferData
#AdvancedFilter
#ExcelMagicTrick
Download Training File: drive.google.c...
ADVANCED FILTER VIDEOS SERIES:
1. Advanced Filter in excel in Hindi - Auto VS Advanced filter
• Advanced Filter in exc...
2. Filter Data To Another Sheet In Excel | Using Advanced Filter in Hindi
• Filter Data To Another...
3. How To Filter Data For Blank Cells In Excel | Using Advanced Filter In Hindi
• How To Filter Data For...
4. Advanced filter unique records only in hindi
• Advanced Filter In Exc...
5. How To Make ADVANCED FILTER Dynamic || Auto Updating || Filter To Another Sheet
• How To Make ADVANCED F...
You Should Also Watch These videos:
how to automatically transfer & Save data from one sheet to another in excel || HINDI • How to Automatically T...
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
Dipak ji aapke jesa koi nahi. love to see your videos. jara bhi bore nahi hote.
Dhanyawaadh Aapke Excel VDO s se Kuch seekneku milraa dhanyawaadh
Jo bhi muje chahiye hota hai wo apse mil jata hai....thank you so much
Thanks for sharing this video. Great, it's very useful. Using this video, I solved my problem.
Dhanyawaadh.. apke Excel VDO s kuch seekneku milraa dhanyawaadh
Thank you sir
After watching your video, I have created a full year sale / purchase / Ledger file. Fully automatic ..with hyperlink for my footwear shop
One's again thank you sir
Thanks for video sir...
Hi Deepak thanks for everything. I have to make inventory sheet every day to keep records for bar sale and stock. Remain maximum I understand by your video only concern is "Is that possible today's closings stock become next days opening stock automatically. If possible kindly share a video.
Thanking you in advance.
Regards
Diwakar
Good one
मेरी प्यारे भैया जी इसी ट्रिक का मै दीपक जाला के इंतजार कर रहा था, thanks a lots, and again thanks bro
दीपक जी वा क्या बात है बहुत ही मजेदार है
because of you people only, youtube became a knowledge-based and interesting app thanks
Superb..
Good evening Mr.deepak thank you ..Aap Excel classes ki Jo video bnate h wo mere liye to Bahut zyda use full hoti.. Maine apki en videos se kaafi kuchh seekha h.. Jo Mujhe mere job m kafi help krti h. But Mujhe numbers k sath m Jo text likha hota h.uske sath m kisi bhi formula ka use nhi KR pati...For example kisi colunm m AGR (12lac) aise likha h aur agr hame sum ka formula ya kisi aur formula ko use krna h . To kese krenge.....I hope aap samjh paay honge ki Mera qeustion Kya h.. Please es pr ek video bna dijiye sir....
What an extra ordinary tallent person you are.....!!!!!!!
Hi deepak sir thanks sir apne mera bohot muskil problem solve kardia...
Super sir
Sir aap PF se related video upload kar dijiye
Bhai 1 form ho jis se hum Daily banaye or day 1 data os me or dosre din ka dosre din me jata jayen.
Thanks for information about data
Deepak bhai kya baat hai 👍👍👍👍
दीपक जी आपने जो सिखाया वो बहुत सारगर्वित है। इसकेलिए मै आपको धन्यवाद बोलना चाहता हुँ।
Hi sir, it's amazing video. I m new to excel learning but ur video is superb n easily understand. One query sir, can we take data from different files worksheet n how to run macro?
Excellent sir
life is not a game where you will get second chance.....
Amazing sir ji thanks
Your videos are very helpful... Thank you for sharing...
very beautiful explanation
Hello Deepak, your video is very helpful. I am extracting data from a master sheet to sheets for each Year in Excel 2016. I am facing 2 problems:
1) The copied data is not copying Formulas, only values. It would be nice to have formulas copied as well.
2) When I change the copied Annual sheet into a Table (ctrl/T), the macro stops working to refresh the data.
Your input is appreciated, thanks.
Deepak Bhai Excel mein bil kaise banaye uske upar ek video karke
This was a great video learn something really new
Very good and very well explained
Thanks 😊
Amjad
Nice video
Great
Thanks sir Danayavad
jai ho sir ap ki
ap ke computer video se
kam eassy and assn
ho gaya hai
बहुत बडिया
I always follow you
Thank you sir
excellent 👌👌very useful
हॅलो सर,
मुझे आपका यह व्हिडिओ अच्छा लगा.
मुझे एक मास्टर शिट बनानी है और उसमे तीन बटन बनाना है और जैसे ही मै उस बटन पर क्लीक करू तो वह डेटा उस शीट मे जाना चाहिए दुसरा बटन दबाने के बाद दुसरी शीट पर जाना चाहिए और तीसराबटन दबाने पर तिसरी शीट पर डेटा ट्रान्सफर होना चाहिए और आपको वो शीट कैसे भेजे...
Thanku sir apki sari video bhut helpfull hoti hai
Jai hind vande matram sir 🤗🤗🤗🤗thank's a lot 🙇🙇 luv you sir🤗🤗🤗🤗
♥️
thanx
super Depak sir ,,,, i am from karachi pakistan
Good evening sir, I have always watch your tutorial, thanks for your support. Can i direct dial saved excel sheet number in my android mobile through excel sheet.
Gr8 work- God bless you
Deepak, You are a great teacher. I have sheet say " Intake Sheet" where you enter all the tasks that your are assigned. those could be of different projects. I need a dashboard that displays the tasks seperated by project that could filtered by due date ( today,week, month year) and also filter by status (to be started, inprogress, completed). I think this can resolve most of the problems who are not oraganized lke me
Very nice video
गजब
Nice
Sir daily cash collection ki excel software banai na
Very nice
Please sir send me. School attendance sheet.
My emai id.
prashantssm72@gmail.com
Very nice job. I'm impressed
Sir, meri ek problem h , FYI me construction field me hu. mene ek data sheets ready kiya h, plots wise but mujhe us data sheet me se ek summer sheets Banana h jiske andar ME example plots no 15 put karu to US plots par kitna expenses kiya h wo US data sheet se nikal kar summer m show kare, please mujhe suggest kare ki kis formula se ye possible ho sakta h
Dear sir excel ka ek video laka ayiye zisme begineer to advance level ka pura sikhne ka mauka mile..🙏
Hi sir, nice video. Dear sir will you please tell me how we take data from different files worksheet and how to run macro
Sir muze ek signage company ke liye daily production managment ke liye excel me work karrna hai, jisme daily work process ,job card filling, database sheet transfer to work process sheet, remaining work, completely work count in percentage, inventary stock, sale, purchase entry, employee details, employee attaindance sheet, monthly income proffit loss, ya sabhi function one module me krne hai, to kya aap ye kr sakte hai? Kar sakte ho to plz rply karna
Great sir jee...
Sir ek request hai.. me multiple bank account ki daily entry ek sheet pe karta hu.. to karna ye hai ke usme se bank a/c vise aur cash ki alag sheet pe date vise data transfer ho jaye.. in short daily entry me se sort ho ke alag alag a/c vise sheet ma data transfer ho jaye.. please sir ek bar istarah ki ek sheet banakar video post kar do..
Very useful Tutorial, Thanks.
Ahi jarurat tha. Thanks bhaiya
excellent
Sir, How to trnasfer continue data from one month to next month in other excel sheet.
Hi Sir i have a question with you .Can you teach us how to make website on google .In this way, we make a website, , sir, teach us how to make that website.
Good work
sir mere stocks ka data hai jo har 15min pr update hota hai . mujhe wo copy krana hai automatic new sheet pr . agr koi help ho ske sir .. i will be thankful to you.
Your video help me so much but in-spite I make some mistakes
Really appreciate you
Sir Please make videos on Chatbot for business with and without using server (for small and large scale business🙏🙏🙏).
ms word main aik sheet ko kaisay other ms word ki sheets say link kia ja sakta hay ?
Bai ji apne excal ka data kisi or laptop ja computer me kaise open kare
Sir ho sake to kitchen & wardrobe cutting list software excel me banana sikha de..
Sir you are excellent. Giving very impressive way to teach. I have a problem how to manage different sheets from one excellent sheet automatically. For example if we want there are different country name in a column. I want automatically country name complete data transfer to its relevent sheet. Plzzz
Sir help plz
Hello sir
Sir Attendance sheet par alag alag deta hota hai use ek sheet per kaise show Kare
Example=name,roll number, month, month main kitna din aaye Hain, Baki bahut kuchh data hota use show kaise......... please sir
🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Excellent, great job, thanks for this, but i have one question can it work on mobile
you deserve I appreciate, you
दीपकजी बहुत ही intresting toppik दिमाग मे आया है please कोशिश जरूर कीजियेगा।
जैसे एक शीट पे डेटा इंट्री फॉर्म बनाये औऱ उसमे जो डेटा इंटर करे वो डेटा अलग अलग कोड या अकॉउंट न मानलो उसके हिसाब से अलग अलग फाइलो में ट्रांसफर होता जाये। क्या ये हो सकता हैं?
Ya blkul.. Please wait.. I ll try it m and publish video shortly
Vba se ho jayega
Bhai this was really helpful. Can u help me one question
How can I update current sheet data previous sheet without deleting previous sheet data it needs to be add one by one
Hi deepak . Could u please help me to make macro from one workbook to another or is it possible in different system to get data update in master sheet from different computer
Pl. Sir make vedio how to automatically back up of shared macro file to another folder
,good knowlge
Excellent 👌
Sir Google sheets K leye Batadijiya
Thanks
in attendance sheet , kindly tell how to restrict/lock data entry in sunday column ....
in other days data validation work. but dont want list in sunday coulmns.
Bro I want my mastersheet data of 25 columns (catagory like name, vill, blood gp) and 50 rows (50 individuals names) should be transfer to 4 different sheets, where as all sheets does not required all catagory. Can we set a code No for characters if we press the No all data of individual displays.
Hello sir ek sheet par heading likhe to other sheet par automatic aa jaye
Deepak sir i have work with many company like overseas . So i want data base if i sent you file can you help me for my work ?
Sir mere pass ek bht badi sheet hai jiske ander 15 jitni aur sheets h .. Sab sheets ek dusre s formula's k through connected hai ... Ab ek excel file se muje 10 file aur bnani hoti h .. Like iske kuch particular cells ka data koi particular file me copy krna parta hai ... Kya hum inke bich me connection establish kr skte h kya ki main file me kisi cell me koi data input kro to baki sab files me automatic aa jaye
Hello @deepak .
Please make the same video which displays the last one week data or last fortnight data on each current date while opening file
You deserve respect and love.
Can you please suggest any link that how this can be used in google sheet? please reply.
Month vise kar sakte hai
Can this be done in google sheets?
Very nice.
Dear Mr Deepak, I need to record a macro regarding solving "VBA Code to insert a new row in the cursor position with formula, validation, and format copied from the adjacent upper row without data when a button is pressed in excel? I tried but something always went wrong, I Needed Debugging. Please help.
Dynamic video
SIR VIDEO BUHAT E USEFULL HI
SIR AGR ISS AGR ME ISS KO SALE SHEET ME LAGAON OR IS K SATH ME ISI DATE K EXPENSES ME DEKHANA CHA RAHA HO TO KESY KRON GA THORA REHANUMAI KR DAIN THANKS
Same aise hi hoga... Aap today ki date ki jaghe koi b date likh sakte ho.. Jis date ka data chaiye..
awsome
Deepak bhai
Ek video raw material ke planning ke uper bhi bnao na jisme shortage aur raw material ki planning kr sake bom ke hisab se
Please
🤗
@@DeepakEduWorld bhai phir kab aarhi hai video m waiting
Super
Agr sir hum daily ye record kisi or sheet pr transfer bhi krna chahen jese hi date change ho ya day change ho ye usi date ki ek sheet banay or ye sara data us ma transfer kr dy phir new day ka data isi sheet pe save ho day change pe transfer ho jay etc
mai aap ka video dekha kar sikhata hoo aap mere guru hi aap aise hi video banate rahanaa plz aap isme powerpoint video kay bana sakate hi to acha hoga aapakaa vidayrthi makarand thankyou...
Sir, this is very helpful, but I want to save current date wise data also with previous date data.
Matlab, previous date ki jo data hain wo bhi rahain, oor current date ki data uske niche se save hota jain.
Ex: 12/04/2021
13/04/2021