My goal is to learn how to universally add specific codes to all clients in one shot.
Here's an example of the data I'm working with......
In column A - I currently have a list of 200 unique clients listed multiple times (1000 rows).
In column B - I have several different types of codes, but that are the same for each client.
Example:
A B
Client 1 Code A
Client 1 Code B
Client 1 Code C
Client 2 Code A
Client 2 Code B
Client 2 Code C
Etc. Etc. for 200 clients
So the question is: When adding a new code, How do I add a codes to all clients in one shot?
Here's an example of the data I'm working with......
In column A - I currently have a list of 200 unique clients listed multiple times (1000 rows).
In column B - I have several different types of codes, but that are the same for each client.
Example:
A B
Client 1 Code A
Client 1 Code B
Client 1 Code C
Client 2 Code A
Client 2 Code B
Client 2 Code C
Etc. Etc. for 200 clients
So the question is: When adding a new code, How do I add a codes to all clients in one shot?