Sandy,
If I understand you correct, the entry on the inventory sheet is more or
less automaticly copied to the dispatch sheet and the dispatch sheet is set
up per station.
So after the station"name" then you have a row of info of which one column
is filled with the entry of the inventory sheet (or not).
I suppose you have a heading line above this dataarea.
If this all is correct, you should be able to use an autofilter.
Select your data area (including the headingrow) on the dispatch sheet and
the (from the menu select) Data / Filter /Autofilter.
You heading row should now have dropdown boxes. In the column where the
inventoryentry are copied to select Custom and enter the conditon Cell >0 or
non blank or simular. That should hide the rows with a blank in that
column.
--
Regards,
Auk Ales
* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
Sandy said:
To give more info on what I am trying to accomplish, we are a trucking
company and get inventories on stations we deliver to. When a station
orders a load it is entered on the inventory sheet and then is copied to our
dispatch sheet. Each station has rows of information on the dispatch sheet.
If there is no information that was copied over to the dispatched sheet we
want to hide that stations row. I hope this will help you help me.
----- Gord Dibben wrote: -----
Sandy
You cannot hide just one cell. You can hide entire rows or columns depending
upon the value or non-value in a cell in that row or column.
Give us more detail. Are the blank cells the result of an IF formula or just
plain old blank?
Why do you want them hidden? Privacy or for print-outs? Too messy with
blanks all over the place?
Gord Dibben Excel MVP
information to be displayed. The problem I am have is that if a cell does
not have information in it I want it hidden. Any suggestions on how this
can be accomplished. I am very new to this type of formula or macro and am
not sure how to go about it. Please help!!
