Results 1 to 16 of 16

VBA Pivot Table with Fixed Rows

Threaded View

excelnewbie80 VBA Pivot Table with Fixed... 05-28-2012, 05:09 AM
arlu1201 Re: VBA Pivot Table with... 05-28-2012, 05:15 AM
excelnewbie80 Re: VBA Pivot Table with... 05-28-2012, 05:21 AM
arlu1201 Re: VBA Pivot Table with... 05-28-2012, 05:25 AM
excelnewbie80 Re: VBA Pivot Table with... 05-28-2012, 05:29 AM
arlu1201 Re: VBA Pivot Table with... 05-28-2012, 05:36 AM
excelnewbie80 Re: VBA Pivot Table with... 05-28-2012, 08:47 AM
JosephP Re: VBA Pivot Table with... 05-28-2012, 07:14 AM
Pichingualas Re: VBA Pivot Table with... 05-28-2012, 08:52 AM
arlu1201 Re: VBA Pivot Table with... 05-28-2012, 08:53 AM
JosephP Re: VBA Pivot Table with... 05-28-2012, 09:00 AM
taccat Re: VBA Pivot Table with... 04-07-2013, 08:50 PM
excelnewbie80 Re: VBA Pivot Table with... 05-28-2012, 09:02 AM
JosephP Re: VBA Pivot Table with... 04-08-2013, 01:37 AM
taccat Re: VBA Pivot Table with... 04-08-2013, 08:44 PM
JosephP Re: VBA Pivot Table with... 04-09-2013, 10:02 AM
  1. #1
    Registered User
    Join Date
    05-28-2012
    Location
    US
    MS-Off Ver
    Excel 2007
    Posts
    19

    Question VBA Pivot Table with Fixed Rows

    Hi,

    This is my first post. I have been stuck with this for some time. I am trying to create a pivot table with fixed rows but it was not possible. The reason for doing this is that sometimes I get data without certain row labels and I do not want the rows to go missing.

    Data (monday)
    Apple---1
    Apple---1
    Pear----1

    Data (tuesday)
    Apple---1
    Orange-1
    Pear----1


    The pivot table I want to achieve ( for monday):

    Fruit----Count
    Apple-----2
    Pear -----1
    Orange----0

    Even though the count for orange is 0, I want to still see it in the table. Is there any way to do this?
    Last edited by excelnewbie80; 05-28-2012 at 05:20 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1