I would like to create a visual calender that you can click to acess certain data. ??

B

Bpfrankl

New Member
Joined
Dec 15, 2012
Messages
7
Excel 10
Noobie lvl at the moment
Hey. I am creating a spreadsheet that employees will enter data in everyday. I need to know what is the best way to insert an interactive calender that when you click on a certain date you will be directed to the coresponding data worksheets for that day. Any advice? :D
I think it would be great if it resembled this...
2013

<v:shapetype id="_x0000_t201" path="m,l,21600r21600,l21600,xe" o:spt="201" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:path o:connecttype="rect" fillok="f" strokeok="f" o:extrusionok="f" shadowok="f"> <o:lock shapetype="t" v:ext="edit"> </o:lock></v:path></v:stroke></v:shapetype>

<tbody>
</tbody>
January
April
July
October
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
1
2
3
4
5
1
2
3
4
5
6
1
2
3
4
5
6
1
2
3
4
5
6
7
8
9
10
11
12
7
8
9
10
11
12
13
7
8
9
10
11
12
13
6
7
8
9
10
11
12
13
14
15
16
17
18
19
14
15
16
17
18
19
20
14
15
16
17
18
19
20
13
14
15
16
17
18
19
20
21
22
23
24
25
26
21
22
23
24
25
26
27
21
22
23
24
25
26
27
20
21
22
23
24
25
26
27
28
29
30
31
28
29
30
28
29
30
31
27
28
29
30
31
February
May
August
November
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
1
2
1
2
3
4
1
2
3
1
2
3
4
5
6
7
8
9
5
6
7
8
9
10
11
4
5
6
7
8
9
10
3
4
5
6
7
8
9
10
11
12
13
14
15
16
12
13
14
15
16
17
18
11
12
13
14
15
16
17
10
11
12
13
14
15
16
17
18
19
20
21
22
23
19
20
21
22
23
24
25
18
19
20
21
22
23
24
17
18
19
20
21
22
23
24
25
26
27
28
26
27
28
29
30
31
25
26
27
28
29
30
31
24
25
26
27
28
29
30
March
June
September
December
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
S
M
T
W
T
F
S
1
2
1
1
2
3
4
5
6
7
1
2
3
4
5
6
7
3
4
5
6
7
8
9
2
3
4
5
6
7
8
8
9
10
11
12
13
14
8
9
10
11
12
13
14
10
11
12
13
14
15
16
9
10
11
12
13
14
15
15
16
17
18
19
20
21
15
16
17
18
19
20
21
17
18
19
20
21
22
23
16
17
18
19
20
21
22
22
23
24
25
26
27
28
22
23
24
25
26
27
28
24
25
26
27
28
29
30
23
24
25
26
27
28
29
29
30
29
30
31
31
30

<tbody>
</tbody>



Thanks,
Brad
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
Sort by date Sort by votes
Bpfrankl said:
Excel 10
Noobie lvl at the moment
Hey. I am creating a spreadsheet that employees will enter data in everyday. I need to know what is the best way to insert an interactive calender that when you click on a certain date you will be directed to the coresponding data worksheets for that day. Any advice? :D
I think it would be great if it resembled this...
2013<v:shapetype id="_x0000_t201" path="m,l,21600r21600,l21600,xe" o:spt="201" coordsize="21600,21600"> <v:stroke joinstyle="miter"> <v:path o:connecttype="rect" fillok="f" strokeok="f" o:extrusionok="f" shadowok="f"> <o:lock shapetype="t" v:ext="edit"> </o:lock></v:path></v:stroke></v:shapetype>

<tbody>
</tbody>
JanuaryAprilJulyOctober
SMTWTFSSMTWTFSSMTWTFSSMTWTFS
1234512345612345612345
678910111278910111213789101112136789101112
13141516171819141516171819201415161718192013141516171819
20212223242526212223242526272122232425262720212223242526
2728293031282930282930312728293031
FebruaryMayAugustNovember
SMTWTFSSMTWTFSSMTWTFSSMTWTFS
12123412312
3456789567891011456789103456789
10111213141516121314151617181112131415161710111213141516
17181920212223192021222324251819202122232417181920212223
24252627282627282930312526272829303124252627282930
MarchJuneSeptemberDecember
SMTWTFSSMTWTFSSMTWTFSSMTWTFS
12112345671234567
34567892345678891011121314891011121314
1011121314151691011121314151516171819202115161718192021
17181920212223161718192021222223242526272822232425262728
24252627282930232425262728292930293031
3130

<tbody>
</tbody>



Thanks,
Brad
Click to expand...

You can add hyperlink to each date.
just click on the cell with right mouse button and choose Hyperlink
 
Upvote 0
Awesome. :) Now how do i create an array of hyperlinks "quickly" and will automatically assign to new blank data spreadsheets each day. As i will have multiple years of data stored at some point? This forum is great i hope that one day i will be able to help others as you guys are helping me. :D
 
Upvote 0
You must log in or register to reply here.

Similar threads

K
  • Question
conditional formatting question
Replies
2
Views
151
kerm007
K
imback2nite
  • Solved
VBA help.
2
Replies
10
Views
349
Peter_SSs
Peter_SSs
N
  • Solved
Formula to get the range of certain Category
2 3
Replies
25
Views
344
Peter_SSs
Peter_SSs
S
  • Question
Check if a previously drawn number is in a group.
Replies
1
Views
260
Excel Novice 1
E
A
  • Question
Assign Month number 1 to n based on sequential week range
Replies
6
Views
240
amolvijay
A

Forum statistics

Threads
1,214,606
Messages
6,120,487
Members
448,967
Latest member
visheshkotha

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top