LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 8
Default Seating Chart

Hi,

I want to make a seating chart report for my student's finals testing.

I have an Excel spreadsheet with each student's name, their room number, row
number, seat number.

I want to make a chart that is a visual aid to where they sit. So I don't
jsut want a table listing of names and rows, I want it to come out in the
rows and in the right order. It doesn't have to be spectacular, but it should
be a visual aid.

For example:

------------------------------ROOM 201

ROW 1------------ROW 2------------- ROW 3--------------- ROW 4

Jack Frost----- Amelia Earheart--- George Washington -----Joe Shmoe

Marie Curie----- Abe Lincoln --------Hillary Clinton -------Marc Summers

(The lines are just to hold the place so you can see where everything should
be.)

And then do the next room.

How should I do this? How should I structure my table(s)?

The hard part (I think) is getting multiple columns that each have a
different record.

Thanks!

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
seating chart marpiano New Users to Excel 2 September 10th 07 08:26 AM
Workplace Seating Chart BobbySox Excel Discussion (Misc queries) 2 November 9th 06 06:23 AM
How do I set up a wedding seating chart? gourmet New Users to Excel 7 September 14th 05 11:27 PM
formula for a seating chart M Zahedi Excel Worksheet Functions 1 March 18th 05 05:43 PM
seating chart cds Excel Worksheet Functions 6 January 15th 05 11:19 PM


All times are GMT +1. The time now is 11:54 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"