I have a sheet in my workbook that updated web-site information (a table) when it is opened. I would like to update the information on a daily basis at a specific time (that's issue #1). After the information is downloaded, I would like to copy information from a specific cell in the downloaded table to a cell on a different worksheet in the workbook. When this information is downloaded, it will appear in the next cell (separated by months) as daily data. Example: Sheet2!U44 is the sum of Sheet31!K54 currently. I would like to fill in cell Sheet31!A53 thru G57, based on the day of the month (the next blank cell). The kicker is that tommorrow's data will be in Shee2!U44 when it is downloaded.
Thanks for your help,