Results 1 to 4 of 4

Thread: Help with VBA

  1. #1
    VBAX Newbie
    Dec 2021

    Help with VBA

    Each day, an input file 'DB_PX_LAST' will be received, which contains a snapshot of historical prices provided by the data vendor.
    Build a macro that picks data from these input files, and populates the prices from 10th to 15th Nov into their respective cells, in the 'Prices Database' workbook.

    US0003M and SOFRRATE are Rates being available on T-1 basis.
    For example on 10th Nov, Rates as of 9th Nov will be populated into the 'Prices Database' workbook.

    Based on the information available, please make the necessary assumptions for holiday handling.
    Elaborate clearly the assumptions made, and your thought process behind.

    Whenever possible, incorporate sanity checks and controls to the macro, helping users to detect potential issues or errors for this process.
    Attached Files Attached Files
    Last edited by namrfigk; 12-02-2021 at 01:28 AM.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Apr 2005
    Looks an awful lot like this is some course work, which you should be doing yourself.

    If you have tried something and are having a problem with a specific thing, detail what that is and we can look at that.
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Knowledge Base Approver VBAX Wizard
    Oct 2005
    Surrey UK
    Splattered everywhere:
    VBA help | Excel Forums - Become Awesome in Excel
    VBA help - Excel VBA / Macros - OzGrid Free Excel/VBA Help Forum
    VBA help | General Excel Questions & Answers | Excel Forum • My Online Training Hub
    VBA help | MrExcel Message Board
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  4. #4
    Moderator VBAX Guru Aussiebear's Avatar
    Dec 2005
    IMO, the Op's request does seem to be written as if an educator was constructing the query.
    Remember To Do the Following....
    Use tags when posting code to the thread,
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts