Excel VBA to Copy Data from one Sheet to Another

Can the Macro Recorder dynamically find the end of a range? This is where relative and absolute macro recording come into play. Each one has their advantages and disadvantages. In this tutorial I show you how you can use the macro recorder to copy

Excel Filter: Basic to Advanced

Filter Basics First Excel's AutoFilter is a great feature to quickly display the rows in your data table that meet a certain criteria. The remaining rows that don't match your criteria are automatically hidden. Once you have your selection in view, you can edit

Copy Excel Formulas Without Changing Cell References

Would you like to copy your Excel formulas from one place to another without the cell references changing? Excel default behavior is to adjust the cell references when you copy a cell and paste to another one. You can choose to fix the cell

Excel VBA: Control WordArt Fill with Macros

How can you get this effect? Find out how you can use Excel Macros to control the fill color of Word Art in VBA. In this specific case we have a dynamic Word Art which shows a percentage value that is connected to a

Dynamic WordArt in Excel with Bar in Bar Chart

Let's get creative with Excel! In this tutorial we're going to combine Word Art together with Excel charts to create an impressive progress bar. This progress bar is a part of the % sign of our Word Art. The result is the icon for

Excel IF Formula: Simple to Advanced

The IF function is one of Excel's most common Functions The IF formula performs a test and returns a value depending on the outcome of the test. The test it performs can be simple or complex depending on the problem at hand. It's one

Simple Excel Dynamic Map Chart with Drop-down

Learn how to create a simple but impressive dynamic map chart that enables you to visualize specific KPI's by geography. This method doesn't use the relatively new Bing map feature, which means it is works on all Excel versions. The technique shown uses a

Conditional Format Index Match Result

Highlight the lookup value in Excel Excel Conditional Formatting the Index Match result in a data table In some cases, it would be a good idea to highlight the result of the Index Match lookup formula inside the original data set based

How to create a Step Chart in Excel

This tutorial is a Step by Step approach to creating a Step Chart in Excel from Scratch. You can also download the template from the link below. What is a Step Chart? A Step Chart is great for visualizing variables that change on an