Видео

Thanks!!

Thanks, answered exactly what I was searching.

Are Drunk ?

Your macro helped Me 👍

Thank you very much

Hi, what if you wanted to do a VLOOKUP across specific sheets in the workbook, but it is seven sheets in total? Can you assist?

It is the best explanation on RUclips. Thank you for you work! But in case if you need to populate function further on additional columns what should I do?

Hi Karen. Very interesting video. I would like to get a copy of the file "Goalscorers.xlsm". I cannot find it nor your Udemy course. Thanks! At least where can I find the data in worksheets 'Goalscorers' and 'PlacesOfBirth'. It would help me to better follow your instructions.

The tutorial was put together very well and so was your explanation. I learnt, and that is the point. Thank you very much.............. subscribed

You are the best! Less than 10 mins the VBA script? My god unimaginable skills! Thanks a ton indeed. You made my life much easier! :)

I can use it in a form referencing a textbox or combobox, does it work? Thanks Karen!

Congratulations Karen Tateosyan. Man, it was sensational your class, thank you so much! I've been following you for a long long time, gratitude. Sorry my English isn't good!!! You said: "I initially uploaded it to Udemy in 2018/2019 and decided to upload the course to RUclips so everyone can watch the content for free". Much generosity Karen, Thanks!!!

Hi, I followed your code, it is running but not sure why it's not copying from another sheet to the main sheet. Do I need to activate both sheets or do anything? Sub check_MACAddress() Dim wsMain As Worksheet, wsPrevious As Worksheet Dim mainLastRow As Long, previousLastRow As Long, x As Long Dim dataRng As Range Set wsMain = ThisWorkbook.Worksheets("Data") Set wsPrevious = ThisWorkbook.Worksheets(4) mainLastRow = wsMain.Range("A" & Rows.Count).End(xlUp).Row previousLastRow = wsPrevious.Range("A" & Rows.Count).End(xlUp).Row 'wsMain.Columns("D:D").Insert 'wsMain.Cells(1, 4).Value = "Previous IP" 'wsMain.Cells(1, 4).Interior.Color = vbYellow Set dataRng = wsPrevious.Range("A2:C" & previousLastRow) For x = 2 To mainLastRow On Error Resume Next wsMain.Range("D" & x).Value = Application.WorksheetFunction.VLookup(wsMain.Range("C" & x).Value, dataRng, 2, False) Next x End Sub

Hello, the video is interesting, I don't know that this will work for me, I have a worksheet "MENU", on "B2" I have a dropdown list with a reference to all 200 other worksheets, in "B5" I want to start searching the formulas that I now have in Excel are not in VBA =vlookup($A$5,indirect($B$2),2,false), how can I do this in VBA, if I already know this I think I can move on. Can you help me please.

Thanks for presentation

How dare you create a simple video that’s straight to the point? I thought you were supposed to make it last 50 mins long but nope you aimed and achieved perfection. Thank you sir!! Wish I could give you more likes and subscriptions.

Extremely helpful, thanks for sharing.

Hi, thank for sharing your code. I have a problem, the code is not show debugging, but when i run the code, it shows nothing. Can you please suggest ?

You should have chosen simple and shorter names for your sheets and tabs

Karen - This was absolutely brilliant man, thanks so much from the US. I am subscribing!

Dear sir, I want to know how to solution the three criteria index match function in Visual basic excel file ? Can i shear a excel file this related problem.

Nice video, everything is well explained! I realize this is not the place for support but i do have a question that maybe somebody can give me some tips for? I used the SAME code as in the video and only changed the names to match the names of my worksheets and the columns but i get "runtime error 9 subscript out of range" on the lines where we set the worksheets "Set goalsWS =.... Set dataWs =....." Do you know why i might be getting this error and where i should look to find a fix?

thanks for posting this! Could i get the code somewhere? Thank you so much

amazing video! thank you :)

WTF

Thanks karen sir... You teach very ❤️‍🩹❤️‍🩹❤️‍🩹

Finally. A piece of code and easy explaination that counts the correct number of rows. Thank you.

Can i get practice file

i tried including the line "on error resume next" but it ain't working. now i'm stuck

can we do this for two seperate files ?

Hey sir. I've got a another question. I'm sorry if i bother you but just trying to learn :) So we've just got a loop with a vlookup function which tries to exact match(false). But if there is no match in our table for vlookup array our code gives an error. So i think we should set up an if statement for our vlookup loop. That if statement should provide us that it will give an promt if there is no match in vlookup value... I tried to add some if codes but they did not work. I need your wise knowledge here :) If you can show me directly codes like this it would be awesome. 👇 Worksheets("MainPage").Select i = 2 Do While i <= Lastrow_MainpageWs MainPageWs.Range("D" & i).Formula = Application.WorksheetFunction.VLookup( _ MainPageWs.Range("C" & i).Value, DataBaseRng2, 2, False) i = i + 1 Loop how can we add if statement to this. IF we have some unmatchable datas for table.

Sir i've just got a question. It works when i've done these all procedures and it finds the correct value. But when i closed the file then open the file and when i enter a new value it does not search automatically in table array. So i think we have some missings to make it more automaticaly for ''vlookup loop''. Do you have any idea how to deal with that?

Can we do this in Power query?

This is the simplest and the greatest example for dynamic vlookup uses on VBA. Appreciated sir.

Thank you for your video! It is very helpful. Hope you will continue making more videos about VBA😊

Do not sum decimals

very helpful, 🙏 thanks

Some1 told me to use right function

How do I get the results to print in an another cell in the a worksheet rather the immediate window

really helpful Karen

it is great, sir. thanks.

Very great job ,Thank you

Please tell me.....if the datarng as blanks ....this macro is updating the blanks also......... but it should not update blanks.....only datarng has value it should vlookup..... please suggest how to ignore blanks in datarng

Thanks for sharing informative video... really helped lot

Thank you very much for your help, I have a doubt, in the part where you place offset(0,1) to which part of the sheet you refer please. What happens is that I have tried to do it but it is that part I miss

THANKS SI MUCH KEEP MAKING VIDEOS VERY HELPFUL AND MITIVATING

Excellent technique. That was really helpful. I used this in my business csv file as for some reason most of the recent string formula's did not work .thanks for the help.

So what :)

I love your video

Thank you very much for this video , exactly what i needed after spending few hours on task :)