C
chesjak
Hi
Using Excel 2003 pro.
Two Questions please.
I regularly have a list of names and addresses sent over to me from another
computer.
It takes the form of a entry number "Say" LD1234 and then the name and
address is in the following cells on the same line.
Is it possible to highlight the whole block of the entry numbers and the
addresses probably 40 at a time and transfer them to another excel page ((I
know how to do the transfer bit)) with the following criterea.
A) I want to be able to automatically place an "N" in front of the entry
number so that "say" entry number LD1234 ends up in the new excel sheet as
NLD1234.
B) when I transfer the block of names and addresses etc over to the new
excel sheet, I want excel to somehow check each name at a time and compare it
to names already in the new excel sheet and if it is there then the full line
(including the entry number etc) is not transfered. Only the ones that are
not already on the new excel sheet get put over.
Net result is that I end up with a list off entry numbers, names and
addresses which are not duplicated within the new excel sheet.
I am sure that there must be a suitable formula to enable this but I am not
that clever to do it myself. If anyone can help, I would appreciate it.
Regards
Using Excel 2003 pro.
Two Questions please.
I regularly have a list of names and addresses sent over to me from another
computer.
It takes the form of a entry number "Say" LD1234 and then the name and
address is in the following cells on the same line.
Is it possible to highlight the whole block of the entry numbers and the
addresses probably 40 at a time and transfer them to another excel page ((I
know how to do the transfer bit)) with the following criterea.
A) I want to be able to automatically place an "N" in front of the entry
number so that "say" entry number LD1234 ends up in the new excel sheet as
NLD1234.
B) when I transfer the block of names and addresses etc over to the new
excel sheet, I want excel to somehow check each name at a time and compare it
to names already in the new excel sheet and if it is there then the full line
(including the entry number etc) is not transfered. Only the ones that are
not already on the new excel sheet get put over.
Net result is that I end up with a list off entry numbers, names and
addresses which are not duplicated within the new excel sheet.
I am sure that there must be a suitable formula to enable this but I am not
that clever to do it myself. If anyone can help, I would appreciate it.
Regards