+ Reply to Thread
Results 1 to 3 of 3

Help to prepare dynamic table in excel

  1. #1
    Registered User
    Join Date
    09-25-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Help to prepare dynamic table in excel

    Hi there,
    dummy.xlsx
    PFA refer to sheet 1 in which i have the data and i want my data as per given in sheet 2. please help me do this.

    Thanks in advance !

  2. #2
    Forum Contributor
    Join Date
    07-10-2012
    Location
    Bangladesh
    MS-Off Ver
    Excel 2007
    Posts
    129

    Re: Help to prepare dynamic table in excel

    use ctrl+d between week intervals and then run a pivot
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-25-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Help to prepare dynamic table in excel

    Thanks for the help vijay, but my requirement is i need to compare only two weeks at the time and if i change week no for current and previous it should ideally get changed automatically.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Make a table "flatten" prepare to insert in database
    By nancy38 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2013, 01:26 PM
  2. Need Help to Prepare PPT from Excel Raw File through VBA???
    By Rajeshkumar R in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-29-2012, 10:26 PM
  3. Dynamic table formula for sorting data to another table dynamic
    By 650dozer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-21-2012, 07:22 PM
  4. Replies: 5
    Last Post: 10-01-2009, 11:48 AM
  5. Prepare Spreadsheet for Import into Access Table
    By j.t.w@juno.com in forum Excel General
    Replies: 4
    Last Post: 02-01-2005, 06:06 AM

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