Linked sheets, blank cells and adding new rows

  • Thread starter Thread starter CharlieJane
  • Start date Start date
C

CharlieJane

Hi everyone.
I have linked 2 spreadsheet together, which is fine.
However the master spreadhsheet I will regularly adding extra rows, how can
I do this so it automatically links to the second sheet (without me having to
copy and past each time.)
Also my spreadsheet contains a few blank cells - at the moment they come up
as 01-jan-00. How can I adjust so they come up blank??

Many thanks for your help in advance
 
1) Copy your formulas down a ways, so that you only have to copy again every
so often
2) you've formatted cells as dates that are Not Blank. They have -0-s in
them.
Get rid of the zeros and the cells will now be blank.
 
Back
Top