aaj se net 2 months phele me excell me bilkul Zero tha bs copy or paste k alava kuch ni janta tha. lekin youtube pr mene bahut channels pr videos dkhi....lekin kisi ko follow nahi kr paya kyuki sb ke channel or bahut jyda videos uploded thi or unki videos bahut lengthy bhi thi. starting me to sir apki video me bad mind set ke 7 watch krta tha. sochta tha ki subscription bhi km logo ne kr rakha h, videos bhi km uploded h, uplode me bhi time gep jyda h. but dheere dheere dkhta raha. net 2 months after aaj meri position esi h ki me formula or functions ko nested kr ke apni requirements ke according function creat kr leta hu. or muje ab apke videos ka adiction jesa bhi ho gya. kisi bhi video ko sirf ek bar dkhna sufficient ni h. bar bar repeat krne se hr bar kuch new thought generate hota h ek din aapka channel bahut aage niklega sir. Thanks & Regards Ashish Dhaked jaipur
Thanks guru. Guru g need any excel trick or formula to make ledger like we give date from . To and data appear of customer kindly make video on it or if u have already any video related to my request pls share
Trick no 4 : workbook ek bar close kr ke reopen krne pr scroll area reset ho jata hai . . I think we need to write code for active sheet . Whenever we open sheet , scroll area apneaap set ho jayega ,code: Sheets("Sheet1").ScrollArea = "A1:G10"
Hi Sir, Please not that the last trick that you gave of converting number to words is not working for larger numbers and is limited to only 999,999. thankyou for making the video, it was overall very helpful.