Pivot Fields to be selected from a diffrent sheet

I am having a file where i capture diffrent AUX codes on sheet 1 and then i have a pivot on sheet 2, what i am trying to do here is to give the user an option to select the agent name and the date from sheet 3. is that possible?

Re: Pivot Fields to be selected from a diffrent sheet

can somebody help me on this please????

Re: Pivot Fields to be selected from a diffrent sheet

forgot to mention i am using Excel 2003.

I am trying to give the user to select the date and the agent name from the pivot using a macro.