Good morning to all hoping everyone enjoyed the weekend.
Here's my objective. I've attached a worksheet that has a filter on Relationship. I also understand that SubTotal is the correct function to use when filtering. I've already entered the SubTotal formula in D23. When I apply a Relationship filter the sub-total disappears. Is it possible to have a the sub-total be the last cell below the net amount regardless of the filering? SubTotalFiltered.xlsm
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation)
David Miller (dlmille)
In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
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.