extracting data from seating chart

[cds]

the first page of my worksheet contains a list of people, table numbers and
meals selected
page two contains the table numbers.
i want to be able to type the table number on page one and have the tables
automatically fill the people on page two
is there a way to do it without utilizing the pivot table?

[Jason Morin]

Check out VLOOKUP. You can find some examples here:

http://www.contextures.com/xlFunctions02.html

HTH
Jason
Atlanta, GA

>-----Original Message-----
>the first page of my worksheet contains a list of people,
table numbers and
>meals selected
>page two contains the table numbers.
>i want to be able to type the table number on page one
and have the tables
>automatically fill the people on page two
>is there a way to do it without utilizing the pivot table?
>.
>

[Max]

See one response at your next post
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
cds <[email protected]> wrote in message
news:[email protected]...
> the first page of my worksheet contains a list of people, table numbers
and
> meals selected
> page two contains the table numbers.
> i want to be able to type the table number on page one and have the tables
> automatically fill the people on page two
> is there a way to do it without utilizing the pivot table?

[Max]

(Re-sent, apologies for the unintentioned advance dating)

See one response at your next post
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <at>yahoo<dot>com
----
"cds" <[email protected]> wrote in message
news:[email protected]...
> the first page of my worksheet contains a list of people, table numbers
and
> meals selected
> page two contains the table numbers.
> i want to be able to type the table number on page one and have the tables
> automatically fill the people on page two
> is there a way to do it without utilizing the pivot table?