+ Reply to Thread
Results 1 to 2 of 2

vba code for create new sheet and pivot tables

  1. #1
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    vba code for create new sheet and pivot tables

    Hi Any experts can help on this task.urgently

    I have rawdata to create worksheet with name of unique value week from(I:I) with 10 pivot tables in week sheets.

    consider columns for create pivot data fields (A:K) till weeks ends i want create 10 pivot table to every week till end of week nos.

    example : If sheet (week-1 10 pivot table in sheet),week-2 10 pivot table in sheets),week-3 10 pivot table in sheet)

    10 pivot tables are different dimensions report

    I know its very complicated if its done its really appreciated

    i have uploaded two sheet input and output .....

    Mean while I am waiting for brilliant code....
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    07-21-2011
    Location
    Bangalore,India
    MS-Off Ver
    Excel 2007,2010,2016
    Posts
    695

    Re: vba code for create new sheet and pivot tables

    Instead of working on macro better can it make the task through excel formulas? like If i click week nos its show result depends upon criteria on as value of pivot table?

+ Reply to Thread

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