Chantelle has attended:
Excel Advanced course
Access Introduction course
Excel Pivot Table
Hi there,
I am have looked through my notes from my course regarding pivot tables but unable to find the answer.
I am currently trying to create a table that can be manipulated to your requirements, which I thought would be a pivot table.
The table will need to read from different sheets and excel rows, to form this front sheet which can show data that is manipulated by the person.
Am I heading down the right path or do I need to look at filtering?
Thanks
Chantelle
RE: Excel Pivot Table
Hi Chantelle, thanks for your query. You're on the right track but you need a "middle" table, with a series of clear field headings, that collects (or links directly to) the individual sheets and cells that you're interested in. You'd run the Pivot Table off that.
Hope this helps,
Anthony
RE: Excel Pivot Table
Thanks Anthony,
Unfortuately I am still stuck because of the nature of the file.
I am trying to display sites, against month against a catergory (which there are quite a few catergories).
Where should I start?
RE: Excel Pivot Table
Hi Chantelle. We'd need to look at the file to help you out on this one I'm afraid. The most important thing is to get the data into one main table with simple headings along the top. Once you've that, the Pivot Table functionality should allow you to summarise and analyse.
Anthony
