I have three sheets(TABS) under on excel sheet and I want to create a pivot
table report from these 3 different sheets.
I have three sheets(TABS) under on excel sheet and I want to create a pivot
table report from these 3 different sheets.
Hi
Select "muliple consolitation ranges" as datasource in the wizard part 1.
But you will not get this flexible **** table you're used to, the
consolidated ones are awkward and ugly. Consider to gather the data in one
place instead.
HTH. Best wishes Harald
"SANKUL" <[email protected]> skrev i melding
news:[email protected]...
> I have three sheets(TABS) under on excel sheet and I want to create a
pivot
> table report from these 3 different sheets.
Try using MSQuery and a union select to put all the data together. Select
data, import external data, new database query, select the excel file option
and uncheck the Use Query Wizard option. Select the file you're working in
and select sheet1, add, double click the * on the table and all your data
will be displayed. Select the SQL button and your Select statement will be
displayed. Create similar statements for each table (you can use notepad to
store these) and put a Union All between each select statement. Return the
data to excel and click on the create pivot table option. When data is
changed you'll need to refresh the pivot table.
Gary
"SANKUL" wrote:
> I have three sheets(TABS) under on excel sheet and I want to create a pivot
> table report from these 3 different sheets.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks