and when salesperson columns are added or deleted. Then use this range name to sum sales in cell B2. (Scroll across to see answer.)
A great use for dynamic range names is with pivot tables. Suppose you want to base a pivot table on a data set that is likely to expand (or even contract) as time goes on. You can create a dynamic range name such as MyData for the data set. Then when the pivot table wizard asks for the data range, enter MyData. If your data set expands or contracts in the future, all you need to do is click on the Refresh pivot table button (!) to update the pivot table with the newest data. If you show this trick to your colleagues at work, you’ll be a hero!
Dostları ilə paylaş: |