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?


Participate now!

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