Excel automatically save data another sheet without coding
HTML-код
- Опубликовано: 24 апр 2019
- transfer data one sheet to Other
• Excel - How to Transf...
Best Excel videos
• How to Automatically T...
• Excel Automatic Transf...
• Excel automatic transf...
• filter function in exc...
• Excel - Transfer Data ...
• Excel - how to transfe...
• चतुर नाई Barbar अपनी ...
• Excel - save each work...
• Excel - Dynamic Search...
• EXCEL AUTOMATIC TRANSF...
Awesome trick, please do keep sharing useful tips. Thank you 😊
You can try this tutorial also...thanks
ruclips.net/video/rCCIBKhCpNg/видео.html
Yes its really works I tried it & I got success. Thnx
Bahot Achhe Sir...Helpful video
Dear Sir,
Date & Payment are the same in the save sheet. Kindly remove the bug.
सर आप लाजवाब हैं। आपको मेरा सलाम।
Nice, helpful vedio.nice work.
I found what I was looking for through this video. Thank you so much. 🙏❤
Glad it was helpful!
Thank you so much sir
Awesome video. Nice one
Thank you very much sir from Nepal
For macro run
1st make a small tablle.
Then copy the same to a other place.
In the 1st document open the macro
Then format,edit the records as per u.
Then stop recording .
Now in the 2nd place run the macro.
U will get the result.
Pl see sheet2, the date appers as amount.
Thank you.
This is too much helpful for data entry.
Please sir upload video of Advance conditional formatting in excel 🙏🙏🙏
Sir its working properly, thank u for infomation
Very interesting trick.
Thanks mere bro
Great video..thanksss bhai
excellent work done. mei is macro ko bana raha tha ... nhi ban raha tha... ab ban gaya. ab bill mei search ka macro bhi bata do guru kese banega
Thank you bhai
Very good Sir
Its really very short and useful video
Nice men . Please upload in English. For us very challenging from South State.
ruclips.net/video/PnlEEfmF2Us/видео.html
Thanks for sharing
Bro,mko bht need t iss video ka..DIL se thanqu❤️❤️ bht easy way mai ,bina edr udr ki baat kiye smjya h aapne👍😊😊
Aap ye tutorial bhi use kar sakte hai...
ruclips.net/video/rCCIBKhCpNg/видео.html
Bahut badhiya Video
थैंक्स sir ji
Very nice bro keep it up
Brother thnks
Sir. Thanku. Bahut informative video hai. Sir kya hum koi already bani excel sheet ka data bhi item wise alag sheet pe transpose kar sakte hai? Jaise bank wise list of customers
Ha video bana h
@@SAHUTuber sir video ka link bhej do
excellent
maza aa gaya try karonga ek bar
I want the data to inserted below of previous data. How to adjust the macro accordingly.
Although this trick is very useful, and accordingly I made an attempt to automate as guided by you but Macros are not working as the prerequisite is to digitally sign them. Can you guide me in that matter or make a video of its kind.
You can try this tutorial....thanks
ruclips.net/video/rCCIBKhCpNg/видео.html
Thankyou sir. Great info...
Excel ke dusre file me data ko kaise insert Kare Sir
If you add data in row 10 in sheet 1 then ?
Very useful information
But sir android phone me kaise krenge pls
Tell me how can I do worksheet (sheet 1) to invoice (sheet 2) auto fill by only bill no.. (for multiple products in invoice)
Sir ji, This is not working because first you should use paste special in formula cell and second tap on reference when jump to last entry during micro recording. Please make ensure all preparation before video recording then it will be useful for viewer.
ढढढढंढढढंढढढढढंढढढीईईईईईईईढीईईईऔई
@@rajasthanigroup9563 ??
Nice sir 👍
Linking between Excel sheets par video banao
ek sheet pura list ka naam daal kar dusre sheet me jab uska pehla 3 letter dale to wo pura naam mujhe show kre isk liye kya kru? mtlb ek sheet me pura product ka naam type kr diye or jab dusra sheet me us produt ka pehla 3 akshar type kre to wo naam mujhe show krne lage automatic kaise karu pls bataye
well done
Bhai tumne pehle jo table copy Kiya..woh ctrl A aur ctrl c and ctrl v se ek he baar mey ho jata ...aapne ek ek copy past kyu kiya....
Good trick bro
Good joodar
Ek shortcut se do location par file save kase kare (ex shortcut desktop pe he or ek copy pendrive me or ek d drave me )
Nice sir
Can be available multipale bank account and cash account in excel sheet auto upadation ?
Ha
Pl sand video or file
Sir i have a one question related to this topic .
Maan lijiye humare pass ik purana data hai jo bite hue kal ka hai(sheet 1 me hai) or(ik sheet hai jisme maine graphical reparsentation banaya hua hai) aaj mujhe usi trah ka data ko dusre sheet (sheet 2)me entry krna hai. Ab mera question ye hai ki jab me sheet 2 me data entry karun to automatically jis sheet me maine graphical representation dikhya hai wo khid update ho jaye iss trrah k casess me kya krege
Uska bhi video banaya hu description me dal dunga
A
Sir y bataye jese hum kisi jagah job karte h to bar bar customer aate h or hame entry karna hota to same page par kese jayegein jaha hum bar bar entry karegein plz bataye
nice
Good for health
Sir mein excel mein carpet pcs size,colour,po,wise entry karna chahata hu
Excel me Students ka General Register ek sheet me banate or dusre sheet me living certificate banate he or us ke pass ke cell me number likhte hi student ki sari ditails us dusre sheet ke excel me automatic fil ho jati he please ye kese karte he us par video banaye 🙏
Good bhai
👍Gjjjjjjb Yrr Brother👍
Sir aap ka to ho gya h but mera nhi ho rha h ...plss tell me sir kyu error likha aa raha hai...sir isko krne k liye kya new version hona chahiye..aisa h kya ..plss btayie sir
Bhai Excel me kaie vehicle number ko link kare ge sheet 1 se sheet 2 Bhai plz ko uska formula
Good job but try to post most useful sir ji. I got one query, whatever is shown now we can upload or fill data in direct sheets too know instead doing all these
He is trying to make us understand about Macro Recording.
transport compani ke leya .kohi yasa format he sir.we have 48vehicle ,hamko vehicle ka incom,expnses,salary for driver,allowance .all record rakhna padta he
How the top two rows are not visible in the Excel sheet, how will it be solved that we can see both the rows above
You can use the freeze rows 😊😊
Nice Tricks
Excellent
Thanks
Po wise order check ho usme aur poorvi table lag jaye
nice
#viralneeraj
Sir g laste save datakr e k bad today formula kam ni kia .. it's showing nhmber .. instead od dates..
Nice
One time sheet one me 100 name paste kiye aur save kiye yo sheet 2 me aa jaynge kya sir pls
Ha
Sir date formula laga diya nich Wal same formula dalna hai
Excel me sheet-1 Report ke liye bnaya hai aur isse Vlookup Se Automatic ker diya hai aur sheet-2 me iska Data Hai
Ab me jisko ki report print ker du to uski sheet-2 me details ke aage "report done" automatically likha hua aa jaaye jisse pta chal jaaye ki kis kis ki report de di hai ye automatically "Report Done" likha hua aaye iske liye bhi ek video bnao ya msg me hi reply karo
sir apki macro mein date mein payment ki value aa rhi hai
good video
Yes, there is amount showing in date column. Why please explain
Waha pe date ka formula nahi lagana tha
HI, It is because he didn't change change the format of that particular cell or ROW. How you can do this... its simple, follow the steps:
1) Select that particular CELL or ROW, you want to change format into time
2) Right click and select "FORMAT CELLS"
3) In "NUMBER" tab select "TIME"
4) Chose the type or format of time you want to show
Done..
THATS IT
dATE column payment COLUM KO COPY KYO KARR RAHA BHAI
Micro commands ke liye sir ji
Date format kaisa aa raha raha hai, sheet2 me check kijiye
नमस्कार सर जी इस फार्मूले को मोबाइल एक्शन में कैसे यूज करेंगे उसके बारे में कृपया विस्तार से जानकारी देने की कृपा करें
Bhai thoda apna content clear rkho ......Sahi information rkho ... Khi jga pr samaj nhi 👍 keep it up
Macro ki huyi file ko mobile se kaise use kare
Good
Ye work to karta hai but save kaise kare or dubara isme data kaise add kare plz reply
Sir, aap ne apna video dekha hai ? Save data karne ke bad kya save ho Raha hai. 😅
Dada date ki gajha payment aarha he bad me check kro ek baar
Sir mera stock ka kaam kar dijiye
There is no entry of date instead amount is entered in date cell please check the formula
Yes you are right
Khote date is saved as number. Gid save from your video
How to total cell one by one control ENTER key. And save button ENTER key to control.no any click required this project
Video post krne se pehle dekh to lete sirji... 2nd sheet mein date k coloum to dekho... Date ki jagah price aa rhi hai...
HI,
Yes... It is because he didn't change change the format of that particular cell or ROW. How you can do this... its simple, follow the steps:
1) Select that particular CELL or ROW, you want to change format into time
2) Right click and select "FORMAT CELLS"
3) In "NUMBER" tab select "TIME"
4) Chose the type or format of time you want to show
Done..
THATS IT
Payment and date cell me dono same hai Bhai, pls check again
Mohd Juber Memon?
Raftaar Stri ke Ka Aur Bhi Koi video Banaya ho to share kijiye
Check description
Go on
date kaha copy ho raha he ji
Date kaam nhi kar rha hai
dear sir ji, date ke column me date kyu nahi aa rahi hai
Date ke column me kuchh aur hi save ho raha hai. Aap dekh lo.
You can try with this one...
ruclips.net/video/rCCIBKhCpNg/видео.html
Sabbas vai. Great . Ap mera kafi sara muskil ka solution kar diya
Thnx.
Date proper copy nhi ho rhi dusri sheet mein..why
Date column me payment amount entry Ho rhi hai. Isko theek kijiye
Date field is not working properly in this video. Please check the video once.
bhai video achhi h par date ki jagah pe payment Q le raha hai