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.

Attached Files

Backups Jobs Tracking - Copy.xls (76.5 KB, 12 views)