Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #108299

Re: New sheets from a Pivot Table

Show all headers | View raw

Hi Ty,

Am Thu, 10 Dec 2015 19:59:56 -0800 (PST) schrieb Ty:

> One special sheet with numbers of what you just completed for me along with: 
> -Display will change based on the filter and number from what was solved with color counting 
> -Display the label of the column in A4 or somewhere 
> -Display the row names(xyz_01) 
> -Display the numbers from the color counting(bottom on row 200-205? column K-S?) next to the row name(xyz_01) 
> 
> Sheet for each color: 
> -Display just the label of the column 
> -Display just numbers of what was solved with the color counting 
> -Like a snapshot after the filter is set 

can you filter your table by color and copy & paste the filtered range?
If not, please provide your workbook with an example of an expected new
sheet.


Regards
Claus B.
-- 
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

New sheets from a Pivot Table Ty <tyrone_bak@yahoo.com> - 2015-12-10 19:59 -0800
  Re: New sheets from a Pivot Table Claus Busch <claus_busch@t-online.de> - 2015-12-11 09:34 +0100
    Re: New sheets from a Pivot Table Ty <tyrone_bak@yahoo.com> - 2015-12-11 18:15 -0800
    Re: New sheets from a Pivot Table Ty <tyrone_bak@yahoo.com> - 2015-12-11 18:17 -0800

csiph-web