Hi all,
I don't know whether this forum is intended for such questions, but no doubt I'll be told if it isn't! Here goes.
I've created a simple spreadsheet to illustrate a requirement that I can't find a process to deal with.
Box A of the sheet shows the change of price for “funds” by date, with an accompanying chart. To add a new row of data for the next date's values, I add a row (or cells) above the yellow line. This automatically extends the chart to include the next row of data, which is great.
Turning to Box B, this converts the pricing data into values. To get the latest valuation, I have to copy the prices from Box 1. I'd like to be able to pick them up automatically but can't see how I can do that, short of using database techniques or look up table-type actions. AM I missing something simple, or do I have to get technical?
Thanks,
Ian