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

NO FORMULAS! Concatenate First & Last Name - Detect pattern - Excel

Excel can scare people with its extensive use of formulas. Yes, it is great. No doubt about that. But it can get overwhelming for some. So, Microsoft has a function called Flash Fill which is AMAZING! It ca detect patters in your column and replicate that. You can even use it to create Invoice No's and so much more! Check out its use to concatenate first and last name without any formulas! Pretty great right? Every time I explore Excel I learn something new. Is this also the

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