Adding daily updated values to list

Heres the scenario: I import data from an outside source (Thomson Reuters) that is issued everyday. The list created is updated, a new value for volume is imported with its date. The problem is this import function does not move, and the data being imported is just shifted down, so the most recent value is at the top. I want to create a list that as new data comes in everyday, it is added to a list that stacks the values and does not shift the list down. I have though about playing with logic statements but i cant wrap my head around it. Any suggestions? forum example.xlsx

Hi hyattj

Am I correct in understanding that your K14 would be on a separate sheet? If so, what is in K13?

It is quite easy to just add to K13 and so on, but you run out of room after 12 days?

If K13 is a header, then presumably you need to insert a line between this header and the latest entry to insert the new line. Do you need to cater for adding more than one row at a time? eg at holidays time?

Regards
Alastair

You are correct, the list in column K is on another sheet and has plenty of room to be added to. The values coming in and being updated in Column F are daily volume values for a stock contract. The contract has a date of expiration and adds values only on trading days which takes into effect weekends and holidays. you can see that the dates in Column E are the dates that correspond to the volume that day. I need to have it so when this list is updated everyday, and a new value is added to cell F10, i need to add it to the list in Column K which will be on a different sheet. I have formula's the reference the list in column K and are pointless if the list doesnt keep updating and adding new values. Let me know if this helps you understand.

-Jake

Forum Sep Wheat example.xlsx

On the first sheet called data, the values are being updated. On sheet two is where i need to send the updated values. So, cell F11 on "data" sheet when updated and a new value is inputted needs to go to cell O49 on sheet two. So on and so forth until the contract expires in 40 days. I've attached the sheet so it makes more sense.

-Jake