open to cell

D

dpb0180

How do i open a workbook to a cell using a referance formula, example (I have
a auto update date set in a1 and a list of other dates below, how would I
have the workbook open to the date that is the closest to ref:a1)?
 
Top