| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding row in two sheets which are linked | Excel Discussion (Misc queries) | |||
| Adding rows/columns to linked file | Links and Linking in Excel | |||
| Return a blank cell instead of a zero value for two linked sheets. | Excel Discussion (Misc queries) | |||
| Adding rows in linked spreadsheets | Excel Discussion (Misc queries) | |||
| Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Linear Mode
