Suppression of lines

[Fred Scuttle]

Hello,

I have 2 worksheets on my template,

Sheet 2 (A1-A30)gets populated via a DDE command from an
external data source. The values are then compared to a
vlookup table and given a specific product code in the
adjacent cell in the B column (B1-B30). When a field in
the external data source is empty a zero is returned into
the relevant cell in the A column. The Vlookup table does
not contain a zero as a relevant option and therefore
returns a "#N/A".
On sheet 1 (cells A1-A30) I want to replicate the list of
product codes from sheet 2 but I do not want the "#N/A"'s
to come over.
e.g
Sheet2
B1 "P001"
B2 "P067"
B3 "#N/A"
B4 "P094"
Should come over to sheet1 as;
A1 "P001"
A2 "P067"
A3 "P094"

Any help or ideas would be appreciated as I have struggled
with this for a few hours with no luck.

Many Thanks and best regards
Fred Scuttle

 

[Don Guillett]

data>filter>autofilter and copy visible

 

[Fred Scuttle]

WOW!! that formula is quite mind boggling to a non
mathematician like myself!!
I am trying to understand what you are telling me to do.
Are you showing me 2 different solutions to the problem?
Either way I could not seem to get it to work.
Would you mind explaining what the formulas are doing?
Then maybe I could figure it out.

Thanks a lot

Fred>-----Original Message-----

$A$30)),ROW()),1)

 

[Tom Ogilvy]

Sent sample workbook in response to email.

--
Regards,
Tom Ogilvy

WOW!! that formula is quite mind boggling to a non
mathematician like myself!!
I am trying to understand what you are telling me to do.
Are you showing me 2 different solutions to the problem?
Either way I could not seem to get it to work.
Would you mind explaining what the formulas are doing?
Then maybe I could figure it out.

Thanks a lot

Fred>-----Original Message-----