|
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 |
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 |
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 |
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 |
| All times are GMT +1. The time now is 09:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com