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.

Shane wrote:

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.

--

Dave Peterson