I have 2 workbooks, Moo 1&2. Moo2 is a summary of Moo1. I have to be careful in Moo1 to enter the percentage for the factor adjacent to the last occurrence of that factor or the macro will give a blank for that factor in Moo2.
In the examples, A/1,2 is shown as a blank in Moo2 because it is not in the last occurrence of that factor. The other two factors are picked up because they are in the last occurrence of that factor. There is always only one percentage for a set of factors but I would like to not have to reposition the percentage as the factor list grows longer to accommodate the macro. The various factors can be several hundred rows long but are always separated by a space as shown. I would like the macro to be able to pick up the percentage of the factor without having it to be in a specific position. (The macro is in Moo2)
Bookmarks