Exporting Value Data

B

Brento

Hi,

I have created a spreadsheet with alot of data updating from anothe
spreadsheet.

The sheet contains N/A cells.

What I am trying to do is display only the cells with a value i
another sheet and if there is a row of N/A data I dont want the row t
be displayed either

Any suggestions?

Thank
 
D

Dave Peterson

I try to keep my data in the same location.

I'd select the column with the #n/a's and apply data|filter|autofilter. Then do
a custom filter to show only those rows that are not equal to #n/a.

If I really wanted, I could copy those visible rows to a different worksheet.
 
Top