VBA - Select filtering and applying quantity amount to listed percentages : I tried to search but didn't find anything that was exact to what I was looking for. Let's say that I have the Investment$$ and I want to allocate that amount to only Items = to Toy Story and where Character begins with TS. The Investment $$ should only be applied to "Toy Story" and where character begins with "TS".

Apologies on not being able to embed the pictorial example to this message.

I need to write this in VBA. My questions is, is the best way to do this through a vlookup (programmed via VBA)? I want to avoid having the $1000 applied to the wrong movie title and even when it is applied to the right one (Toy Story) I want to make sure it's applied to the right ("TS") ones.

I'll also experiment on my end as well.

Thanks for any advice.


[Pixar Movie Example][1]


  [1]: https://i.stack.imgur.com/oxfvz.png