View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CharlieJane CharlieJane is offline
external usenet poster
 
Posts: 1
Default 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