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" wrote in message oups.com...
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