Hi,
I am trying to build a VBA Macro to Hide-Unhide rows that does not
contain a value in a specific column of my sheet. I would like to do it
automaticaly without me having to play a macro. I have a VLOOKUP in the
cells I want evaluated so if I enter data on another tab it would
automatically fill in the data, which in return will automatically unhide the
row that has the new data or hide the row where the data is removed. I hope
this makes sence. Is there a way to do this?

How about an alternative?

You could apply Data|Filter|Autofilter (xl2003 menus)

Then use the dropdown arrow and do a custom filter to show only those rows that
contain what you want.

You could even record a macro when you show all the data and refilter if it's
really important to mechanize it.

Thomas Price wrote:

Hi,
I am trying to build a VBA Macro to Hide-Unhide rows that does not
contain a value in a specific column of my sheet. I would like to do it
automaticaly without me having to play a macro. I have a VLOOKUP in the
cells I want evaluated so if I enter data on another tab it would
automatically fill in the data, which in return will automatically unhide the
row that has the new data or hide the row where the data is removed. I hope
this makes sence. Is there a way to do this?

--

Dave Peterson