On Jul 21, 12:08 pm, StumpedAgain
wrote:
You can't fit more than one cell into another cell so in your example you
can't fit B4:F4 into a single cell. You can do something like:

=IF('Underground & Kits'!$D4 0, 'Underground & Kits'!B4', 0)

and drag it (copy/paste) to multiple locations.

As for hiding rows, you can either right click on the row (on the far left
on the number) or you can run a quick macro that will check if the row has
anything in it and if it doesn't, it can hide it for you. If you are doing
this on a regular basis, I would consider looking in to writing a macro (or
getting one from these forums). I hope this helps! Let me know if this
doesn't answer your question.

--
-SA


Perhaps this instead:
=IF(OR('Underground & Kits'!$D4="",'Underground & Kits'!
$D4=0),"",'Underground & Kits'!B4')