Can I establish a link based on a date?

G

Guest

Is this possible? I need to set up a sheet where each column represents a
particular date. The rows will have the mathematical figures for the
coresponding column they are in. Each row's information will then be linked
to a different page, but I don't want the information to link until we've
come to that column's date.

Example:

A B C D
1 04/25 04/26 04/27 04/28
2 1.25 4.28 8.75 5.35
3 9.45 4.52 1.25 8.54
4 5.25 5.55 0.21 7.45

Row 1 shows the dates.
Row 2 info will link to Sheet II.
Row 3 info will link to Sheet III, etc.

So, Sheet II will show the info for column A and col. B, but should not show
col. C info until Wednesday, col. D until Thursday, etc.

Can it be done?

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Cell is Blank (Though a Link), Hide Result, Else Normal Font 5
Can I link/lock rows so they move together in a sort? 1
Counting a range of cells based on 2 dates? 1
How can I use a sheet in a formula based on the value in a cell 2
Delete columns based on a cell reference date value 4
Can I link a row on sheet 2 to a row on sheet 1? 1
How can i add multiple links within a workbook? 4
How can I make a sheet display data from another sheet based on date criteria? 1

Top