Hello Excel Saint's
At work i spend about 1 to 2 hours using a website search box to find the result on whether a memo has been sent out or not. The process involves copying the memo number to the website search bar and copying the result back into the excel sheet. The website does require a username and password to enter. As i get 200 - 400 memos per hour, Is there a way to use the search parameters from the website and paste them back into excel via vba or some other sort. Below is a example.
At work i spend about 1 to 2 hours using a website search box to find the result on whether a memo has been sent out or not. The process involves copying the memo number to the website search bar and copying the result back into the excel sheet. The website does require a username and password to enter. As i get 200 - 400 memos per hour, Is there a way to use the search parameters from the website and paste them back into excel via vba or some other sort. Below is a example.