Lucky Cool
New Member
- Joined
- Oct 22, 2019
- Messages
- 3
Hello Friends
I am in little trouble hope you will help me.
I have a excel sheet and into this sheet data is fetch from another Software (Live Data).
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
I Put Formula in Status Column Now I want If Column is blank so its ok But if Status Column Find Sell or Buy then it Pop up a Message Box "Please Review It" with Cell Name like D2 or D4 or if there is 5 sell or Buy then 5 popup box will Open automatically.
&
If i Closed the sheet and open sheet again and if again is there any sell or buy then show pop up again automatically....
I do not want any macro button because for this i have to always click button.
Hope you can understand my Query
Please help. Thanks in Advance.
I am in little trouble hope you will help me.
I have a excel sheet and into this sheet data is fetch from another Software (Live Data).
Company Name | Value | Reaching Value | Status |
A | 1000 | 2500 | Sell |
B | 5000 | 2500 | |
C | 4000 | 2500 | Buy |
D | 4526 | 2500 | |
E | 1879 | 2500 | |
F | 4000 | 2500 | |
G | 4000 | 2500 |
<colgroup><col><col span="2"><col></colgroup><tbody>
</tbody>
I Put Formula in Status Column Now I want If Column is blank so its ok But if Status Column Find Sell or Buy then it Pop up a Message Box "Please Review It" with Cell Name like D2 or D4 or if there is 5 sell or Buy then 5 popup box will Open automatically.
&
If i Closed the sheet and open sheet again and if again is there any sell or buy then show pop up again automatically....
I do not want any macro button because for this i have to always click button.
Hope you can understand my Query
Please help. Thanks in Advance.