Thank you so much for your response. There is more to it. I may contact you
later.
But thank you very much for now. You must be a good programmer.
- Nyc.actuary
On Thu, Jan 16, 2014 at 8:47 AM, Anoop K Sharma wrote:
> Use loop... like
> for each chkBox in thisworkbook.worksheet
>'your code
;
>
>
> 2) Percent of units occupied:
>
> Select Range D11: G19
>
> Right lick the mouse to select Field Settingsā¦
>
> In the Show data as (PivotTable Field window) select % of Column and click
> OK (View of Attachment Sheet2)
>
>
> 2013/5/2 Dvd Yid
>
>>
xlstime:
I would like to respectfully thank you for correctly answering this
question.
- nyc.actuary
On Tue, Apr 30, 2013 at 10:46 PM, xlstime wrote:
> Hi Nyc,
>
> 1st filed it is not possible in pivot table (need to create another column
> and put condition then add in pivot table )
> 2nd f