Hi folks,
Very new to VBA, was looking for a similar cases all over the place, but the solutions are unique to the issues and would require some changes that I'm not sure how to perform, so asking in a new thread and hopefully someone could help me out here please
I'd need a code for the following task:
1) cells B20 to B30 in column B of the table in "Exit strategy" sheet contain predefined exit triggers.
2) Cells in column C of the same table in "Exit strategy" sheet contain dropdown with list of exit strategies, one of them is "Do nothing".
3) In cells C20:C30 User would choose exit strategies corresponding to each trigger in column B. If user selects "Do nothing" as an exit strategy, for example in cell C25, I want contents of cell B25 (exit trigger) copied over and pasted to an existing sheet within the workbook (sheet name "3rd party impact assessment", I want pasting to start with cell A7).
4) If user selects "Do nothing" as an exit strategy in more cells of the "Exit strategy" sheet, for example in cell C28, then corresponding exit trigger from cell B28 should be copied over and pasted onto "3rd party impact assessment" sheet, cell A8.
5) If user changes value (in above example in cell C25) that had "Do nothing" of the "Exit strategy" sheet from "Do nothing" to a different value, program would also remove the corresponding entry in "3rd party risk assessment" sheet that was previously copied over and shift other entries up, so the contents of cell A8 in "3rd party impact assessment" sheet would now be moved to A7.
6) I've already got some code in module of the "Exit strategy" sheet that hides/unhides "3rd party risk assessment" sheet based on user's selection, so if someone would have a solution to my problem, please bear that in mind and provide me with the instruction as to where to paste the new code
Many thanks in advance!
Very new to VBA, was looking for a similar cases all over the place, but the solutions are unique to the issues and would require some changes that I'm not sure how to perform, so asking in a new thread and hopefully someone could help me out here please
I'd need a code for the following task:
1) cells B20 to B30 in column B of the table in "Exit strategy" sheet contain predefined exit triggers.
2) Cells in column C of the same table in "Exit strategy" sheet contain dropdown with list of exit strategies, one of them is "Do nothing".
3) In cells C20:C30 User would choose exit strategies corresponding to each trigger in column B. If user selects "Do nothing" as an exit strategy, for example in cell C25, I want contents of cell B25 (exit trigger) copied over and pasted to an existing sheet within the workbook (sheet name "3rd party impact assessment", I want pasting to start with cell A7).
4) If user selects "Do nothing" as an exit strategy in more cells of the "Exit strategy" sheet, for example in cell C28, then corresponding exit trigger from cell B28 should be copied over and pasted onto "3rd party impact assessment" sheet, cell A8.
5) If user changes value (in above example in cell C25) that had "Do nothing" of the "Exit strategy" sheet from "Do nothing" to a different value, program would also remove the corresponding entry in "3rd party risk assessment" sheet that was previously copied over and shift other entries up, so the contents of cell A8 in "3rd party impact assessment" sheet would now be moved to A7.
6) I've already got some code in module of the "Exit strategy" sheet that hides/unhides "3rd party risk assessment" sheet based on user's selection, so if someone would have a solution to my problem, please bear that in mind and provide me with the instruction as to where to paste the new code
Many thanks in advance!
