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

  • Thread starter Thread starter Phillips
  • Start date Start date
P

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
 
If you cannot find an automatic method, something I use is the abilit
to click on the border of a selected cell or range and drag the whol
range and contents to somewhere else.

In your case the method would be :-

1. set up a table plan on a worksheet by putting borders round sets o
10 cells. You could display printouts of this at the entrance so peopl
can find their table.

2. As names come in enter them somewhere on the sheet.

3. If the names are to be grouped you can select them and put a borde
round and/or change the cell colour. Keep them selected and drag th
whole lot to one of your tables.

4. You can use this method to move names around afterwards i
necessary
 
BrianB said:
If you cannot find an automatic method, something I use is the ability
to click on the border of a selected cell or range and drag the whole
range and contents to somewhere else.

In your case the method would be :-

1. set up a table plan on a worksheet by putting borders round sets of
10 cells. You could display printouts of this at the entrance so people
can find their table.

2. As names come in enter them somewhere on the sheet.

3. If the names are to be grouped you can select them and put a border
round and/or change the cell colour. Keep them selected and drag the
whole lot to one of your tables.

4. You can use this method to move names around afterwards if
necessary.
Click to expand...


How about this.
1. Number each of your tables and each of your chairs. So table 1 has
chairs 1, 2, 3, 4 - 10 ; Table 2 has chairs 1-10

2. Then set up a column which Concatenates these which creates a
unique number for each chair Table 1 Chair 4 becomes 14 and so on

3. As each person is listed, next to their name place their table
number and seat number. Column E Table numer, Column F the seat
number, Column G the name and column D formula to concatenate the
table and seat number.

4. Use conditional formatting with a formula that if the number in
column D is duplicated, the cell turns red to warn you, you have
placed 2 people in the same seat.

5. Use Conditional Formatting to turn the table number in column E, a
different colour when all seats are full at the table.

6. Then by simply changing either the table or seat number next to the
name, you can move the seating around. You will be warned when tables
are full or you duplicate a seat.

7. Where people have requested to be seated togther, shade the name
cell so you know not to chnage their table or seat number.

5. Lastly set up a list for each table. Table name on the top of the
list and seat numbers to the left. The formula for the name list from
cell B2 will read =vlookup($B$1&A2,$D$1:$G$100,4,False) where B1 is
the table number, A2 is the seat number and D1 to G100 is the list of
names with their table and seat numbers and the Concatenated number.
 
Back
Top