To begin with

I am learning to code some macros to make our excel time more efficient. These macros have gone through some initial testing on my side, and seem to work. If you do find any issues/bugs, please let me know.

I have developed these codes primarily by trial and error, and am NOT a trained VBA programmer. I have also used the macro record feature for some subtasks .

To use these codes, you can copy them on your Visual Basic Editor. Alternatively you can use the record macro feature to create a placeholder, and overwrite the default code with the new code. As you can see, these codes can be tweaked easily to perform similar tasks. However, remember that macros cannot be undone (unless you close the worksheet w/o saving), and you cannot view the formula on the cells by using F2.

Please contact me if you have any questions regarding using these codes in your excel workbooks. You can also assign shortcut keys to your macros by going to Tools-Macro-Macros (select your macro)-Options. And make sure that you dont overwrite standard shortcut keys like Ctrl C.

Happy excel time !