Date Line

  • Thread starter Thread starter SophiaS
  • Start date Start date
S

SophiaS

Hello,

I would like to create a formula that when I open the file it recognizes the
date and moves the line to the appropriate date or week. I have see it done
before but can't find any help
 
You could do this with a HYPERLINK function, where you would take the
current date from TODAY and turn it into an appropriate row number and jump
to there.

Give some details about how your sheet is laid out if you want more advice,
i.e where are the dates or weeks you mention?

Hope this helps.

Pete
 
Lets say you have dates in A1 thru A366 ( 1/1/2008 thru 12/31/2008) in
Sheet1. In the workbook code area insert the following macro:

Private Sub Workbook_Open()
Sheets("Sheet1").Activate
d = Date
For i = 1 To 366
If d = Cells(i, "A").Value Then
Cells(i, "A").Select
Exit Sub
End If
Next
End Sub

When the workbook is opened, Sheet1 is Activated and column A is searched
for a date that matches the current date. That cell is selected
 
Back
Top