variable file name lookup

  1. K

    Variable file name and looping macro to insert formula

    Hi I would like to create a change event macro that will update multiple formulas that pull data from various tabs on a file. The tabs are named with a single date. So ideally when a certain master cell (Allocation!H2) is updated to the current date the macro will be prompted to update the...
  2. J

    HELP! Solver VBA variable range loop

    Hi Guys, Would be really greatful for a solution. I am trying to write a VBA loop for solver function where the Target and constraints will depend on the futures contract chosen in a cell but am just not being able to make it work. Here is the macro, that i came up with. Here, i have kept the...
  3. T

    Excel VBA Help with Declaring Variables

    I am getting an object required error for some of my declared variables not sure how to correct it. I probably have more errors than this too if anyone can help me out it would be appreciated I don't have much experience in VBA. Dim i As Integer, j As Integer, k As Integer Dim x As Range, y As...
  4. F

    variable file reference

    Hi There, I'm using the following fomula (note i didn't provide full path here - for obvious reasons - but i do use it in the real copy) <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p>...
  5. M

    SUMIF data with variable file name possible?

    My research on this topic here isn't giving me any good leads but... I thought I'd ask the wise brain-pool anyway. I have a report that I am currently running based on raw data downloaded daily. I need to be able to compare data from any download date to any other download date. This is simple...

Watch MrExcel Video

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