Lookup

  • Thread starter Thread starter Cindy
  • Start date Start date
C

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, 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
 
Back
Top