Calgarypuck Forums - The Unofficial Calgary Flames Fan Community - View Single Post

Teh_Bandwagoner · 07-27-2009, 12:23 PM

Yeah hard to say without seeing. Sounds like you're asking about how to setup pivot tables IMO.

Pivot tables allow you to select a variable from a dropdown menu in a cell, which can then repopulate a table with any other set of variables you choose. It's basically a dynamic excel table.

PM me if this is what you need and I can probably step you through that in more detail.

Edit: OR Microsoft has their own tutorial on pivot tables here! See if that's what you need.
http://office.microsoft.com/training...RC010136191033

07-27-2009, 12:23 PM	#5
Teh_Bandwagoner First Line Centre Join Date: Apr 2006 Location: The wagon's name is "Gaudreau" Exp:	Yeah hard to say without seeing. Sounds like you're asking about how to setup pivot tables IMO. Pivot tables allow you to select a variable from a dropdown menu in a cell, which can then repopulate a table with any other set of variables you choose. It's basically a dynamic excel table. PM me if this is what you need and I can probably step you through that in more detail. Edit: OR Microsoft has their own tutorial on pivot tables here! See if that's what you need. http://office.microsoft.com/training...RC010136191033 __________________ Last edited by Teh_Bandwagoner; 07-27-2009 at 12:29 PM.