Results 1 to 2 of 2

Multiple tables to one worksheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    06-12-2014
    Location
    India
    MS-Off Ver
    2010
    Posts
    153

    Multiple tables to one worksheet

    Heeello !!! All,

    Need you help with the following,

    Attached Excel - I have four sheets with same column headers which needs to be pivoted as one

    What I am lookin for is, can we add worksheet name as filters in pivot? is this possible? so everytime i change the filter to different sheet, I have values from different sheet displayed
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] How to view data from multiple tables in one worksheet in another worksheet?
    By TechnoFonic in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 11-22-2013, 03:40 PM
  2. Combining Multiple Tables in one worksheet into One Table
    By rhiminee in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-02-2013, 11:06 AM
  3. Sorting multiple tables on one worksheet
    By Snowstorm in forum Excel General
    Replies: 3
    Last Post: 12-22-2010, 01:32 PM
  4. Adding multiple rows in different tables of the same worksheet
    By JMarchante in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2010, 07:42 AM
  5. multiple tables on the same excell worksheet
    By BigD in forum Excel General
    Replies: 2
    Last Post: 05-07-2006, 12:10 PM

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