User will enter a URL that ends in a numeric number. Spreadsheet will create 500 sequential URLs by adding (+1) and subtracting (-1) to the original URL.
Example: if original URL is [url removed, login to view] then the spreadsheet will simply create active URLs from [url removed, login to view] to [url removed, login to view]
Spreadsheet must then go to each one of those URLs, copy two sections of text from each URL and paste the results in the spreadsheet. This action must be done automatically by the spreadsheet and browser. Manual copy/paste is not an option. Spreadsheet must work in both PC and Mac environments. Firefox is the preferred browser that should be used by Excel to retrieve the needed information.
DO NOT BID if you can not provide samples of your previous Excel spreadsheet projects.
27 freelanceria on tarjonnut keskimäärin 65 $ tähän työhön
I can create a macro to automate the whole process you would just have to run the macro. I can also have the macro run when the excel workbook opens so that no actions at all will be required. Best regards, Luis