How do I automatically hide columns in a worksheet based on a cell value?

How do I automatically hide columns in a worksheet based on a cell
value?

I intend to set up an automated hide for a column (D) in sheet1 based
on values of some cell in worksheet 2 (say cell B2).

please provide any suggestions.

Thank you in advance.

Regards,

Deepak

Hi Deepak,
How about using an Advanced Filter see Debra Dalgleish's site
Excel Filters -- Advanced Filter
http://www.contextures.com/xladvfilter01.html
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"dkhedkar" <[email protected]> wrote in message news:[email protected]...
> How do I automatically hide columns in a worksheet based on a cell
> value?
>
> I intend to set up an automated hide for a column (D) in sheet1 based
> on values of some cell in worksheet 2 (say cell B2).
>
> please provide any suggestions.
>
> Thank you in advance.
>
> Regards,
>
> Deepak
>