CODEWITHSUNDEEP
excelpivot-tablenamed-rangesexcel-indirect
ciso
ciso

Reputation: 3050

Can a Defined Name in a cell provide the data source for a PivotTable?

I have several tables of data and I've named them. I'd like to create one PivotTable and be able to key the name of a data range into a cell and have the PivotTable reference the range named in that cell.

For example, if I could have the PivotTable data source be =A1 and in A1 have the word PayrollTable which is a Defined Name referencing sheet1!A2:G200.

What would I need to put into the PivotTable data source for it to be able to access the name in A1 which then references the Defined Name range?

Upvotes: 0

Views: 1580

Answers (1)

pnuts
pnuts

Reputation: 59450

Please try: 

=INDIRECT(A1)

INDIRECT.

Upvotes: 1

Related Questions