We are looking to get either an Access Database or Excel Macro Created that will utilize Lookup (xlookup) functions and will help clean and prep data for our production process. The data tool will extract the data from an XML file format and clean and then generate one Excel File with the prepped data in it.
We are looking to get something setup where when we expand our product catalog products that fall into existing categories of logic can easily be added by updating the spreadsheet, or down the road if we need to add additional sets of logic we can easily expand the macro.
We are also looking for a solution where it will be easy to update and maintain if conditions change where we need to further define or change the exporting format (i.e. if something is formula-driven vs hard coded)
I will share more detailed instructions with shortlisted candidates only.
*** This will be a multi-phase project with additional modules to add at a later date ***
** Our budget is flexible but we are more focused on having a good well-developed app **
About the recuiterMember since May 20, 2018 Iain R.
from Scotland, United Kingdom