The requirement is to create a solution within Excel that automatically validates particular cells and rejects invalid values.
This includes validation of a data value by an external service through a REST API.
1. Automatic cell value validation
Apply custom validation to cells in a particular column.
Automatically validates the cell contents whe...
Skills: automation, vba, application programming