Excel users often find themselves performing certain tasks on a repetitive basis, such as preparing reports on a weekly or monthly basis. Such tasks can involve repeated actions such as copying data from one particular source, or formatting them in a particular style, or applying … [Read more...] about How to Create Excel Macros Using Macro Recorder
excel macros
How to Extract Comments in an Excel Sheet
Comment boxes are great when you want to share additional information about Excel data. You can view all comments on a worksheet or just specific comments you want to see. However, there may be times when you need to consolidate the comments in an Excel worksheet. In this … [Read more...] about How to Extract Comments in an Excel Sheet
How to Unprotect Multiple Worksheets in One Go Using Excel Macro
Macros are an effective way to achieve certain tasks that are not possible using common Excel commands. One such task involves protecting and unprotecting multiple Excel sheets instantaneously. Just as Excel allows you to only protect one worksheet at a time, unprotecting … [Read more...] about How to Unprotect Multiple Worksheets in One Go Using Excel Macro
Extract URLs From Hyperlinked Text Using Macros in Excel 2010
There may be instances when long hyperlinked text has been made pretty by cloaking it with other text. While that may serve some purposes, there may be times when you want to view the URL's that are behind the hyperlinks. If you ever find yourself in such a situation, you can … [Read more...] about Extract URLs From Hyperlinked Text Using Macros in Excel 2010
Remove Hyperlinks in an Excel 2010 Worksheet With a Simple Macro
There may be times when you have an Excel sheet with a whole lot of data containing hyperlinks. And you may find that although you do need some of that data, you don't really want all those hyperlinks for your current project. If you want to remove the hyperlinks manually, it can … [Read more...] about Remove Hyperlinks in an Excel 2010 Worksheet With a Simple Macro
Macro to Concatenate Columns in Excel 2010
We have been working on an Excel project for some time now and when creating a database we encountered a problem. We had to merge the contents of two cells and doing this manually was time consuming due to the huge volume of records. We decided to put our VBA skills to the test … [Read more...] about Macro to Concatenate Columns in Excel 2010