VBA help

[namrfigk]

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.

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

VBA help - OzGrid Free Excel/VBA Help Forum

[xpost][/xpost] 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…

www.ozgrid.com

https://www.myonlinetraininghub.com/excel-forum/excel/vba-help

If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

Also here Help with VBA
and here VBA help