Spreadsheets Links
 

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!

=if('Patient Log-May 05'!D10="","",'Patient Log-May 05'!D10)

should work.

SJC wrote:

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!

--

Dave Peterson