MSFT Excel pivot table links to external data

"Mr. Excel

Excel User Group"

You can also select the whole column so you don't have to add rows every time you update your data sheet. You will get "blank" as an option but you can filter that out of the pivot table results.