software

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.

ThanksHomer,

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 MVPquot;Homerquot; gt; wrote in message
...
gt; Hi
gt;
gt; I want to 'blanket' copy one sheet to another in seperate workbooks creating
gt; links so one updates the other, but I don't want to reference each cell and
gt; also I don't want zeros in where blanks are in the source data sheet.
gt;
gt; Thanks
gt;
I'm not sure what you mean by not wanting to quot;reference each cellquot;, but in
terms of preventing that annoying blanks-to-zeroes thing, try this:

=IF('C:\Folder\[linked file.xls]sheet_name'!A2lt;gt;quot;quot;,'C:\Folder\[linked
file.xls]sheet_name'!A2,quot;quot;)
--
Hmm...they have the Internet on COMPUTERS now!quot;Homerquot; wrote:

gt; Hi
gt;
gt; I want to 'blanket' copy one sheet to another in seperate workbooks creating
gt; links so one updates the other, but I don't want to reference each cell and
gt; also I don't want zeros in where blanks are in the source data sheet.
gt;
gt; Thanks
gt;