• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. J

    Variable latest file name referencing with formula or vba code

    Sure, much appreciated. I had a feeling any solution would involve some code (which I'm terrible at).
  2. J

    Variable latest file name referencing with formula or vba code

    Although that IS useful to me, it doesn't really answer my original question. What I'm trying to do, if possible, is this; Say I have a file names "DATA-SEPTEMBER.xlsx" and " =VLOOKUP(A16,'C:Documents and SettingsfolderDATA-SEPTEMBER.xlsx'!$A$7:$BF$32,58,FALSE)" Next month, that same...
  3. J

    Variable latest file name referencing with formula or vba code

    I am currently making a dashboard that will be drawing data from a variety of different workbooks through the company. For a particular section, I need to reference reports for the current month, which are saved in a "XXXXX-October.xlsx" format. Since multiple people work on these, it's not...
Back
Top