Hello there,
SheetA is where a user can input a type of animal and labelit 1 or 0. The sheet is interactive and is in a list form where the user can continuouslyadd animals and labels.
<tbody>
</tbody>
In SheetB, I have a tally of the animals which produces apercentage.
<tbody>
</tbody>
I’m wondering if there’s any way I can have a message boxpop-up while the user enters the data on SheetA when it reaches a certainpercentage in SheetB. The trick is, the data entered on SheetA doesn’t gettransferred to SheetB until the user clicks on a ‘Transfer’ button on SheetA.
SheetA is where a user can input a type of animal and labelit 1 or 0. The sheet is interactive and is in a list form where the user can continuouslyadd animals and labels.
Bird | 1 |
Dog | 0 |
Cat | 1 |
| |
In SheetB, I have a tally of the animals which produces apercentage.
Bird | Dog | Cat |
100% | 0% | 100% |
1 | 0 | 1 |
| | |
I’m wondering if there’s any way I can have a message boxpop-up while the user enters the data on SheetA when it reaches a certainpercentage in SheetB. The trick is, the data entered on SheetA doesn’t gettransferred to SheetB until the user clicks on a ‘Transfer’ button on SheetA.