Видео

Nice 👍

Good work sir 💯

Good work 💯

👍🙏

Nice sir 👍

Hello maybe you can help me, I have made a Vba code (see below), what do I want to do now, I want to work with yes/no if I say "no" nothing happens goes back to worksheet "Menu" cell "E2"; if "yes" then the selection is cleared, I do want to be asked if I am sure. Can you help me? Here is the code: Sub New() ' ' New Macro ' Application.ScreenUpdating = False If Range("E2") = 2 Then Sheets(Array("S1", "S2")).Select Sheets(Array("S1", "S2")).Select Sheets("S1").Activate Range("C3:E21").Select Range("H3:J21").Select Range("M3:O21").Select Range("R3:T21").Select Range("W3:Y21").Select Range("AB3:AD21").Select Range("AG3:AI21").Select Range("AL3:AN21").Select Range("AQ3:AS21").Select Range("AV3:AX21").Select Range("BA3:BC21").Select Range("BF3:BH21").Select Range("BK3:BM21").Select Range("BP3:BR21").Select Range("BU3:BW21").Select Range("BZ3:CB21").Select Range("CE3:CG21").Select Range("CJ3:CL21").Select Range("CO3:CQ21").Select Range("CT3:CV21").Select Selection.ClearContents Sheets("Menu").Select Range("E2").Select End If Application.ScreenUpdating = True End Sub

workfull video sir👍

Nice sir

Hello Naveen, Great video. It helped me a lot even though my Hindi is poor. :) I have an additional question. I have converted the list into a table called "tblRawSource". In your formula "ActiveSheet.Cells(i, 2).Value = Application.WorksheetFunction.XLookup(ActiveSheet.Cells(i, 1), MyLookupArray, MyReturnArray1)", I now want to refer to "tblRawSource[Sale PersonName]", and so on. I can't manage to get that done. Can you help me? Thank you very much! Willem from The Netherlands.

Stop the background music

Bro i need the vlookup in vba, as i have need same source data

What is that xlup means ?

Thanks for the vedio , What if I want to change the file name after it is being inserted in sheet? How Can I rename the file?

Isme month option nhi aa rha hai pc me TB kya karna hai please reply

Good

Hello sir Your teaching way are great. Please tell me code of select data without heading.

What if hotel name are more than 1000. We couldn't create that many variables like myVar1, myVar2.....and so on.

Sir bohot bohot shukriya❤

How do you insert a folder into an excel cell?

Hi can you help about index match. Its not taking the cell value but injecting a value on a table base on a criteria.

Good Evening Sir Please Guide me for prepare report of issue vs reversal against order.

Sir mere pas multiple csv files h, files name as 30122023,12022023,11122020….means “ddmmyyyy” format is me date monthly and year k base per file delete karna h….sir please Iska vba banayen❤❤

so lengthy process😒

Too good bro... excellent video.. keep it up.👍👍

I want to create a VBS function that will do index match with no duplication. I have an array B8:C38 that I want to match with G7:P7 header row. The function will have subroutines named after the days of the week starting with Saturday. I will activate the subroutine with a macro button. I have an If index match small formula that works. I believe the VBS function would work better and be more secure from user mistakes. How can this be done?

Very useful video ..Thanks sir

this is an excellent video. It is almost exactly what i need. workbook 1 I have a user form that is writing a serial number to col A, then has a Combo box with drop down selection of options which are a list of the headers from workbook 2 (columns b thru J). and then col 3 is a date of completion entry. workbook 2 i would like to match workbook1 serial number to the same serial number in col A workbook 2 then match the result of col B workbook 1 to the headers of workbook 2 Col B - J and write the date of completion in the row of the serial number they entered.

Nice code..!!

Super.. Love from Japan🌺🌺🌺

Thank you verymuch for the offset technique.

Very helpful 🙏👍

Thank you, this video helped me a lot ❣️

Nice coding. Creatorji, aap hdfc bank mein kaam krte the kya? 😂

Great video and steps easy to follow. Question: What is if I only wanted to be alerted when for example one cell “B5” is changed. How would I do that?

It was very useful. However output file location pe save karne ka code nhi insert kiya. I thought ki output location me run hoke save hojaaygi. Please suggest if I am missing something

Awesome knowledge

super bhai !!!

Very difficult to understand, I wasn’t sure if it was your accent or if you were speaking both English and your native language

You saved my life man, thank youu 🙏🙏

Hello sir nice video but apne ek sheet pe match function lagaya he par ek ki jaga 2 sheet he or same value dono me match karna he aur 3rd sheet pe difference nikalna ho to minus karke....plz batayiye kaise karenge

thanks bro and great work

Nice video Thank you very much. Please do not use background music

This code is set by default to move to 3rd row after filter is enabled It's a false caption the code doesn't mean one cell down in filter mode cell(3,0) to move to 3rd row

What if your "VBA Output" Sheet was already populated and your "Data" Sheet only had 1 ID. And you wanted to run a VBA that would update only that ID on the "VBA Output" sheet without messing up the already populated fields in "VBA output". Say you wanted to change 10012's name on the "VBA Output" sheet by entering it on the "Data" sheet. How would that VBA look?

Thanks so much

Unable to open attached object in excell. Cannot start the source application for this oject.

Thank you Naveen for valuable information prsents

criteria 1 criteria 2 criteria 3 Item Product Work Description Floor Result Cement Gray cement False slab work 4th Floor Dear brother, I want to know how to solve the three criteria index match function ? Can i shear a excel file.

Sir I have a query, how can I contact with you?

Thankyou sir. good information