Hi,

Excel XP (version 10)

Could anyone tell me if this is possible, and if so, is it going to be
easy or a pain in the neck.

I am a teacher trying to make life a little easier for myself. I am
trying to make a seating plan a little more automatic.

I have a workbook with 2 sheets in it.

The first sheet has a list of pupils names.

The second sheet has a been 'designed' using boarders to represent the
desk layout in my classroom. In each desk I have a number (from 1 to
30).

At the moment I copy and past the pupils' names from sheet 1 to the
appropriate place in sheet 2 - where I want them to sit.

It would be a lot easier if I could add a column next to the pupil's
name in sheet 1 where I could just type the seat number (1 to 30) and
the pupil's name could be copied to the appropriate cell in sheet2.

Any ideas would be most appreciated.

Thanks