I've been giving a task that I have not been able to complete due to the data being changing constantly.
This is what I need: A report is generated with the amount of products sold by the hospitals (17 hospitals total). the length of the product list for each hospitals sold will depend on the products they sell, that is why you can find a hospital with 10 type of products one month and the next one it is 25 ( meaning there is not the same amount of product all the time nor the same type of product. .
Type of products:
T Products
P Products
R Products: Among these we have "R Products-D, and R Products-A which can't be count, only the R products.
Z Products.
The idea is to locate a specific hospital along column A and add only the products on column F from that hospital that begins with R ( no T,P,Z, or R-D, R-A products), and onto the next one. For example
Column A Column F
Hospital 1 P Products
T Products
Z Products
R Products
R Products-A
R Products-D
Base on the example above. I'll need to find Hospital 1 among column A and add the products beginning with R except the ones ending on -A, or -D.
I hope I explained my self well enough for you to understand. I must say I recorded various macro and it worked but since the list of product sold vary in length, I will need to go and adjust manually in order to get the result.
Once again, Thank you in advance!!!!!.
This is what I need: A report is generated with the amount of products sold by the hospitals (17 hospitals total). the length of the product list for each hospitals sold will depend on the products they sell, that is why you can find a hospital with 10 type of products one month and the next one it is 25 ( meaning there is not the same amount of product all the time nor the same type of product. .
Type of products:
T Products
P Products
R Products: Among these we have "R Products-D, and R Products-A which can't be count, only the R products.
Z Products.
The idea is to locate a specific hospital along column A and add only the products on column F from that hospital that begins with R ( no T,P,Z, or R-D, R-A products), and onto the next one. For example
Column A Column F
Hospital 1 P Products
T Products
Z Products
R Products
R Products-A
R Products-D
Base on the example above. I'll need to find Hospital 1 among column A and add the products beginning with R except the ones ending on -A, or -D.
I hope I explained my self well enough for you to understand. I must say I recorded various macro and it worked but since the list of product sold vary in length, I will need to go and adjust manually in order to get the result.
Once again, Thank you in advance!!!!!.