Is there a way to create an Action button that updates a value based on a cell reference or named reference?
So instead of hard coding a value in the ‘with these values’ field, refer to a cell or named reference on the same sheet e.g. cell F13 or named reference ‘Color’?