To insert the formula or to do the filtering or what?

I guess you could if you wanted.

Start by recording a macro and reviewing that code.

Wanna Learn wrote:

Thanks Dave Is it possbible to attach a macro to do this?

Dave Peterson" wrote:

Formulas can't do this kind of thing. For the most part, they return values to
the cell that holds that formula.

Maybe you can use the same kind of formula on the other rows, then use
data|filter|autofilter to hide/show the rows that you want.


Wanna Learn wrote:

Hello
I have the following formula
=IF($B$50="Product Number",TRUE,"")
what I want to do is if the above formula is true then I want row 51 and row
52 to automatically unhide . Thanks

--

Dave Peterson


--

Dave Peterson