E
Elaine
I have 2 spreadsheets. 1 contains a list of customers with full post code ie
ABC Ltd/123 High Street/ London/ N15 ABC
The post code in the final column could be either 6 digits (as above with
space in middle) or 5 digits ie B1 EDR, 7 digits ie WC1A BNM
I have another spreadsheet detailing a sales consultant with the postcodes
they cover ie
Sally Smith/ N15
Audrey Green/B12
Geoff Smith/B15
I need to get the Sales Consultants name into the Customer spreadsheet -
there are 8,500 lines so I need something automated rather than a manual task.
Can anyone help?
Many thanks - Elaine
ABC Ltd/123 High Street/ London/ N15 ABC
The post code in the final column could be either 6 digits (as above with
space in middle) or 5 digits ie B1 EDR, 7 digits ie WC1A BNM
I have another spreadsheet detailing a sales consultant with the postcodes
they cover ie
Sally Smith/ N15
Audrey Green/B12
Geoff Smith/B15
I need to get the Sales Consultants name into the Customer spreadsheet -
there are 8,500 lines so I need something automated rather than a manual task.
Can anyone help?
Many thanks - Elaine