In the attached workbook there is a worksheet named Title. In the cell range G25:M25 I would like to reference the last cell with text on the worksheet Version History in column C.
The worksheet Version History is used to track who updated the spreadsheet last and when the updated it. I would like the date of the last update entered into column C to appear on the title worksheet in the cell range G25:M25.
Since the worksheet will be continually updated the cell in column C will change. So on in the attached worksheet the first date to appear in the merged cell range G25:M25 would be 4/1/2008. Then when the workbook was update the date that appears in the merged cell range G25:M25 would be 4/7/2008 as the reference would automatically change from cell C2 to C3.
Start Free Trial
