I'm attaching a file with a total of numbers (F7) and then another number. When I insert autosum underneath them to add them up, Autosum just picks up F8 instead of autoselecting F7 and F8. How can I get it to do its usual thing of automatically putting its "marching ants" around the F7:F8 range. Thanks EE-Excel-autosum-question.xlsx
Manually copying shapes and their assigned macros one by one to a new location can be tedious, but if you use the Excel utility workbook attached to this article, the process will be much quicker and easier.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.