Displaying only rows that data in cerain cells

S

Shane

OK lets see if i can explain this. To make it simple i have 6 colums down
300 rows. Now, Column A is the key column. i want a way after entering in
the data to display the rows only if there is data(whick will be a number) in
row A. Maybe have the filtered outcome sent to a another sheet for easy
printing and viewing. I am nubie at this any help would be appreciated.
 
D

Dave Peterson

Why not just apply Data|Filter|autofilter to that range and show the non-blank
rows. Pick out a column that always has data if that row is used and filter by
that.
 
S

Shane

Thanks dave,that was simple. Now that i have it i created a macro to do this
filter can i assign a macro to a option button so other users can click on a
button to run this macro.
 
D

Dave Peterson

Just a thought.

I'm not sure I'd give the users a macro.

If you can teach them how to use data|Filter|autofilter (or just how to use the
arrows(!)), you may find that those users will like it and use that technique on
other workbooks.

By giving them a macro, you may be stifling their development????
 
S

Shane

Thanks Dave again, good tip, I agree.

Dave Peterson said:
Just a thought.

I'm not sure I'd give the users a macro.

If you can teach them how to use data|Filter|autofilter (or just how to use the
arrows(!)), you may find that those users will like it and use that technique on
other workbooks.

By giving them a macro, you may be stifling their development????
Click to expand...
 
Top