LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
SJC
 
Posts: n/a
Default 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!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Links in Excel ww Excel Discussion (Misc queries) 0 March 15th 05 02:41 PM
Links to other files Eric Excel Discussion (Misc queries) 1 February 24th 05 10:49 PM
HELP!!! Missing Links!!! [email protected] New Users to Excel 2 February 16th 05 03:20 PM
How to update multiple links in multiple spreadsheets followin mo. Andy Excel Worksheet Functions 0 January 20th 05 04:51 PM
Links in formulas change when another user runs a workbook L Mehl Excel Discussion (Misc queries) 2 November 27th 04 09:27 PM


All times are GMT +1. The time now is 03:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"