Hi, i have a simple text input of 3 columns and multiple rows, first column is the store number, second column contains sales data and the third column is called “override” and this override column is blank to begin with. What i need is to pass this data to a macro and have the macro prompt the user with a yes/no dropdown option for every single row. Eg it asks me yes/no for row 1, then row 2 etc. The macro will then enter the users selection into the override column so that the out put of the macro would be something like Row 1=yes, row 2= No, row 3 = yes etc. Is this achievable if so can anyone offer any guidance?
Example data before entering macro;
| Store | sales value | Override |
| A | 1000 | null |
| B | 2000 | null |
| C | 3000 | null |
example data after entering macro
| Store | sales value | override |
| A | 1000 | Yes |
| B | 2000 | No |
| C | 3000 | Yes |
