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.

Brento wrote:

Hi,

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

The sheet contains N/A cells.

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

Any suggestions?

Thanks

--
Brento
------------------------------------------------------------------------
Brento's Profile: http://www.excelforum.com/member.php...o&userid=25213
View this thread: http://www.excelforum.com/showthread...hreadid=562377

--

Dave Peterson