View Single Post
  #1   Report Post  
cds
 
Posts: n/a
Default extracting data from seating chart

the first page of my worksheet contains a list of people, table numbers and
meals selected
page two contains the table numbers.
i want to be able to type the table number on page one and have the tables
automatically fill the people on page two
is there a way to do it without utilizing the pivot table?