Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a question regarding setting up links between spreadsheets within one
workbook. I am creating a workbook that will hold one years worth of data. Each spreadsheet contains one month worth of data. I would like to set up links so that the current month automatically transfers to the next month. So then, if D25 has an 'x' on the May spreadsheet, that 'x' will carry over to the June spreadsheet. I have the spreadsheets set up to do this, but cells that are blank seem to automatically carry over a zero to the next spreadsheet, which is messing up my other formulas and counts. Is there a way to set up a link so that a blank cell will remain blank in the linked spreadsheet? This is the link formula I am using for a cell that does not contain a formula: ='Patient Log-May 05'!D10 Thanks for all of your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Links in Excel | Excel Discussion (Misc queries) | |||
Links to other files | Excel Discussion (Misc queries) | |||
HELP!!! Missing Links!!! | New Users to Excel | |||
How to update multiple links in multiple spreadsheets followin mo. | Excel Worksheet Functions | |||
Links in formulas change when another user runs a workbook | Excel Discussion (Misc queries) |