Linked sheets, blank cells and adding new rows
 

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

Linked sheets, blank cells and adding new rows
 

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.
--
Hope this helps.
Thanks in advance for your feedback.
Gary Brown


"CharlieJane" wrote:

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