variable file name lookup

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

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

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

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

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