Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with linking a cell to another workbook?
I am trying to do a pay calender, and monthly budget. I have my first
workbook page setup as a basic calender with just the months and numbered days. I have red numbered dates for paydays. The rest of the workbook pages have the month, listing of bills needing to be paid, and totals. What I am trying to figure out how to do, is on my calender page, on the the cells that I have paydays marked, link them to the workbook page that has the corrasponding date. Basically, if I click on the 29th of July on the calender, it will take me to the workbook that I have the bill listed on for that day. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need help with linking a cell to another workbook?
Never mind, I figured it out. Thank you anyway.
In case anyone else needs to know, Just right click on cell you want to creat the link, select hyperlink.... select what you want to link to. "daddyzaring" wrote: I am trying to do a pay calender, and monthly budget. I have my first workbook page setup as a basic calender with just the months and numbered days. I have red numbered dates for paydays. The rest of the workbook pages have the month, listing of bills needing to be paid, and totals. What I am trying to figure out how to do, is on my calender page, on the the cells that I have paydays marked, link them to the workbook page that has the corrasponding date. Basically, if I click on the 29th of July on the calender, it will take me to the workbook that I have the bill listed on for that day. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
resetting last cell | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How copy cell workbook to workbook? | Excel Discussion (Misc queries) | |||
How do I copy a cell + it's formula from one workbook to another? | Excel Discussion (Misc queries) | |||
GETPIVOTDA - Linking Into Pivot-table Cell | Excel Discussion (Misc queries) |