Special Colum sizing

[monagan]

I'm trying to find a way that when a value is entered, (say "Toy
Prices") that my spreadsheet will hide all the other rows... fo
instance..

Enter Value: Toy Prices


Toy Prices | Clothing Prices | Jewelry Prices|
---------------------------------------------------------
hggh | fgfgfg | dfgfhh |



to become.....

Toy Prices |
--------------
hggh |


Thanks
Monagan

 

[Frank Kabel]

Hi
this would require VBA (using an event procedure like worksheet_change)
Do you want to go this way?

 

[Tumbleweed]

You may want to try advanced filters, unless you want to do vba. Advanced
filters will let you copy data that meets some criteria to another area of
the same sheet. Lookup functions may also be helpful.

 

[monagan]

Yes, I'd like to go the VB way. If you could help me out that wa
thanks

 

[Frank Kabel]

Hi
o.k. then please give some more information. Your original question was
a little bit ambigious:
- your example showed hidden columns but you mentioned to hide rows
- do you want to unhide the rows also?
- do you want to happen this automatically (using an event procedure)
or would a on demand macro be sufficient

 

[RagDyer]

This sounds like a perfect example of what "Custom Views" was designed for.
Check out this link, and if it sounds as if it's something that you might
like to try, post back with any questions.

http://tinyurl.com/3cwqa
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Yes, I'd like to go the VB way. If you could help me out that way
thanks.