@Exceltrainingvideos how could i make the combo boxes dependent?

why does it show me error 1004?

Can I write something on vbs script that will do it daily ? without the need to click manually?

Code link is not working :(

sir, can you share the excell

Good informative; thanksgiving..

i have a working VBA code, while automation, Internet explorer is poping up a window to open whatsapp app wheather to allow or cancel ? how to bypass that window.This pop up is not having a checkbox to always allow. what to do sir?

good, but cant be used in case there is a password.

Always the main man never fails : ) You are like Mike Guring Excel is Fun he never fails either You both the best in your field

Can we do this in Gmail Sir?

Dinesh sir.. i watch your videos on vba and it really helps. I want to know whether this macr run automatically on daily basis

The link not work!

Hi Sir! I hope you can help me with a solution, this is nearly what I am looking for. However, I only want to transfer a specific cell value from sheet to another based on 2 conditions met.

Thanks. I am learning this real stuff here. Great job.

How to do it ms access in form level

Can I please reach you directly sir. My invoice and inventory is different from yours but even after following the process to update the inventory, it still didn't work, please I would love your response soon. Thank you

How can I protect multiple sheets? It works on one but I have 9 different sheets. Please help 🙏

Sirji you post really informative videos. 1 que. Sir Hi, I have my Excel file which is updated through an odbc connection. But how can I sync that Excel data into Google Sheets that could be updated automatically in periodic intervals but without using 3rd party connectors. Any Solution? Thanks

incredible , how it possible ? awesome , The coding king ?

Thank you for this.This helps me create a 50 random questions from 1800 questions to generate for my reviewer.

Very nice

thanks i am looking for this since 1 month but not getting it from anywhere. thank you a lot and God Bless You & Your Family

I was trying some time Print automatically set company header-footers set…… using vba with 4 side perfect margins. Header footer image based…… Please share help how to working with perfect margin

Sir concept so clean…… I was trying some time Print automatically set company header-footers set…… using vba with 4 side perfect margins.

How to make purchase order system with recode data item wise , *1 To 500 of items data (No limitations) * how to tracking Purchase order party wise or filters and reporting 😢😢😢

Amazing concept of the invoice….. wow sir thank you ❤

To support my point, let us take Adam Hart, you displayed 10 duplicates (row 27 - 36) I want you to take note of the values on column c. i.e. 841.568, 12.84, 196.45 etc, these are not duplicates but multiple records. When you analysed unique records, only the first record for Adam Hart was displayed. So if I am a credit controller, how will I collect company'e money from Adam Hant since you said they are duplicates? I hope you understand my argument, and I hope you can correct your video.

Hi, in the first analysis, If you look at the first row, you will see duplicate names but not duplicate records, which means they are multiple records of the same person but not duplicates. If you look at the unique record analysis, you filtered out column A but you lost values in column c. If you happen to be a credit controller, your account will be in a mess this way. The best way to check if what you have done is correct is to check in SQL i.e. Select count(*), [Customer Name], [sales Amount] from Tablename group by [Customer Name], [Product Name], [sales Amount] Having Count(*) > 1

please send full vba code for auto login

i have a link which contain more that 10 pages and want to open chrome and take all pages full screenshot and save it to excel. is it possible? if possible then please guide me.

Great tip! Thank you! How can I export this created picture on cell to a PNG file?

Sir I need your help

Fantastic, Thank You, Very Clear.

Thanks so much. If just I need the first table, how do it?

How to update invoice data in master sheet help me please

How to update invoice data in master sheet help me please

God this is exactly what I was looking for. Not only was it a great video but it was clear, concise and easy to understand. Thank you

Dear Sir , Need A video tutorial For Extract Specific range data to active sheet As a : collect range A29:D29 data Copy And Paste In Active Sheet range A29:D29 to .xndown Please See My Requirement Kindly .

Dear Sir I have need : How Create a Extract Specific range data from multiple excel file in to active sheet in spicific range . As a collect Only (A29:D29) from All Excel file . And Thats Distaination willbe Active Sheet Range (A29:D29) to xldown . Please Make a video tutorial , It willbe help for Us . Please See kindly .

Sir my name is Rajan iam following your excel clasess in youtube channel but sir, i can't see a video for update msaccess database from excel vba, so sir i kindly request you to create a video for that

Thanks for a very simple way to open files from VBA. Since my files are in different areas of my computer, I wrote a ,xlsm file that opens my excel files from a user form. I wasn't able to open a word file from that program. Your video showed me how to do it.

Thank You for the Informative Video Dinesh. I implemented your code and on the First day it works fine. However for some reason the data being imported is not be filled Horizontally and not vertically as shown in your video on the new Excel Worksheet. Is this a code issue or a settings issue with excel. Data being imported from multiple CSV files is being imported Horizontally on the new work sheet as opposed to vertically in the columns.

How to fill multiple row of data

Very nice ❤

I know this is an old video and not sure If you still read these. What if you want to pull the word table data like you are doing, but on an open word doc? Example. You are emailed a word file daily and no need to save it. You go to your master excel file and run your macro to pull in the data. That way, you can use that excel file for a specific job

I want to add signature

I liked the video, it was very informative. How can I make it check more than one textbox = txtID, maybe for example: first name and last name are in one cell?

Hi there, Is it worth buying a PS4 in 2004? Should I buy PS 5 Slim or should I wait Sony PlayStation 5 Pro?

Awesome and super usefull as always, thank you! Also, is there a way to for example resize a dialogbox like customsort? For context: I am trying to create a macro where the user can save/store custom sorts with cond format and even icons, I already did that and all, but I am struggling with taking a snapshot of just the sort dialog box, I was able to to do it with a mix of manual and automated method, like first doing the keycode_event for printscreen and then showing the sort dialog, (the order might be confusing, but it was necesary sicne the code is topped by the dialog box until it closes to continue) So the part that I am missing to figure out for now is How can the sort dialog box can be resize using VBA since it can not be resize when pop after the printscreen have been set ready to capture it because the next click by the user is going to be the capture of the window? Application.Dialogs(xlDialogSort).Application.Height does not seem to work Application.CommandBars.ExecuteMso "SortDialog" Application.CommandBars.ExecuteMso "SortCustomExcel"

Thank you, you are the best