variable reference

  1. T

    Setting an using a variable to a closed excel workbook

    First time poster here! I've searched and looked but cannot find a way to get this to work. I need to reference a value from a closed excel file without using the morefunc addin or vba. One way I can make it work but it's not ideal is hardcoding the string path for every cell Example...
  2. R

    Creating an external reference with a variable cell

    Hi all, First off, I haven't been using Excel regularly since college so I'm pretty rusty on formulas. I'm wondering if there's any way to put a variable for a cell address in an external reference formula. Basically, I'm creating an abridged report of customer data that takes a single...
  3. D

    external workbook data link with variable workbook reference

    I have a number or workbooks containing weekly status reports..I would like to aggregate them into a single workbook for mgmt access... Given: all workbooks (status reports) are formatted identical; all worksheets (a week status report is contained in a worksheet with the week in the format of...

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