I need to have data from the stockhistory function in a table format. It can be accomplished by running the spilled array outside of the table and then copying the data into the table by using ( =Cell reference) within the table. The problem is the range within the table is fixed and I need the table to expand and contract dynamically and automatically based on the number of dates in the stockhistory spilled array results outside of the table. Any Ideas on how to accomplish this?