Sir, please see if we have a solution for, to copy one column in sheet1 to sheet2 in a excel file, condition is sheet 1 data is being refreshed after every 15 minutes in the same column and overwriting the previous data, and we need to capture that sheet 1 column in sheet two keeping the old data as well.
Select Cell / Cells where you want a zero before the number. Go to format cells > Number > customize > below Type there is a box 0.00 > delete it > if there are 3 number then enter 000 > go to excel and tnow if you type 1 in the selected cell / cells you will get 001. Thanks to My Live support where I have learnt many new things.
એક્ષલ માં એવું થઈ શકે કે માસ્ટર ફાઈલમાંથી VBA koding દ્વારા અલગ ફોલ્ડર માં સેવ થઈ શકે દશ કંપની ના employees Hoy to darek કંપની વાઈઝ એમનાં કર્મચારી નો ડેટા કંપની નું ફોલ્ડર બની એમાં save thai jay
As we freeze the cell by pressing F4 key in excel formula In the same way, in VBA code How to freeze cell Range When we insert a cell in a table, the macro code does not run because the cell range changes when we insert cell how do we correct it?
दोस्तों वीडियो को लाइक और चैनल को सब्सक्राइब जरूर करें 🙏🤗🥰
Thanku so much for your nice explanation
your detail explaination is deserved to like your channel
Finally I understand the criteria and range meaning in excel.
बहुत ही सुन्दर से समझाए हैं। बहुत धन्यावाद
Thank you so much bro omg i literally searching this badly ...❤
बहुत प्यारा समझाते हो भाई थैंक्स
हर किसी टीचर में ऐसा समझाने की कला नही होती है,आप जैसे लोग बहुत कम होते है
excellent way of teaching
hi bhi viedo acha laga , like kar diya hai
It's very useful thankyou so much
Very informative video...I guess this is the only video available on internet on this concept...and you explained brilliantly bro....
Thanks 🥰😄
Nice explanation bro...
Thank you sir, Video bahut hi informative hai 😊😊😊👏👏👏
Lot of Thanks..!
Thanks a lot
Zaberdast
Excellent Wow Good
bhai jo aapnay range ki selection hai woh kaisay ki hai. yeh btadain please.
Thanks alot bhai🙏🙏🙏
Thanks a lot sir 🙏👍👍
It's very helpful video Thanks bro.
thanks bro
Solved my data
Nice and thank you
Sir, please see if we have a solution for, to copy one column in sheet1 to sheet2 in a excel file, condition is sheet 1 data is being refreshed after every 15 minutes in the same column and overwriting the previous data, and we need to capture that sheet 1 column in sheet two keeping the old data as well.
Very good explanation
Bahut good h
Wow what an explanation...😃😃👌
शानदार जानकारी जो काम कि है
Thanks sir❤️
Thank you so much sir
Good Explain
Good example
Nice video sir
wow! super explanation...👍
Stock ke bare me khuch batiye sir inwoard outward net stock
thnks
very use full👏👏
Very useful. Thanks for the video.
Very good
How to lock in laptop ..cause when I try to lock the formula in my laptop press f4 that time showing different thing lock r not happening..Pl help
Same hare 🙁
Thank u sir
Thanks
Sir hm har formula ko freeze kr skte hai kya
Happy new year sir ji
Wow wonderful explained
bahi aap ki awaj bilkul new repoter jaisi hai app ko news repoter hona chaiye
Good teacher
HAVE YOU ANY LINK FOR MS OFFICE 2019 OR ONWARDS
Sir what are the other ways to freeze the range? I am unable to do it with f4.
i am too facing problem
Thanku very very much
Nice vdo
Hello sir your video nice
thanks
Very good presentation
Thanks
Happy New year
Chandan Sir,
रोज़मर्रा के office-work में काम आने वाला video है | ; )
Good
Ms-excel में मेडिकल स्टोर पर कैसे कार्य किया जाता है दवा का बिल पर्चा कैसे बनाते हैं उसके बारे में वीडियो बना दीजिए सर प्लीज
Namaste chandan
Thank you sir!
Nice vedeo
Nice bro
My F4 function is not working in formula so what is the solution
Sare farmula me ye f4 lgane pdege or kewal sumif me
Sir F4 se range freeze nahi ho rhi kya reason ho skta h or kaise resolve kre..
Same problem
@@sunilpatel-sq7px press F4 with Fn key
@@pankajverma-bd8bf thank you so much finally ab freez hua hai thank you 🙂🙏
Wow!! Your explanation is so simple and easy to understand. Happy new year 2020
Happy New Year to you and your family
Sir select krne ke baad aapke table ke cell highlight kaise hote hain
Maan gaye sir u r awesome.
Sir freezing kaha 2 baar kare kaha 3 baar kre kyu kare plz ispe video banaye
Nyc sir
Sir ye problem Excel 2013 me nahi ho raha hai
Sir y batao humne criteteria kyu nhi freeze kiya plzz batao
Mere laptop me F2 and F4 kaam nhi kr rha hai..kuch setting kr na hoga kya?
Fn button daba ke rakho uske baad F2 or F4 button press karna
@@MyLiveSupport bro F4 kaam nhi kr raha
Mere me bhi F4 kaam nhi krn raha aapko koi solution Mila kya
@@littleeyes077 nhi mila
f4 key kam nai kar raha hai
🥰🥰
Excel se massage kaise bhejte hai video class chahiye
Laptop me f4 kaam ni ker reha hai
For laptop press fn+f4 button
Ser excel me 0 age kaise lagay batao please
Select Cell / Cells where you want a zero before the number. Go to format cells > Number > customize > below Type there is a box 0.00 > delete it > if there are 3 number then enter 000 > go to excel and tnow if you type 1 in the selected cell / cells you will get 001. Thanks to My Live support where I have learnt many new things.
bhai f4 press krne se brightness ka show horra hai or freeze ni hora
Fn+F4 button dabao
@@MyLiveSupport ok
When I press F2, simply reduce brightness instead of showing formula
Fn+F2 for laptop keyboard
@@MyLiveSupport I was searching for this onlyyyyyy.... Thanks man
I ALSO WANT THIS SOLUTION
એક્ષલ માં એવું થઈ શકે કે માસ્ટર ફાઈલમાંથી VBA koding દ્વારા અલગ ફોલ્ડર માં સેવ થઈ શકે દશ કંપની ના employees Hoy to darek કંપની વાઈઝ એમનાં કર્મચારી નો ડેટા કંપની નું ફોલ્ડર બની એમાં save thai jay
Laptop me kaise lagaye
fn+f4
To bhaiya ( DELHI )
Lekin laptop me f4 button kaam nhi kar rhi hai
Fn + F4 button ek sath press karo
Thanks
@@MyLiveSupport thank you so much 👍
सर क्या आप अपना नंबर दे सकते हैं मुझे आपसे बात करके कुछ सवाल पूछना है
As we freeze the cell by pressing F4 key in excel formula In the same way, in VBA code How to freeze cell Range
When we insert a cell in a table, the macro code does not run because the cell range changes when we insert cell how do we correct it?
Very nice 👍
Thank you. Lot sir 🙏👍👍 superb.... God bless you
Most welcome 😃😃
Thanks a lot sir 🙏👍👍
Thank you sir for your great efforts
Thnk u sir
Good
Thank you Sir🙏
Thanks a lot sir 🙏👍👍