Pivot Table adding new data as I put into a list.

[supernursejim]

I have a list of patients, admit dates to our facility, and readmit dates to a different facility.

Columns: Name/Date of Admit/Date of Transfer to another facility

I can manually drag range - lets say A1 to A100 and Columns A to C but can't get pivot table to pick up an entire columns so that when I add more patients it will automatically pick them up.

Thank you

 

[Col Delane]

Set up your source database as an Excel Table (select any cell in the matrix and press Ctrl+T), and then link your Pivot Table to that Table. The Excel Table will then automatically expand its dimensions as you add data, and make it available to the Pivot Table.