dslreports logo
site
 
    All Forums Hot Topics Gallery
spc

spacer




how-to block ads


Search Topic:
uniqs
239
share rss forum feed

nickstoy

join:2001-02-03
Saint-Lazare, QC
Reviews:
·TekSavvy Cable

[Excel] Creating a Pivot Graph, data pulled from several tabs

Greetings all

I want to create a pivot graph in Excel 2010.

The graph needs to pull data from 4 tabs that are updated weekly. All of those tabs contain the same data, but not displayed in the same order.

My solution was to create a 5th tab that populates itself with data from the 4 others. All I really need is data from 10 columns. I was thinking of using a VLOOKUP, but since the columns are not in the same sequence,not filtered, and modified each week, I don't think it's an option.

I'm including a dummy file to play around with, as the real one contains sensible data.

Thanks!