Forum Discussion

Carl James's avatar
Carl James
Copper Contributor
Sep 28, 2018

Piovt Table Help

Hey everyone! So I'm new to Pivot Tables but I've sorta self taught myself on a crash course last night. My questions is, I have several tables named by month for a budget spreadsheet. In a separate cell I have a list of these months I can select. Is it possible to create a pivot tables source data based on the value selected in this cell which contains the name of a specific range of data.

 

I've tried. =INDIRECT(CELL) and that doesn't work.

 

Please help. Thanks.

excel

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Sep 29, 2018

    Hi

     

    It could be possible with VBA or Power Query but I think the easiest way is to have the data just on one sheet with an extra column for the month. The month field would be you field in the pivot table report filter.