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...

Some videos you may like

This Week's Hot Topics