Filtering through large sets of data can be a challenge especially if you are looking to only apply a subset of filter selections through 100s of selections options. Good news is there is a better way with VBA when using the Leverage & Lean Excel Selection as Filter Criteria macro! This Excel macro will reference your current selection and use the contents of this range as the filter criteria.

It is refreshing to see open an Excel Workbook and see all the worksheets in order.  This isn’t just refreshing but is powerful as you don’t have to waste time navigating looking for a worksheet. Being organized allows you and your colleagues to work quickly and with little effort.   This is in part of why Leverage & Lean created the Excel Sort All Worksheets macro.  This Excel macro will look at all available Excel Worksheet names and sort them in order.  Whether you are managing an Excel Workbook with names or numbers the Excel Sort All Worksheets macro will help you stay organized and allow you to focus on the work at hand.

If you have copied a worksheet in an Excel Workbook using the Move or Copy activity, then you know that there is much to be desired during this experience. Because this activity is designed to Move or Copy multiple clicks must be made to copy the Excel Worksheet where and how you want. It is easy to forget the small checkbox confirming you want to Copy the Excel Worksheet and not Move it which is the default behavior. The Move or Copy activity gives the appearance that you can only copy one Excel Worksheet at a time but that is not the case. You can use Ctrl or Shift to make multiple selections of Excel Worksheets before accessing the Move or Copy activity. We noticed all of this at Leverage & Lean which is why we created the Excel Copy All Worksheets macro! This Excel macro will loop through all available worksheets and copy then either immediately after the current worksheet or append to the end of all available worksheets. Not only does this Excel macro provide a fast way to copy all worksheets in an Excel Workbook it also gives you the opportunity to customize the naming convention of the newly copied worksheet with some simple code updates.

The Concatenate function in Excel is powerful in that it can create unique identifiers to help you sort and better understand your dataset. One issue with the Concatenate function is when you want to join many columns together in Excel. Setting up a Concatenate formula across 10 or more cells becomes an opportunity to pick your pain either doing a lot of typing or clicking. You can use the TextJoin function in Excel which is designed to handle concatenation across a range of cells. If you want to avoid typing a formula in Excel, then checkout Leverage & Lean’s Excel Quick Concatenate across Multiple Cells macro!

What if you work on the interface team and are responsible for managing thousands of text files. After threats of malware your company is looking push security but there is a catch you are now responsible for updating all these .txt files with a new of code. Where do you even begin? This is a time consuming task and accuracy is critical which is why we created the Excel Find and Replace across Multiple Text Files macro!