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
|