Automatically Create Outlook Task When Value <50 using adjacent cell as subject/title

Hello World!

This is literally my first foray into macros and haven't really been able to find what I'm looking for searching the internet so I was wondering if any of you lovely folks might be able to guide me to a solution.

I have an excel file that contains lots of information but for my purposes here we can just simplify it to a list of product names, product numbers and a few columns later the inventory/number we have of the product.

Is it possible to have a macro that will automatically create an outlook task when the value dips below 50 for a product in the list? I fear that such a program would keep creating new tasks for the products until the value is again above 50. Do you have a clever way of circumventing the issue?

Or to go another more involved but still very helpful way... Is there a way that I could just highlight the row of the product and hit a button and have a task created using just the product name, product number and number in stock (excluding the extra columns)?


Thank you!!! Assume (and feel confident knowing) that I know nothing about writing macros!