View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Autonumber based on cell content - include decimals

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.