A coworker once showed me a toolbar function that allowed me to choose and
copy only the visible cells from a worksheet with an autofilter. The function
also allowed me to copy only the visible cells from a worksheet that had a
pivot table in it where the subsequent rows were grouped. How do I find this
function in Excel?