I have a pivot table in a workbook on Sheet2. I need to use to input a number in sheet1 and then click a command button. The command button would take the user to sheet2 and automaticlly sort the pivot table by a value they entered on sheet1. I believe this is possible, but can't find good examples. For example purposes assume the following:
imput value is on sheet1, cell A1
Pivot table is on sheet2, columns A-D
Thanks
imput value is on sheet1, cell A1
Pivot table is on sheet2, columns A-D
Thanks