multiple data sources

  1. V

    Dependent Data Validation List from Different worksheets

    Hi! I am building a document which has several dependent variables. The document is so structured that values are pulled in different cells based on other cell values. While I have been successful in implementing most of the requirements, there is one place I am stuck at. I need to form...
  2. V

    Speeding up slicer sync w/multiple data sources

    I have an identical situation to what Mr. Jerry Sullivan has solved in this previous thread: pivot table question (and in turn, this: Pivot Table- "Master" Report Filter). I have a button that initiates the vba to sync all slicers and their respective pivot tables located in a "filtered tables"...
  3. S

    Can I use 2 data sources from the same Workbook in one formula?

    I currently have a Workbook with two datasources, "Test Cases", "Defects" (these are generated from an external system so I can't modify or combine the original datasources) The "Test Case" datasource provides information about Test Cases including the Status, The associated Defect number(s)...
  4. ericaindallas

    How do I link data in multiple sheets to 1 pivot table in the same workbook?

    I have four worksheets in the same workbook and I would like to create one pivot table that includes the data from the four worksheets. Among the four worksheets the field headers are inconsistent and some worksheets have more fields than others. I know pivot tables enough to know the field...

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top