Search

Create Macros - Without ANY CODE!

Yes this is possible! Its inbuilt in Excel itself. All you have to do is do a couple of clicks and your macro is ready! So, I had to create a very complex macro for a project and was going crazy. Me being super lazy thought that there has to be another way. Its MICROSOFT! And...I was right. There is a brilliant way which can be used. Ensure that you have your developer tab enabled and don't forget to save your file in Macro Enabled format. Create macro as shown in the video i

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