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?