Forum Discussion
Pivot table with variable database
Hi All, I am trying to generate a dynamic table with a variable database using the OFFSET formula, however after performing the entire procedure I see that it still takes three rows with cells wi...
Why not format your range as a table? That would make your OFFSET function unnecessary altogether as formulas, charts and pivot tables pointing to a table automatically adjust to the size of the table.
- Because the way the cells and titles are organized, a table cannot be made.
Francisco77 The advantages of tables are more important than the disadvantages of having to change your headings if you ask me.
