Copy data when combobox value changes

[kelly mort]

I have this challenge here with me and I need some high power brains help me pull it up.

I am looking at column F because it contains items that are in my combobox.

So when I change the value in the combobox, then verify if that item is located in column F.

If it's located then no copy.

If not located, then we do something a bit cool:

1. Look at column F from last used row.
2. Use the item in the last used cell of F as the copy criteria.
3. Copy all range with copy criteria(last item in column F ) from B to E.
4. Paste it under the last used row (column B)

Thanks in advance