Linked sheets, blank cells and adding new rows

[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

 

[Gary Brown]

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.