ExcelBanter - extracting data from seating chart

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - extracting data from seating chart (https://www.excelbanter.com/excel-worksheet-functions/8551-extracting-data-seating-chart.html)

cds

extracting data from seating chart

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 he

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

(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 <atyahoo<dotcom
----
"cds" wrote in 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?

All times are GMT +1. The time now is 05:23 AM.