Thread: random pages

I have developed pages that randomly define a set of normal lung
function data based on gender, age and height. I have applied formulas
to this data simulate 5 classic lung function abnormalities (normal,
restrictive, obstructive, mixed and early obstructive.) Currently
the sheets that define the abnormal are named by one of the above lung
abnormalities. I would like to present data from random pages in a
work book to students and rather than have the pages named by the
abnormality be named a simulated patient name.

My questions.

Can I have the name of a sheet set to equal data from to cells (e.g. a
male first name and another last name?

Can you randomly present sheets?

Should I use a pivot table to do this?

Sheet names can reflect cell contents but only with the help of VBA.

Depending on what you mean by "present a sheet", probably yes.

Don't really see a role for a PivotTable in this but then the description of
what's what is reasonably vague.

That said, I am not sure you are using the correct program. Wouldn't
something like PowerPoint be more suited to a 'flash cards' application?

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article <1139097429.915737.189670@g14g2000cwa.googlegroups.com>,
amoss@kvcc.edu says...
> I have developed pages that randomly define a set of normal lung
> function data based on gender, age and height. I have applied formulas
> to this data simulate 5 classic lung function abnormalities (normal,
> restrictive, obstructive, mixed and early obstructive.) Currently
> the sheets that define the abnormal are named by one of the above lung
> abnormalities. I would like to present data from random pages in a
> work book to students and rather than have the pages named by the
> abnormality be named a simulated patient name.
>
> My questions.
>
> Can I have the name of a sheet set to equal data from to cells (e.g. a
> male first name and another last name?
>
> Can you randomly present sheets?
>
> Should I use a pivot table to do this?
>
>