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

VBA help

N

namrfigk

New Member
Per forum rules, you are required to include links to and cross-posts you have made on the same topic.
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.
 
namrfigk
Please reread Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
Are You sure that anyone else could get clear .. some kind of idea - what would You need?
HInt: A sample Excel-file that could give some ideas for others.
Ps. You seems to ask VBA Macro, instead Ask an Excel Question.
Ps 2. Your thread's title should be something else as written in Forum Rules.
 
Cross posted at https://www.vbaexpress.com/forum/showthread.php?69406-Help-with-VBA

VBA help - OzGrid Free Excel/VBA Help Forum

MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this questionEach day, an input file 'DB_PX_LAST' will be received, which contains a snapshot of…
www.ozgrid.com www.ozgrid.com
www.mrexcel.com

VBA help

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'...
www.mrexcel.com www.mrexcel.com
 
You must log in or register to reply here.
Back
Top