Thank you so much Guruji 👨‍🏫. Please keep share useful information. Many many thanks God bless you.

@Exceltrainingvideos

2 жыл бұрын

Always welcome

Everything you explain is useful and new. Greetings from Egypt

@Exceltrainingvideos

2 жыл бұрын

Awesome, thank you!

Thanks sir for uploading useful information.

@Exceltrainingvideos

2 жыл бұрын

Always welcome

Thanks for valuable tip.

@Exceltrainingvideos

2 жыл бұрын

You're welcome!

First my morning wishes sir. Inspiration your teaching and programming. I am addicting your teaching. Thank you so much sir.

Thank you sir. It is great trick.

Thanks 👍 it's very helpful to me

@Exceltrainingvideos

2 жыл бұрын

Most welcome 😊

Thanks sir, it is very much useful for me

@Exceltrainingvideos

2 жыл бұрын

Glad to hear that

This is great, thank you ! Will share with my colleagues!

@Exceltrainingvideos

2 жыл бұрын

Thanks for sharing!

Thank you sir. but how to use vlookup using table header to a userform? Please give me a soluation.

Sir it is very useful but a separate video for the same using video please

@Exceltrainingvideos

2 жыл бұрын

Ok sure

Even if we do not include column headers in the "Vlookup" function and use match function for headers, the formula will still work!!

@Exceltrainingvideos

2 жыл бұрын

Try interchanging the columns!

@rehanshah2091

2 жыл бұрын

@@Exceltrainingvideos Still works :)

Sir I am maintaining a spreadsheet for stock and inventory... I am having 6700 items and I was maintaining well by using vlookup and if formulas but my project manager added a new criteria that I have to maintain bin location where the material is located. Issue is that one item is located in many bins and I have to give stock report by unique items. Plzzzz help me...

@Exceltrainingvideos

2 жыл бұрын

Use XLookup: kzread.info/dash/bejne/iICBzpqYZdfegtY.html

Great

@Exceltrainingvideos

2 жыл бұрын

Thanks

Sir, do let me know if u run any macros courses

@Exceltrainingvideos

2 жыл бұрын

yes

Sir, one query in vba pls help on this, I have 3 listboxs in userform atleast i need to select anyone item among 3listboxs then only I can click optionbox if I ll not select any items in listboxs it should populate msgbox. How I need to proceed for this??

@Exceltrainingvideos

2 жыл бұрын

St the option button's visible property to false. Now use an IF condtion like so: If ListBox1.Value = "SomeValue" Then OptionButton1.Visible = True

@lavanyakuppuswamy4938

2 жыл бұрын

@@Exceltrainingvideos sir i tried but its not working as expect. I don't wanna hide option button. I need to get popup msg if none of the item not selected in listbox 1 and listbox 2 I tried like this Optionbutton1. Click If listbox1. Listindex & listbox2. Listindex =false then Msgbox "Before select option button please any items from listbox 1 or listbox 2" End if But this loop not work properly. Please help me.

@lavanyakuppuswamy4938

2 жыл бұрын

@@Exceltrainingvideos could you please help on above query 🙏🙏🙏

@Exceltrainingvideos

2 жыл бұрын

@@lavanyakuppuswamy4938 www.exceltrainingvideos.com/excel-vba-combobox-match-required/

@lavanyakuppuswamy4938

2 жыл бұрын

Thank you so much for your time and updates. Yes I tried as you told but it didn't worked as I expected. I tried like, If listbox1. Listindex=-1 or listbox2. Listindex=-1 Or listbox3. Listindex=-1 then Msgbox "pls select any value" End if

Sir I have one big data file like time range file employee scan time list This file header fist sheet I'd number, scan time, remark Seconds sheet time and remark examples 7:00:00AM to 9:00:0AM = beak time 1:00:00PM to 2:00:00PM = lunch time... Please make one vedieo for fuilly automatic vba format sir

@Exceltrainingvideos

2 жыл бұрын

This Excel tutorial will guide: www.exceltrainingvideos.com/payment-calculations-based-on-timestamps-in-excel/

@krishnajagadeesh6307

2 жыл бұрын

Okay sir

Hello. This is useful, but why not directly use index/match or, if possible, xlookup ? Even that, thank you for sharing your skill.

@Exceltrainingvideos

2 жыл бұрын

Yes, you are right

@hbp7633

2 жыл бұрын

Bro 😎 XLookup is not available in all version, don’t you know this bro bro 😎

@Exceltrainingvideos

2 жыл бұрын

@@hbp7633 Did I use XLookup in this video?

@hbp7633

2 жыл бұрын

@@Exceltrainingvideos. Guruji I have written to someone else not you. See the top comment above. I m telling him that XLookup is not available in all version. You are excellent.

@dd1965

2 жыл бұрын

@@hbp7633 I know Xlookup is not always available, that's why I said "if possible " bro.