Thread: Hiding rows or columns based on cell contents
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill H Bill H is offline
external usenet poster
  
Posts: 2
Default Hiding rows or columns based on cell contents
I am looking for a solution to hide row or columns in a worksheet based upon
a value in a cell of another worksheet.

To be more specific, I have a "setup" worksheet, with a column if entires.
I have a second worksheet, "checklist" that I would like to format according
to the entries in "setup".

If setup:A1 is empty, I want to hide columns checklist 1-3
If setup:A2 is empty, I want to hide columns checklist 4-6.

ANy ideas how to set this up automatically ?

Reply With QuoteReply With Quote