Starting a worksheet on a particular row

[[email protected]]

I have a spreadsheet that lists information for each day.

Fri 09-01-06 A
Sat 09-02-06 B
Sun 09-03-06 C
...
Mon 08-04-07 d

I've already figured out how to conditionally format the cell that has todays date so that it stands out. What I'm trying to do is have the sheet open so that the line with todays date will be in the upper left corner. So if I open the sheet today, 09-01-06 is in the corner, and if I open it on 08-04-07, that cell is in the upper left corner. I've tried to use the Search command
Search(=Today) and that didn't work. I even tried searching by the conditional format, and that didn't work either. I was hoping someone out there might be more knowledgable than me and know how to do this. Thanks.

[oldchippy]

I have a spreadsheet that lists information for each day.

Fri 09-01-06 A
Sat 09-02-06 B
Sun 09-03-06 C
...
Mon 08-04-07 d

I've already figured out how to conditionally format the cell that has todays date so that it stands out. What I'm trying to do is have the sheet open so that the line with todays date will be in the upper left corner. So if I open the sheet today, 09-01-06 is in the corner, and if I open it on 08-04-07, that cell is in the upper left corner. I've tried to use the Search command
Search(=Today) and that didn't work. I even tried searching by the conditional format, and that didn't work either. I was hoping someone out there might be more knowledgable than me and know how to do this. Thanks.

Hi [email protected],

The formula you need in the cell is

=TODAY()

so when ever you open this sheet it will show that particular day

oldchippy

[[email protected]]

Where do I put the formula. All the cells in the first column have dates. The first row (A1) has 9/1/06, the second has A1+1, the second A2+1 and so on. The nth cell has A(n)+1.

[oldchippy]

Where do I put the formula. All the cells in the first column have dates. The first row (A1) has 9/1/06, the second has A1+1, the second A2+1 and so on. The nth cell has A(n)+1.

Hi [email protected],

Not exactly sure what you are trying to achieve, but if you put

=TODAY() in cell A1, then A2

=A1+1 and so on

oldchippy

[skatonni]

Enter =TODAY() in cell D1 and dates in cells A1 to A10
See if this code in the "This Workbook" module does what you want:

Please Login or Register  to view this content.

[[email protected]]

I must be doing something wrong. I followed the instructions, but everytime I open the test sheet. I get the MsgBox stating "Today not found"

[skatonni]

I just noted this in a previous post.

"All the cells in the first column have dates. The first row (A1) has 9/1/06, the second has A1+1, the second A2+1 and so on. The nth cell has A(n)+1."

So only cell A1 has a date. Autofill dates from A1 and the code should work.

[[email protected]]

Yes, that works. Thanks! I still don't understand why it doesn't work with the formulas though. The find command queries the value of the cell, so one would think that if the formula in a given cell calculates to the same value as another cell, Excel should find it. I guess not though.