How to Automate Data Entry in a web form using excel macros

In this tutorial we would learn:
1. How to automate data entry in a web form
2. How to fetch data from excel file and populate a web form/page

[tinagoparaju]

Each and every day I am learning how powerful excel is. Thank you for this wonderful tutorial! Very relevant to my job, would love to implement it.

[jimmychew]

Most amazing person, to present in such a clear and logical way and will make it easy for learner of all levels to understand. Great job.

[jh]

Awesome! You have a very effective way of teaching programming!

[Survival_Guides_]

I was wondering why the intelisence was not working when watching other tutorials. Now you explained why, so thanks for this valuable information and the whole video is awsone

[manjugv]

Hi, in this video you've mentioned you'll create a separate video for making for loop to enter data from multiple rows, I searched for the same but could not find it, can you pl. share the link.
Also, 1) how do I select from dropdown in the webpage

[HotButteredCorn]

My brain hurts .... thank you so very much for your care in making this! This is truly awesome and a huge help. Well done!!!😃

[jond]

Thanks for taking the time to explain this and especially for your careful and detailed explanation - as others have said your teaching method of explaining the process and the code is excellent. Yes I too would like to see the enhancement using formloop for multi row tables, plus a way to ensure that the macro only writes new rows of data to the form ( i guess you would need to incorporate an IF function in VB that looked if the row had been posted and that could work of a new column in the spreadsheet "Already Posted?" that the posting macro would update with "Yes" as it posted a row before looping to the row, checking if it had been posted and then posting it if required.
is there any reason that this could not be done using Googlesheets instead?

[rajeshshah]

Wow!! I have never come across such simple explanation. Thanks man. You style is just amazing.

[srinivasan]

Hi, its simply awesome. Easily understandable.. Thank you so much.. But i hav a another problem... For one personal website, After click the submit button, im getting another page.. In that i have to click one hyperlink.. So how can i do that for mulitiple followup hyperlinks .. Pls help with this

[godevil]

This is one of the far most beautifully explained video on macros for Data Entry....keep up the good work

[yashmusic]

How to use this method for multiple links at the same time with same work sheet

[praise]

Wow, nice explanation. After ur explanation I am aware that we can automate the webform using Excel also.

Thanks a lot.

[triarevsarl]

Great video, thank you
how to submit the data entry after filling, if there's a submit button

[Universalemperors]

I am very much impressed with your video. It is highly useful to me.

I need to know two things.

1.How to use for loop for multiple data
2.How to use for next page of form after submission

[rizwanibrahim]

Watching your video first time and I must to say you are awesome.. big fan of your way of teaching.
Learn alot and I hope you will continue this wonderful teaching skills ...
Big Respect and Big Love from Pakistan..❤️❤️❤️

[nikhilang]

You are a very good explainer. Got the perfect knowledge. Thanks and would like to see new automations.😊

[anuragdey]

Your video is useful .In this video you help to populate text on homepage text box of Facebook, I have a scenario where the home page is login page and data entry is done on second page after login. So through this process I am unable to solve my purpose.I subscribed your channel and eagerly waiting for video .

[saldaandres]

Great video, you just saved my hours of work. Thanks

[vishwaprakashpatel]

Watched just now and it's awesome explained

[userx]

Super tutorial, Can you make video on How to extract data from website and put all data into textboxs(macro userform) in excel sheet