Good explanation sir....very nice video or guys ek chiz yaha p imporynt ye hai ki...ap in formulas ko apni purani windows me naa use kre kuki us p ye formulas kaam ni krenge.....windows10 p use kre or vo b excel k latest update k saath😉✌❤🙌
Excellent information. I'm a teacher & I want to make an attendance register of students in Excel with their statistical analysis. Is it possible if yes than please upload a video about it. I'll be very thankful for this act of kindness.
You are just great sir, I've finished "Automatic Admit Card Creating" completely after watching your video, but I am facing a problem when I am using fitPIC option, it shows an error "Select Case PicWtoHRatio / CellWtoHRatio Case Is > 1" why this error is showing.....Thank Sir...
Hello M kumar I hv learnt alot from your tutorials. Your method and knowledge is really superb. My is question is that Suppose i have some bulk data in excell sheets consists of employees details. And i want to insert their pictures in their respective cells/column. can i insert all of their pictures in respective cells by using any formula or funcion in excel. Bcoz it is very time consuming to search employee in sheet and then search his pic and the place it correctly.
Sir, Namaste. Can you please teach if the ID card can have barcoded and how to read the I'd cards by barcode scanner and register in the attendance sheet of xl. Please share me the link if you have already made a video on this subject. Thanks
सर Id card कि फोटो तो Excel में फार्मूला Index और Match फार्मूला से शो और नाम के साथ चेंज भी हो रही है लेकिन इसे प्रिंट कर रहे है तब यह फोटो शो नहीं हो रही है
Sir, after using name manager and defining a name to selected picture, when I click on formula bar, it was not activated, still the pic was selected, I can't type anything on formula bar, please guide, where I have done mistake.
Please, Not clear from into the Visual Baseis. I was wrote sheet1 click and did like you doing Module written the software but did not worked show are yellow yellow color and i did look stare at you teaching written but undo still shown yellow. Please if you why teaching☺
@whith Wom s this the short cut key but I was referring that I don't have developer tab however I got it now ..I sawed a youtube video on that...anyways your video was helpful to me
yadi aap office 2007 use karte hian to please click the office button on the top left corner in excel window and choose "excel option" on the bottom of the popup window and click the "popular" option, in this window third option is "show doveloper tab" check the option office 2013-19, click the file menu-click the option than click the "customize ribbon" here right side box you she "Developer"
Public Sub FitPic() On Error GoTo NOT_SHAPE Dim PicWtoHRatio As Single Dim CellWtoHRatio As Single With Selection PicWtoHRatio = .Width / .Height End With With Selection.TopLeftCell CellWtoHRatio = .Width / .RowHeight End With Select Case PicWtoHRatio / CellWtoHRatio Case Is > 1 With Selection.Width = .TopLeftCell.Width.Height = .Width /PicWtoHRatio End With Case Else With Selection .Height = .TopLeftCell.RowHeight .Width = .Height * PicWtoHRatio End With End Select With Selection .Top = .TopLeftCell.Top .Left = .TopLeftCell.Left End With Exit Sub NOT_SHAPE: MsgBox "Select a picture before running this macro." End Sub
Very helpful video thank you so much sir😊
Manoj Kumar Bhai Great Video.
HARIS KHAN KARACHI Pakistan ❤️
Nice video hai sir 🙏🙏
Nice work 👏
Sir jitne bhi i card banane k video dekhe...usme apka video best hai...bahut kaam aaya mere...bahut bahut dhanyavad sir😊
Very nice sir
Thank you Manoj ji😀😀😀
Good explanation sir....very nice video or guys ek chiz yaha p imporynt ye hai ki...ap in formulas ko apni purani windows me naa use kre kuki us p ye formulas kaam ni krenge.....windows10 p use kre or vo b excel k latest update k saath😉✌❤🙌
bro excel or windows dono alag cheez hain ye formula office 2007 to 2019 sabhi me kaam karega
A very nice explanation. you saved me a lot of money thank you so much!
Sir I'd ka sample kaese or kha se bnaya gya hai BTA dege kiya
I'd card ka performa bnane BTA dijie
Thanks Sir
Excellent sir
Very Useful
Superb, Sirji great
Super sir ji
Good sir
Superb Explaination
great method of teaching
Superb trick sir.....I like it
Thank you very much
Bhut acha
Really its super way yo learn biggner
Very good explanation sir . thanks for it
👍👍👍👍👍
well explained.
Nice
Excellent information. I'm a teacher & I want to make an attendance register of students in Excel with their statistical analysis. Is it possible if yes than please upload a video about it. I'll be very thankful for this act of kindness.
maja a gaya
Excel ka konsa verison h ye... Office 10 ya 13 ya 16
13
You are just great sir, I've finished "Automatic Admit Card Creating" completely after watching your video, but I am facing a problem when I am using fitPIC option, it shows an error "Select Case PicWtoHRatio / CellWtoHRatio Case Is > 1" why this error is showing.....Thank Sir...
Video bohat hi accha tha sir, thank you
good
Thank You Sir
Thank you so much sir for this kindness but sir I have one problem. How I can print multiple id card please make for me one video
very nice.
R/Good Evening Excel sheets main page per art boarder lagana Batao Ji🙏
Sir Excel 2007 use kiye hai kya aap
Hello M kumar
I hv learnt alot from your tutorials. Your method and knowledge is really superb.
My is question is that
Suppose i have some bulk data in excell sheets consists of employees details. And i want to insert their pictures in their respective cells/column.
can i insert all of their pictures in respective cells by using any formula or funcion in excel.
Bcoz it is very time consuming to search employee in sheet and then search his pic and the place it correctly.
R/Sir Good Evening . Id card ka print out लेने के बाद Excel sheets se सभी फोटो सैल से बाहर निकल जाते हैं कृपया उचित मार्गदर्शन करें 🙏🙏
Kya ye auto photo insart ke sare option old ms word me bhi mil jayenge
yes
Very good
Super bro
Great
After index match formula, when I select the picture and try to write in formula bar , the formula bar doesn't select.... what to do now
Same problem
Amazing
Kya hum userform ke jariye kisi specific cell me photo upload kar sakte hai?
Dear sir when i am selecting the picture to insert function bar the function =fitpic, the function bar is off
please try correctly
Sir, video very nice. If all card print karna ho kaise karen.
ruclips.net/video/n3mbWP_4TGo/видео.html
ruclips.net/video/ab_qDO--3Ig/видео.html
Sir, Namaste. Can you please teach if the ID card can have barcoded and how to read the I'd cards by barcode scanner and register in the attendance sheet of xl. Please share me the link if you have already made a video on this subject. Thanks
सर Id card कि फोटो तो Excel में फार्मूला Index और Match फार्मूला से शो और नाम के साथ चेंज भी हो रही है लेकिन इसे प्रिंट कर रहे है तब यह फोटो शो नहीं हो रही है
GURU BAHOT ACHHA LAGA APKA YE VIDEO BUT KYA HUM MOBILE NO.SPIN BUTTON SE BADAL SAKTE HAI KYA
Sir, after using name manager and defining a name to selected picture, when I click on formula bar, it was not activated, still the pic was selected, I can't type anything on formula bar, please guide, where I have done mistake.
For this use version above ms office 2007
@@ComputerGyanGuruji sir ji I have done this job in my 2007 version by getting information from another video, thanks
Sir Ye bataye pls
Ek baar i card ka formula bana diya to baad me sirf name photo etc chang karne se vo icard unke name ka baa. Sakta hai plz ans me
👍
It leaves one row empty .. please help sir
sir pic formola ni ata.jab pic py dobara click kar k formola bar main jata hon to oder click hi ni hota
This is the channel I was looking for
Very nice sir, I learn something from it... 🙏
sir aapko kisi bhi student ka personel details hide kar deni chaahiye thi.
Sir Id Name Picture index formula par kaise kare
I'd card ka performa kha se bnana padega Ms word se ya Excel se
Video is fine but complexity
great and nice explanation, thanks
AoA dear respected sir
I card kasy bnaya tha
Sir aap Ms word or Excel 2013 ka menu Wise video banaye hai Kiya.
bro hamne ms word or excel ke menu wise video banaye hain aap hamari video play list denkhe please
Sir photo select karne ke Baad formula bar me type nahi kar pa rahe hai, kya kare?
ye office 2007 se above version me possible h
ممنون
Icard format kaise bnaya h
After selecting picture, I am unable to write in formula bar.
Me too
Picture select krne k baad formula bar me name manager ka naam fitpic nhe open hota , qk picture select hue hea, using ms office 7
ye office 7,10,13,16,19 sabhi me kaam karta hai
i card banaka format video nahi dikhaya
Excel se multiple I'd ka print kaese nikalege
R/ Sir ye jo apne I Card ka jo design banaya hai usper kuch btayie plz
bro aap puchhen kya puchhna chahte hain main kosis karunga
I-card kha se app degine kiye the Excel ya msword
Or wo kaese hoga btiyae plz
File Download Karni Hai
12.38 कसे विर्य को अलग अलग सेल मे कैसे करे 12 एक सेल मे और 38 एक सेल मे
how to search the the employe by name in same table???
Sr userform ke shath me photo instant krta hu or serch me jab me id card details leta hu to logo gayab ho jatahe
Please, Not clear from into the Visual Baseis. I was wrote sheet1 click and did like you doing Module written the software but did not worked show are yellow yellow color and i did look stare at you teaching written but undo still shown yellow. Please if you why teaching☺
आप हमारा सर्विस आई कार्ड pvc पर बना दोगे क्या जी
bro main aapse kuchh samay baad contact karunga
Ok my no 9785094150
there is bug in code. the code you have given is not working
SINGEL ID BANANE KE LIYE KON SA VIDEO HE LINK DIJI YE
bro ye ek baar me ek hi banta hain multy bana hai to uska video bhi dala hua hai
hi sir i am getting compile error
How to create format u dint show that then wat is the video useful?
Nobody creates backsides of ID cards
how to launch developer tab
@whith Wom s this the short cut key but I was referring that I don't have developer tab however I got it now ..I sawed a youtube video on that...anyways your video was helpful to me
@whith Wom oh k
yadi aap office 2007 use karte hian to please click the office button on the top left corner in excel window and choose "excel option" on the bottom of the popup window and click the "popular" option, in this window third option is "show doveloper tab" check the option
office 2013-19, click the file menu-click the option than click the "customize ribbon" here right side box you she "Developer"
PLZ
Sir app I'd card bnana half hi btae hai
Video no clarity plz clarity
Sir please reply me
Sir apka number milega kiya
I card banana Humko Sar Kaise Banega7737315735
Public Sub FitPic()
On Error GoTo NOT_SHAPE
Dim PicWtoHRatio As Single
Dim CellWtoHRatio As Single
With Selection
PicWtoHRatio = .Width / .Height
End With
With Selection.TopLeftCell
CellWtoHRatio = .Width / .RowHeight
End With
Select Case PicWtoHRatio / CellWtoHRatio Case Is > 1
With Selection.Width = .TopLeftCell.Width.Height = .Width /PicWtoHRatio
End With
Case Else
With Selection
.Height = .TopLeftCell.RowHeight
.Width = .Height * PicWtoHRatio
End With
End Select
With Selection
.Top = .TopLeftCell.Top
.Left = .TopLeftCell.Left
End With
Exit Sub
NOT_SHAPE:
MsgBox "Select a picture before running this macro."
End Sub
Really its super way yo learn biggner
Very nice sir
Very good
A very nice explanation. you saved me a lot of money thank you so much!
THANK YOU SIR