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?

random pages
 

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 .com,
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?