1 pivotable, 2 different data source

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hello All,

I was wondering if anyone would know the answer to this
question.

Q. You have two sheets with identical columns and formula
on the source sheet. Another sheet will contain one pivot
table that will be link to both sheets. You need some type
of dropdown control to change the datasource. how would
you implement this?

example:

Sheet1 has:
Name Value
Mike 1
Jack 2

Sheet2 has:
Name value
Mike 3
Jack 5
Kim 7

Sheet3 (the pivotable) has:
A dropdown to make a selection for sheet1 or sheet2.

Name Value
Mike 1
Jack 2

if someone figure this out, you are the man or woman! thnx
in advance!
 
Mike,

I'm not sure if that's possible in a pivot table, the
easier way to do it would be to have the sheet2 data
copied over to sheet 1. For the sake of keeping the sheet
clean, you could simply color the data from sheet2 white
and protect the sheet, that way, users couldn't
accidentally type over the cells and the pivot table
could then do what you're asking much easier.
HTH
Kevin M
 
Back
Top