Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Report - HELP!
Does anyone know who to make a field label repeat when I copy from a Pivot
Table Report. For Example: Pivot Table Report ----------------------------------------------------- Department Account # Amount 4321834 238 $68.50 250 $18.50 260 $22.50 4321855 355 $68.50 250 $18.50 260 $22.50 New Summary List from Pivot Table Report is what I need to get --------------------------------------------------------------------------- 4321834 238 $68.50 4321834 250 $18.50 4321834 260 $22.50 4321855 355 $68.50 4321855 250 $18.50 4321855 260 $22.50 -- Texas Wannano |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Report - HELP!
To populate it down in the copy, try the methods described
in either of these 2 excellent pages by: David McRitchie: http://www.mvps.org/dmcritchie/excel/fillempt.htm Fill in the Empty Cells Debra Dalgleish: http://www.contextures.com/xlDataEntry02.html Excel -- Data Entry -- Fill Blank Cells -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Wannano" wrote: Does anyone know who to make a field label repeat when I copy from a Pivot Table Report. For Example: Pivot Table Report ----------------------------------------------------- Department Account # Amount 4321834 238 $68.50 250 $18.50 260 $22.50 4321855 355 $68.50 250 $18.50 260 $22.50 New Summary List from Pivot Table Report is what I need to get --------------------------------------------------------------------------- 4321834 238 $68.50 4321834 250 $18.50 4321834 260 $22.50 4321855 355 $68.50 4321855 250 $18.50 4321855 260 $22.50 -- Texas Wannano |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Report - HELP!
MAX, you're my hero...THANKS!!!
-- Texas Wannano "Max" wrote: To populate it down in the copy, try the methods described in either of these 2 excellent pages by: David McRitchie: http://www.mvps.org/dmcritchie/excel/fillempt.htm Fill in the Empty Cells Debra Dalgleish: http://www.contextures.com/xlDataEntry02.html Excel -- Data Entry -- Fill Blank Cells -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Wannano" wrote: Does anyone know who to make a field label repeat when I copy from a Pivot Table Report. For Example: Pivot Table Report ----------------------------------------------------- Department Account # Amount 4321834 238 $68.50 250 $18.50 260 $22.50 4321855 355 $68.50 250 $18.50 260 $22.50 New Summary List from Pivot Table Report is what I need to get --------------------------------------------------------------------------- 4321834 238 $68.50 4321834 250 $18.50 4321834 260 $22.50 4321855 355 $68.50 4321855 250 $18.50 4321855 260 $22.50 -- Texas Wannano |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table Report - HELP!
You're welcome !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Wannano" wrote in message ... MAX, you're my hero...THANKS!!! -- Texas Wannano |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add Sales Goals to Sales Report in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot Table external XLS file source change and GETPIVOTDATA refresh | Excel Discussion (Misc queries) | |||
pivot table format report - setting default | Excel Discussion (Misc queries) | |||
Pivot Table - report product that have sales above defined level | Excel Discussion (Misc queries) | |||
Pivot Table Problems | Excel Discussion (Misc queries) |