Every day at work I download files from several different websites (all requiring logins and passwords) and replace old data with new up to date data.
My current process is as follows:
1. Manually log on to website, find and download file
2. Open file and move new worksheet to into my spreadsheet
3. Find and replace "old worksheet" with "new worksheet" for entire spreadsheet (also, this misses any named ranges I use).
How can I automate this process as it has become quite time consuming to get the data from all the websites.
Thanks in advance for any help you can provide!