If I understand what you want to do, mainly have a Slicer selection entered into a designated cell. There is a discussion of this at http://www.mrexcel.com/forum/excel-q...lues-cell.html. It involves VBA to do that.