Looking for some help.... How can I do this in Excel?

[Phillips]

I am trying to create a "Table Assignment" worksheet. What I get from my
charity is how many people are in a party, and in some cases, who they want
to sit with. The tables seat 10 each.


How could I do this? Any suggestions, ideas etc?
Or...Does anybody know of anything like this already created?

TIA

 

[Frank Kabel]

Hi

I don't think you can easily do this in Excel. This involves
calculation possible seating arrangements, checking your restrictions,
etc. Maybe you should look at some dedicated tools for this. Find below
a list of some tools which may help you (no recommendations, just a
short Google search):
http://www.eventrebels.com/ProductSpecial.asp
http://www.2become1weddings.com/ceremony_reception_seatingarrangement.h
tm


HTH
Frank