Hello, I have created an excel workbook (Macro enabled) that has zip codes in column "B" (the zip codes are non hyperlinked and numeric only). I am trying to have the following action automated:
Function 1 - To have excel open an internet browser and lookup the website in Cell "H2", "www.crimegrade.org" then get the zip code from Cell "B2", and enter it in the search field on the webpage then return the value or grade that is the response generated (You will find the grade by scrolling down below the map above the words "Overall Crime Grade") from the search and populate the column in "H2" and center the reply and also format the reply in Non-Bold type with font Calibri 11 pt. and repeat this function all the way down the sheet until the last row which is in this case "Row 423"
Function 2 - To have excel open an internet browser and lookup the website in Cell "I2", "www.niche.com" then get the zip code from Cell "B2", and enter it in the search first search field on the webpage (the one on the left). then return the value or grade that is the response generated from the search (You will find the search result just below the map above the words "Overall Niche Grade" and populate the column in "I2" and center the reply and also format the reply in Non-Bold type with font Calibri 11 pt. and repeat this function all the way down the sheet until the last row which is in this case "Row 423" If no letter grade is returned I will need to fill that with the term "No Data".
Function 2 - To have excel open an internet browser and lookup the website in Cell "J2", "https://www.realtor.com/realestateandhomes-search/60002/overview" then get the zip code from Cell "B2", and enter it in the search first search field on the webpage (the one on the left). then return the "Median Sold Home Price" that is the response generated from the search (You will find the search result just below the words "Home values in" (It will be the 3rd dollar value from the left, and populate the column in "J2" and center the reply and also format the reply in Non-Bold type with font Calibri 11 pt. and repeat this function all the way down the sheet until the last row which is in this case "Row 423" If no letter grade is returned I will need to fill that with the term "No Data".
Thank you in advance with your help on this.
Function 1 - To have excel open an internet browser and lookup the website in Cell "H2", "www.crimegrade.org" then get the zip code from Cell "B2", and enter it in the search field on the webpage then return the value or grade that is the response generated (You will find the grade by scrolling down below the map above the words "Overall Crime Grade") from the search and populate the column in "H2" and center the reply and also format the reply in Non-Bold type with font Calibri 11 pt. and repeat this function all the way down the sheet until the last row which is in this case "Row 423"
Function 2 - To have excel open an internet browser and lookup the website in Cell "I2", "www.niche.com" then get the zip code from Cell "B2", and enter it in the search first search field on the webpage (the one on the left). then return the value or grade that is the response generated from the search (You will find the search result just below the map above the words "Overall Niche Grade" and populate the column in "I2" and center the reply and also format the reply in Non-Bold type with font Calibri 11 pt. and repeat this function all the way down the sheet until the last row which is in this case "Row 423" If no letter grade is returned I will need to fill that with the term "No Data".
Function 2 - To have excel open an internet browser and lookup the website in Cell "J2", "https://www.realtor.com/realestateandhomes-search/60002/overview" then get the zip code from Cell "B2", and enter it in the search first search field on the webpage (the one on the left). then return the "Median Sold Home Price" that is the response generated from the search (You will find the search result just below the words "Home values in" (It will be the 3rd dollar value from the left, and populate the column in "J2" and center the reply and also format the reply in Non-Bold type with font Calibri 11 pt. and repeat this function all the way down the sheet until the last row which is in this case "Row 423" If no letter grade is returned I will need to fill that with the term "No Data".
Thank you in advance with your help on this.
Zip Code | Zip Code Numeric | City / Town Name | County 1 | County 2 | County 3 | County 4 | Crime crimegrade.org | Schools www.niche.com | Median Sales Price Realtor.com |
www.crimegrade.org | www.niche.com | www.Realtor.com | |||||||
ZIP Code 60002 | 60002 | Antioch | Lake | No Other County | No Other County | No Other County | A - | B+ | $ 272,500.00 |
ZIP Code 60004 | 60004 | Arlington Heights | Cook | No Other County | No Other County | No Other County | A | A+ | $ 377,500.00 |
ZIP Code 60005 | 60005 | Arlington Heights | Cook | No Other County | No Other County | No Other County | B+ | A+ | $ 305,000.00 |
ZIP Code 60006 | 60006 | Arlington Heights | Cook | No Other County | No Other County | No Other County | A - | No Data | No Data |
ZIP Code 60007 | 60007 | Elk Grove Village | Cook | Dupage | No Other County | No Other County | C | A - | $ 320,000.00 |
ZIP Code 60008 | 60008 | Rolling Meadows | Cook | No Other County | No Other County | No Other County | C - | A | $ 221,000.00 |
ZIP Code 60009 | 60009 | Elk Grove Village | Cook | No Other County | No Other County | No Other County | C - | No Data | No Data |
ZIP Code 60010 | 60010 | Barrington | Lake | Cook | Kane | McHenry | |||
ZIP Code 60011 | 60011 | Barrington | Lake | No Other County | No Other County | No Other County | |||
ZIP Code 60012 | 60012 | Crystal Lake | McHenry | No Other County | No Other County | No Other County | |||
ZIP Code 60013 | 60013 | Cary | McHenry | Lake | No Other County | No Other County |