formulas across workbooks

  1. G

    Using Drop-Down Selections To Replace Worksheet Names in Formulas

    Using EXCEL 2007, Windows Vista (32). I want to be able to place a reference in a formula to a cell containing a drop- down list so that the name in the drop-down list will replace the name (on another worksheet tab) to enable me to call up the data in the cell in the formula. Say I have...
  2. E

    Help importing, updating, and automating excel sheets

    Hi everyone! I am having some trouble setting up a master excel sheet that can automatically pull data from a folder when it is opened. I currently work with an inefficient data management system in which I save a file as a text (which I can't change), I then re-save it as an excel sheet...
    • ellipsis
    • Thread
    • excel formulas across workbooks import data macros visual basic
    • Replies: 0
    • Forum: Excel Questions
  3. M

    Vlookup with variables

    Here's the issue. Each day I create a spreadsheet we use for our build plan. While creating this build plan I VLookup back to the previous day's build plan spreadsheet to pull statuses. This forces me to run the Vlookup function each time I create the spreadsheet. I have a template...
  4. F

    Use "master formula" in multiple workbooks?

    I have multiple workbooks (.xls files) saved in a folder that each represent a seperate "recipe" or machine setup. Each workbook may contain several worksheets that are revisions of the given recipe. The format of the worksheets is as follows (roughly): Columns A-D: User inputs Columns E-G...
    • feetimo
    • Thread
    • formula formulas across workbooks master formula
    • Replies: 12
    • Forum: Excel Questions

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