Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Greg
 
Posts: n/a
Default Blank Cells in Pivot Tables

It's been mentioned here about filling in blank cells automatically in a
list of data.

Can this be done within a pivot table automatically?

I create pivot tables but the row headings are grouped so that some of the
items have blank cells next to them. This is frustrating when you want to
run a pivot table over the top of the original as it considers these cells
blank.

As a result you have to copy and paste the row headings into the blank cells
and this can be time consuming if you have many lines of data.

Can it be done automatically within the pivot table?

Can pivot tables be automatically run over the top of another with the blank
cells considered automatically to have data within them (i.e. the blank
cells created by the grouping of items within row headers?)

Thanks in advance for any comments,

Greg


  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

I'm not sure what automatic means here, but if you're creating the same
pivottable (from different data), maybe you could record a macro when you do it
manually.

You could continue recording when you convert to values and fill those blank
cells.

And continue recording when you create the second pivottable.

Then whenever you need to recreate this, you just rerun that macro.

Greg wrote:

It's been mentioned here about filling in blank cells automatically in a
list of data.

Can this be done within a pivot table automatically?

I create pivot tables but the row headings are grouped so that some of the
items have blank cells next to them. This is frustrating when you want to
run a pivot table over the top of the original as it considers these cells
blank.

As a result you have to copy and paste the row headings into the blank cells
and this can be time consuming if you have many lines of data.

Can it be done automatically within the pivot table?

Can pivot tables be automatically run over the top of another with the blank
cells considered automatically to have data within them (i.e. the blank
cells created by the grouping of items within row headers?)

Thanks in advance for any comments,

Greg


--

Dave Peterson
Reply
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
Macro for Pivot Tables Thomas Excel Discussion (Misc queries) 1 March 15th 05 02:03 AM
Excel 97 - Selecting multiple cells from 2 different Pivot Tables jjones_HAB Excel Discussion (Misc queries) 0 March 1st 05 01:01 PM
Product Function in Pivot Tables from Multiple Consolidation Range bbishop222 Excel Worksheet Functions 0 February 22nd 05 05:55 PM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 02:34 AM
Counting blank cells in Pivot Table Andy Joyce Excel Worksheet Functions 1 December 21st 04 11:05 PM


All times are GMT +1. The time now is 11:13 PM.

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

About Us

"It's about Microsoft Excel"