Create A Pivot Table That Initially Contains No Data

  • I host multiple seminars per year. Each event is attended by 200-300 people.


    All attendee information is stored on one spreadsheet. I have created a user form that the administrator can use to assign a table number to an attendee.


    I would like to create pivot tables that just contain first and last name that automatically populate when a table number is assigned to an attendee. However, the issue I am facing is at the time I create the pivot tables no one will be assigned to any of the tables. From what I know, it is not possible to have a pivot table that does not hold any data.


    Can anyone suggest a workaround to this problem or maybe suggest an entirely different approach to displaying all seating information on one spreadsheet?


    TIA.

  • Post by SwensonS1 ().

    This post was deleted by rory ().

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!