14 Aug. 1985|
Table plan templates download,wood hinges for sale,apple wood for woodworking - For Outdoors
Copyright © 2012 Templates Collection, All trademarks are the property of the respective trademark owners.
Copyright © 2012 Best Template Collection, All trademarks are the property of the respective trademark owners. Plan Your Party Seating with ExcelBy Debra Dalgleish, on March 5th, 2010If you're having a party this weekend, you can use Excel to plan the guest seating. In this example, you'll enter the guest names on an Excel worksheet, then fill the tables by selecting names from data validation drop down lists.
If a guest has been assigned to a seat, their name will appear in column D on the TablePlan sheet.
Now you can select guest names from the drop down lists on the TablePlan sheet, and get your party organized.
If you're planning your own party, you can download the sample file with an Excel seating arrangement example. It would be a great addition if there was a macro that created x number of tables with y seats and liked the cells, ready to be used! For me doing table plans, I used a slightly different route, in that I plotted the attendees on an XY Scatter plot. I am modifying this solution for a classroom seating plan and want it to handle *up to* 30 students at 30 desks.
If I update the sample file, to automatically create table and seats, I'll write about it here.