Sorry. In your first post you said you wanted a chart updated.
If all you want to do is for B5-B9 to show the most recent data in the table, I'm sure that can be done a few ways.
One way would be to do an hlookup. What hlookup does is looks for match in the top row of a specified table and then returns the value from a specified number of rows below.
First, what is it looking up? The latest date, right? Enter =max(3:3) in the cell immediately above, B4. This will find the date with the greatest value in row 3. It's important that this equation is not in row 3 itself or you will get a circular reference. It doesn't have to be in row 4, but let's put it there for now.
Rather than go into further detail, I've attached a copy of how this can be done. Let me know if I've missed your point or if you need anything more.
|