+ Reply to Thread
Results 1 to 2 of 2

Fetching Pivots to specific cell

  1. #1
    Registered User
    Join Date
    12-16-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    50

    Fetching Pivots to specific cell

    Hey guys and girls! =)

    Got a little bit of a problem here, like everybody else!

    I have a ton of data coming into excel. I'm making a Pivot table of this.
    From this tables everything goes to another sheet for a specific month. Right now January only.

    The data will contain several of months later on in the future.
    Is there any kind of solution to where I can set the pivot to see the february date and insert into the right cells?

    Excel01-file contains the Pivot table setup.
    Excel02-file is the place where the pivot should insert the data specific to each month taken out from the data file in excel03_data-file.

    Does anyone see my problem and have a solution for it?

    Thanks in advance!

    // Martin
    Attached Images Attached Images

  2. #2
    Registered User
    Join Date
    12-16-2012
    Location
    Sweden
    MS-Off Ver
    Excel 2010
    Posts
    50

    Re: Fetching Pivots to specific cell

    I thought while sitting here trying my best out..

    If I include date in my pivot. Shouldn't it be possible to have an if-statement telling the cell to only show data within to specific dates?
    Last edited by taken; 02-24-2014 at 01:19 PM.

+ 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. [SOLVED] Fetching data based on cell value
    By gan_xl in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-11-2013, 05:38 AM
  2. Fetching data based on cell value
    By gan_xl in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2013, 04:37 AM
  3. [SOLVED] Insert Slicer for Pivots Only or can we use it for Charts without Pivots?
    By eldwardo in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-02-2013, 04:27 AM
  4. Dynamic Data fetching from DB and populate in a cell
    By LakshmiNarasu in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-29-2010, 07:42 AM
  5. [SOLVED] I would like to build macro's to do pivots or part of pivots
    By Todd F. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-29-2005, 11:05 AM

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