Hi

I've got a PDL that has 2000 names on it and I need to update it. I have a
list of names in excel which is the latest informaion that I need to compare
with the names on the PDL. I know I can use a vlookup to do the comparison
but when I try and bring in the PDL as a text file I lose all most of the
info as I have more names than columns in excel.

Any ideas greatly appreciated as I don't want to have to manually work out
the new names.

Thanks

Bec

Contact me at (remove spaces)
Help From @ JlathamSite. com
and I'll try to help. I'd need to write a routine to read the PDL file
directly from disk and 'transpose' it onto a sheet in your Excel book, and
that means I need to see the format and content of the PDL to figure out how
to do it. Although if you can accurately describe the PDL's format &
content, I might be able to do it without seeing the file - but nothing works
as well as having real-world data to test with.

Need to know things like the "field separator" when it's read as a text file
and whether each row of the PDL is a field related to the content of the 1st
row:

Like if your PDL file is something like:
Ralph, Phyllis, Mark
101, 832, 121
A44,B19,C304
where you would want it to end up as
Ralph 101 A44
Phyllis 832 B19
Mark 121 C304

we could work up a file read and import routine pretty easily.


"Bec G (Oz)" wrote:

Hi

I've got a PDL that has 2000 names on it and I need to update it. I have a
list of names in excel which is the latest informaion that I need to compare
with the names on the PDL. I know I can use a vlookup to do the comparison
but when I try and bring in the PDL as a text file I lose all most of the
info as I have more names than columns in excel.

Any ideas greatly appreciated as I don't want to have to manually work out
the new names.

Thanks

Bec