Hey guys.
I use an ABC Analysis (Classification of items by financial relevance) spreadsheet, which was developed by a former co-worker.
PS: On Google you can find a simplified explanation for what is an ABC analysis.
For a better understanding of this question, I ask you to kindly check the attached file.
On the "Analitico" sheet, expenses are posted according to the information requested in each column. In column M there is the "centro de custo", which has different values.
As it is programmed, the ABC analysis is generated for all items, that is, for all "centro de custo" values.
However, now I need this ABC analysis to be generated according to the "centro de custo" of each item.
I would like to create a list (data validation type) in cell L3 of the "Curva ABC" sheet with the existing values of "centro de custo" on the "Analitico" sheet (no repetition or empty, that is, only exclusive items) and, in this way, when selecting the desired "centro de custo" (Obra 1, Obra 2, etc.) or by clicking on "atualizar curva ABC" ("Curva ABC" sheet) the script would run again considering only the items referring to that cost center.
Note: I understand little of VBA. As I said, this code was made by someone else. Also, if you think you can improve something, feel free to suggest or modify it.
Thank you very much in advance.
Bookmarks