Create List from Pivot Table

Hi,

I'm trying to create what is essentially a report card for our staff. I have all the data in a pivot table and then I am using 'GETPIVOTDATA's in the report template to extract the information, linking the sheets via a cell that contains the staff members name. Easy enough. However for reasons of efficiency and practicality I would like to be able to select the names from a drop down list on the sheet rather than having to type it in manually or maintaining a separate sheet for everyone. The operators will change from month to month and there are approximately 90 staff at any given point in time that will need to be reported on so it really needs to be sourced from the pivot data.

Hopefully somebody on here has done this before and will be able to help me out If you need me to make up a sample let me know.

Thanks in advance!

Originally Posted by JoeyGirl

........ If you need me to make up a sample let me know.

................

G'day JoeyGirl,

That would be great in supplying a sample.

Cheers

RC

G'day

Try this in 'Report' D8

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

Let us know if there is any problems.

Cheers

RC

G'day

See this link with an example attached and highlighted in yellow (Formula only)

http://www.cpearson.com/EXCEL/noblanks.htm

Cheers

RC