Excel Pivot Tables - Dynamic Data Source
Excel pivot tables are usually created based on a data source that doesn’t change. So how do you deal with a data source that gets updated regularly? The article linked to below shows one way to handle this situation using Excel’s OFFSET and COUNTA formulas.
You can use a dynamic formula to define the source range for a Pivot Table. As new items are added to the table, the named range will automatically expand.
Leave a Comment
If you would like to make a comment, please fill out the form below.
You must be logged in to post a comment.
