reasem
New Member
- Joined
- Nov 15, 2019
- Messages
- 38
Hello all, looking to create a VBA Worksheet_Calculate code that will copy cells based on criteria (the cells that are changed) and paste them to a new sheet one after the other. It is a calculate and not a change event since the cell value is changed via a formula. I have a data dump file that will import revenue and the worksheet will calculate the margin. If the margin is different than it was before, I want the cells to be copied and pasted as values to the notifications sheet. Likewise, if the predicted margin is larger than the margin, I want those cells to be copied and pasted to the notifications sheet. I'd also like a Msgbox to pop up saying "n models need to be reviewed" (n being the amount of models moved to the notifications sheet"
It would also be a bonus to specify if the margin increased or decreased in column G on the notification sheet.
Thanks!!!
It would also be a bonus to specify if the margin increased or decreased in column G on the notification sheet.
Thanks!!!