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