Send bulk emails with different attachments - Excel

I was assigned a task where I had to find a way to send bulk emails to customers. That part was easy. So, I was taking it easy. BUT comes the catch.. There were some conditions...not all attachments should be sent to everyone. Based on the nature of a candidate, the attachments should be assigned dynamically. Example: Person 1 should get only attachment 1, 2 & 3 and Person 2 should get attachments 1 & 2. At first I thought it was a crazy requirement for Excel. But

Input box on click of dropdown and update cells - EXCEL

To be honest, I really struggled with this! I had to display an input box in Excel when user selects a specific value AND update another cell with the current values stored AND replace the cells with values entered by the user. Confused? Well, so was I when this requirement was received! Check out this video for how this can be achieved. Basically, when user selects "Rescheduled" from the dropdown, we need to capture the existing dates in "Remarks" column and replace the exis