across workbooks

  1. H

    Dependent Data Validation across workbooks. Source data frequently sorted and manipulated

    Image of (2) workbooks: https://drive.google.com/file/d/0B7BUBKK8yXCUV2c3V2NSMTlNLVE/view?usp=sharing I want to be able to compile parts data in one workbook. "MASTER PARTS LIST.xlsx" https://drive.google.com/file/d/0B7BUBKK8yXCUMnFBZDV1alFNQ2c/view?usp=sharing Then I want to create a list of...
    • highlifesipper
    • Thread
    • across workbooks dependent data validation dynamic named ranges movable ranges
    • Replies: 0
    • Forum: Excel Questions
  2. S

    Macro to pull data from another workbook

    OK so here's what i would like to do, and google just hurts my brain so I am going here for the experts, I need to press a button, have excel go into another workbook, which I will update each day with new entries, and pull out the data from that work book and paste it into my current workbook...
  3. S

    find matching values across workbooks

    Hi there, I have 34 workbooks each with a column of numbers in, some numbers are the same & some are different (& other columns with different info in them) . I would like to find any numbers that appear in ALL the workbooks, and get a list of those numbers. (see below example - this would be...

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
Back
Top