LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
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
adding row in two sheets which are linked madfish Excel Discussion (Misc queries) 0 December 14th 07 03:56 PM
Adding rows/columns to linked file budgetgal Links and Linking in Excel 1 October 20th 07 09:13 AM
Return a blank cell instead of a zero value for two linked sheets. Matt Excel Discussion (Misc queries) 1 February 4th 07 02:37 AM
Adding rows in linked spreadsheets Parcey Excel Discussion (Misc queries) 1 December 28th 05 06:28 AM
Hiding Rows if the linked rows are blank KG Excel Discussion (Misc queries) 9 May 18th 05 02:32 AM


All times are GMT +1. The time now is 04:05 AM.

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"