I've been trying to do this using vlookup but have not been able to...

If anyone could help at all, it'd be greatly greatly appreciated!

I have a workbook with multiple wkshts.
Each wksht is titled as an invidual class and has the corresponding
information in it such as attendees, professor, location, date

I want to have 2 summary pages. 1 that organizes the data in the previous
wkshts by class and 1 that organizes the data by location (they are repeated
so there are multiple instances of Houston etc.).


I want these summary pages to be automatic so I wont have to manually type
in the data each time and only have to input data into the separate class
wkshts.


There are 9 tabs each labeled with the title of the class.
A name does appear on more than one sheet.
All the sheets do have the same layout.

The title of the class is located in A1.
The location of the class is located in A4:A10.

The data I want to return is located on to the left of the location. For
example,
A4 is Houston.
Then B4,C4,D4 all have the information including professor, date,
attendance% etc.

It is from B4 to J4 on each wksht.

Thanks guys!

Hi
Rethink your design.
Have ONE database (one sheet) with all the information in it, so that
column 1 of the table would be Class (rather than having a separate
sheet for each class)
Now your problem is to extract data from this table to produce
individual class sheets. This can be done by filtering on class and
pasting to a new sheet. Same for location.
You can also get all stats on your data and represent it in different
ways using a pivot table (stats broken down by class or location for
example).

regards
Paul

On Jul 2, 10:07*pm, Dahliahlu
wrote:
I've been trying to do this using vlookup but have not been able to...

If anyone could help at all, it'd be greatly greatly appreciated!

I have a workbook with multiple wkshts.
Each wksht is titled as an invidual class and has the corresponding
information in it such as attendees, professor, location, date

I want to have 2 summary pages. 1 that organizes the data in the previous
wkshts by class and 1 that organizes the data by location (they are repeated
so there are multiple instances of Houston etc.).

I want these summary pages to be automatic so I wont have to manually type
in the data each time and only have to input data into the separate class
wkshts.

There are 9 tabs each labeled with the title of the class.
A name does appear on more than one sheet.
All the sheets do have the same layout.

The title of the class is located in A1.
The location of the class is located in A4:A10.

The data I want to return is located on to the left of the location. For
example,
A4 is Houston.
Then B4,C4,D4 all have the information including professor, date,
attendance% etc.

It is from B4 to J4 on each wksht.

Thanks guys!

Hi

I do have that in a sense.
I have the class summary sheet which is all the info in 1 sheet.
I have made a pivot table before to re arrange it by location but is there a
way to have it update automatically?


Thanks!

" wrote:

Hi
Rethink your design.
Have ONE database (one sheet) with all the information in it, so that
column 1 of the table would be Class (rather than having a separate
sheet for each class)
Now your problem is to extract data from this table to produce
individual class sheets. This can be done by filtering on class and
pasting to a new sheet. Same for location.
You can also get all stats on your data and represent it in different
ways using a pivot table (stats broken down by class or location for
example).

regards
Paul

On Jul 2, 10:07 pm, Dahliahlu
wrote:
I've been trying to do this using vlookup but have not been able to...

If anyone could help at all, it'd be greatly greatly appreciated!

I have a workbook with multiple wkshts.
Each wksht is titled as an invidual class and has the corresponding
information in it such as attendees, professor, location, date

I want to have 2 summary pages. 1 that organizes the data in the previous
wkshts by class and 1 that organizes the data by location (they are repeated
so there are multiple instances of Houston etc.).

I want these summary pages to be automatic so I wont have to manually type
in the data each time and only have to input data into the separate class
wkshts.

There are 9 tabs each labeled with the title of the class.
A name does appear on more than one sheet.
All the sheets do have the same layout.

The title of the class is located in A1.
The location of the class is located in A4:A10.

The data I want to return is located on to the left of the location. For
example,
A4 is Houston.
Then B4,C4,D4 all have the information including professor, date,
attendance% etc.

It is from B4 to J4 on each wksht.

Thanks guys!