I never claimed to be overly bright, so I'm lost with your example!

If the formula in A2 is copied down Column A, what happens when it comes to
A6?

And ... what's in B7?

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"gripnrip" wrote in message
...
Sure. Here's the code I am using to do the numbering:

A6
=1

A2
=IF(B7<"",0.01+A6,"")

With the formula from 'A2' copied to all cells in column A, those cells
are
showing up in the linked document, even though they do not contain any
data.



"Ragdyer" wrote:

If your original formulas are configured to return a null ("") if
conditions
are not met, then the linked cells of the second file should reflect that
null return and display a blank appearing cell.

Care to post some of the formulas you're using?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"gripnrip" wrote in message
...
Is it possible to exclude cells with formulas and no data from showing
in
another Excel file that is linked?

The formulas only put data in the cell if other conditions are met, so
if
those conditions are not met and the cells do not display data, they
shouldn't be seen in the Excel file that is linked to it.

Hopefully thad made sense.