LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 16
Default How to re-use data from a pivot table...

Hello, as someone in this nice group suggested, I've created a pivot
taking data from a sheet in the same file.
Columns of my data a day (1,2,3...), bank account, name, company,
amount of money, reason.

The wonderful pivot shows everything in a wonderful way, having sum of
amounts of money ordered in any way I like...the things that I need it
to be able to use a cell of the pivot on another sheet.

An example: in the pivot I have a cell with the total expences of
march regarding Mr. Brown.

Now, I would like to create a simple sheet where I can re-use that
total for other reasons but that is not possible, for me, because the
link doesn't work (the cell position in a pivot change according to
the filtered data) and because I don't know how to get a formula for
that total.

Any help or solution? Maybe it is something very easy for you but I'm
worried because I need to re-use those data.

Thank you,
Ataru

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exclude pivot table data from pivot chart? coal_miner Charts and Charting in Excel 4 April 17th 07 07:11 AM
Pivot Table - Use Other Pivot Table as Data Source WCM Excel Discussion (Misc queries) 1 January 25th 07 06:39 PM
How do I sort pivot table data outside a pivot table Michael Excel Worksheet Functions 1 January 4th 07 02:45 PM
Data Area of Pivot Table and Pivot Charts Missy Charts and Charting in Excel 2 April 13th 06 12:51 AM
Excel Pivot Table Plugin? (crosstab to data table) HoMoon115 Excel Discussion (Misc queries) 0 February 22nd 06 08:20 PM


All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"