Results 1 to 4 of 4
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Possible to auto-create sheet dinamicly... (2000 s

    In sheet GRUPPO are column A and B with data.
    In sheet STAT_L0953 a sheet similar pivot
    In sheet L0953 data linked with formula in STAT_L0953

    My problem is to create the sheet STAT_L0953 dinamicly with value in column A and B sheet GRUPPO, because the column A and B of sheet GRUPPO are updated from other macro, and not are fixed but variable...
    Naturally after creation with column A and B of sheet GRUPPO use the same formula in column P and formula in line 46 and 47 of sheet STAT_L0953

    Note: not consider the internal of sheet STAT_L0953 i use other macro to fill data in range D3:O45

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Possible to auto-create sheet dinamicly... (2000 s

    You can create a pivot table based on the data in L0953 (Dati | Rapporto tabella pivot e grafico pivot...).
    You can refresh a pivot table when the source data change.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Possible to auto-create sheet dinamicly... (20

    OK for pivot... maked (see new file)
    But during the creation of pivot is possible o insert percentace for each value in column N respect the grantotal N48, and for each value in line 48 in range B49:M49 respect the grantotal N48...

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Possible to auto-create sheet dinamicly... (20

    Excel does not offer this feature. I'd leave it as it is if I were you. If you really need it, you can write a macro that adds the percentages (as values or as formulas).

Posting Permissions

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