Lookup

[Cindy]

I have a list of data.

A B C D
1 Name DOB Gender Y/N
2 Cindy 07/28 F Y

The list is anywhere from 2 rows to 100 rows of data.
This info is imported into Excel from a program we use
inhouse. I have to "prepare" the data to be used or
exported into several different outside programs. I have
a sheet for each set that reads the info and changes it
to whatever that program requires.

The one I'm working on now requires that if Col D
says "N" that it not be listed and that it not have a
blank row. Is there any way to use a lookup to do this?
Or how would I write a macro to look at the row, if it
says "N" delete the row and then move to the next row?

Thanks for any help you can send my way.

Cindy.

 

[Frank Kabel]

Hi
why not use 'Data - Filter - Advanced filter' for this?

 

[Cindy]

Frank, Thanks for the help. You helped me with
something last week as well and I really appreciated it.

I have to save this as a CSV file to use it in the
outside software. If the data is filtered when I save
it, the CSV file still shows the blank line.

This data is all formulas reading off the orginal
import. I cant figure out how I would have the fomula
say if this is = to "N" dont read this row but the next
row that says "Y".

For example:

Orginal Data would be.

1 Cindy 07/28 Y
2 Ann 01/05 Y
3 Corey 11/10 N
4 Howard 03/08 Y

The new data usually has to say different things. For
example the DOB might need to be an age. So I would read
the DOB and change it to an age. So the new data might
be.

1 Cindy 37 Y
2 Ann 26 Y
3 Howard 52 Y