Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
links in Excel
Hi
I want to 'blanket' copy one sheet to another in seperate workbooks creating links so one updates the other, but I don't want to reference each cell and also I don't want zeros in where blanks are in the source data sheet. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
links in Excel
Homer,
Copy the sheet, then select all the cells, use Edit / Go To.... Special Constants. Note the address of the activecell, then type =, navigate to the same cell on the original worksheet and select it, and then press Ctrl-Enter. Do the same thing for formulas (Edit / Go To.... Special Formulas), and you're done. HTH, Bernie MS Excel MVP "Homer" wrote in message ... Hi I want to 'blanket' copy one sheet to another in seperate workbooks creating links so one updates the other, but I don't want to reference each cell and also I don't want zeros in where blanks are in the source data sheet. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
links in Excel
I'm not sure what you mean by not wanting to "reference each cell", but in
terms of preventing that annoying blanks-to-zeroes thing, try this: =IF('C:\Folder\[linked file.xls]sheet_name'!A2<"",'C:\Folder\[linked file.xls]sheet_name'!A2,"") -- Hmm...they have the Internet on COMPUTERS now! "Homer" wrote: Hi I want to 'blanket' copy one sheet to another in seperate workbooks creating links so one updates the other, but I don't want to reference each cell and also I don't want zeros in where blanks are in the source data sheet. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Breaking Links in Excel 2000 | Excel Discussion (Misc queries) | |||
Breaking Links in Excel 2000 | Excel Discussion (Misc queries) | |||
can excel links be somehow relative to folder structure? | Excel Discussion (Misc queries) | |||
Data from Excel 2000 Worksheet with external links is not displayed when opened in Excel 2003 | Links and Linking in Excel | |||
How do I Break links Using Excel 2000 | Excel Discussion (Misc queries) |