I need the attached file to do the following:
1. Automatically refresh the data from the web query to Sheet1!A1:C17.
2. As soon as the web query refreshed, insert cells shifting existing data down in Range F3:U3.
3. Copy Range A2, and paste in Range F3.
4. Copy Range B4:B17, paste transposed into Range H3:U3
5. Update Chart 2 all data series to reflect last updated data for all series to reflect latest data and previous 49 rows of historical data.
Obviously more work needs to be done on this before it is a finished product, but I am stuck at this point. Your assistance will be greatly appreciated.