First, I've attached an example of the *three* pages that I am trying to
get working.

The first page is the data, sorted by year then by product. This data
is always in ascending yearly order. Page 2 and 3 are displays and
graphs of each individual product.

I want to setup Excel to automatically fill the tables on page 2 and 3
based on what data is in the columns in page 1. VLOOKUP has some of the
functionality to accomplish this. So, for example, the function would
look up the product and bring back all associated rows and columns.

Is there any combination of functions that can perform this type of
behavior?
Thanks!


+-------------------------------------------------------------------+
|Filename: demo.jpg |
|Download: http://www.excelforum.com/attachment.php?postid=4172 |
+-------------------------------------------------------------------+

--
cswale
------------------------------------------------------------------------
cswale's Profile: http://www.excelforum.com/member.php...o&userid=29991
View this thread: http://www.excelforum.com/showthread...hreadid=497271

The answer is using Pivot Table,

Have a look at the enclosed file there is no macro just the use of
pivot table.
Francoise;)


+-------------------------------------------------------------------+
|Filename: UsingPivotTableandChart.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4275 |
+-------------------------------------------------------------------+

--
sunnyland
------------------------------------------------------------------------
sunnyland's Profile: http://www.excelforum.com/member.php...o&userid=30871
View this thread: http://www.excelforum.com/showthread...hreadid=497271