All,

I looked around and didn't find another post that addresses my questions so I'm making a new one. See attached spreadsheet -

1) If I want to automatically download data from a website that requires a login -- password, login ID such as email address -- fake example (www.bloomberg.com/peanut_prices.xls) and APPEND the data into the attached workbook (Sheet1), starting at cell A3. I say APPEND because in the event that the column width of the downloaded data goes beyond cell F3, I wanted included everything without overwriting cell G3 and beyond.

2) I want to be able to do this every morning (automatically) so that I can pull in up to date info from the site.

How do I go about doing this? If you can, please be as detailed as possible. Don't leave anything out with the assumption that I know or will know :)

Thanks!